Access sequence in the NCBI website'; } $fichseq=mysql_query("SELECT DISTINCT sequences.Type, sequences.Reference, sequences.Sequence, sequences.Variety, sequences.idSequence, sequences.idClade, sequences.Accession, sequences.Definition, sequences.Length, sequences.PMID, sequences.Title, sequences.Comment, sequences.Synonym, sequences.Accepted, sequences.ReasonReject, marker.Marker, genus.Genus, current_name.Specy, clade.Clade, sequences.Organism, sequences.Length, sequences.Strain FROM sequences, marker, current_name, clade, genus WHERE sequences.idMarker=marker.idMarker AND sequences.idCurrent_Name=current_name.idCurrent_Name AND sequences.idClade=clade.idClade AND genus.idGenus=current_name.idGenus AND sequences.Accession='$Accession'") or die ("requète non executé"); if (! $fichseq) { echo "Request error"; exit;} while ($data=mysql_fetch_array($fichseq)) { echo '
| SEQUENCE '.$data["idSequence"].' | '; echo 'STRAIN | '; echo '
|---|---|
| References: '.$data["Reference"].' | '; echo 'Current name: '.$data['Genus'].' '.$data['Specy'].' Variety: '.$data['Variety'].' Clade: '.$data['Clade'].' Synonym cited in NCBI: '.$data['Organism'].' | ';
echo '
| Definition: '.$data["Definition"].' Marker: '.$data["Marker"].' Type: '.$data["Type"].' | ';
echo 'Strain: '.$data["Strain"].' | '; echo '
Sequence: '.$data["Sequence"].' | ';
echo 'Synonym: '.nl2br(htmlentities($data['Synonym'])).' | '; echo '
| Number of N in sequence: '.substr_count($data["Sequence"], 'N').' | '; echo ''; echo ' |
| Length: '.$data["Length"].' bp | '; echo ''; echo ' |
| PMID: '.$data["PMID"].' | '; echo ''; echo ' |
| Article: '.$data["Title"].' | ';
echo 'Comment: '.$data['Comment'].' | '; echo '
'; echo '
'; mysql_free_result($fichseq); mysql_close(); ?>