RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA939369" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA939369 · 7 ✖

analysis 1

  • blastn · 7 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
3465172 3465172 PRJNA939369_S_NODE_38643_length_279_cov_1.868932_g38226_i0 PRJNA939369 38643 279 1.868932 5.21432028 Helicobacter gastrofelis 2849642 Bacteria Bacteria 52.8 0.026   NTclustered gi|2065538474|dbj|AP024819.1| 2849642 g38226 i0 100 0.100358422939068 28 0 10 0 142 169 1226367 1226340 Helicobacter sp. NHP19-012 DNA, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter gastrofelis
4742730 4742730 PRJNA939369_S_NODE_43464_length_269_cov_16.979592_g43047_i0 PRJNA939369 43464 269 16.979592 45.67510248 Malaciobacter marinus 505249 Bacteria Bacteria 52.8 0.025   NTclustered gi|1474785413|gb|CP032101.1| 505249 g43047 i0 100 0.104089219330855 28 0 10 0 143 170 1771291 1771318 Malaciobacter marinus strain JCM 15502 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Malaciobacter Malaciobacter marinus
7292441 7292441 PRJNA939369_S_NODE_30846_length_298_cov_1.777778_g30429_i0 PRJNA939369 30846 298 1.777778 5.29777844 Helicobacter rodentium 59617 Bacteria Bacteria 451 2.34e-122   NTclustered gi|50957140|gb|AY596225.1| 59617 g30429 i0 94.521 128.231543624161 292 16 98 0 4 295 1538 1829 Helicobacter rodentium strain MIT 95-1707 23S ribosomal RNA gene, partial sequence blastn 38213 451 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter rodentium
12393567 12393567 PRJNA939369_S_NODE_44930_length_267_cov_1.046392_g44513_i0 PRJNA939369 44930 267 1.046392 2.79386664 Poseidonibacter lekithochrous 1904463 Bacteria Bacteria 54.7 0.007   NTclustered gi|1850313845|gb|CP054052.1| 1904463 g44513 i0 92.105 0.142322097378277 38 3 14 0 163 200 1360266 1360303 Poseidonibacter lekithochrous strain DSM 100870 chromosome, complete genome blastn 38 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Poseidonibacter Poseidonibacter lekithochrous
13667935 13667935 PRJNA939369_S_NODE_3291_length_634_cov_4.602496_g2890_i0 PRJNA939369 3291 634 4.602496 29.17982464 Helicobacter sp. MIT 99-5507 152489 Bacteria Bacteria 1096 0   NTclustered gi|50957179|gb|AY596264.1| 152489 g2890 i0 98.395 147.017350157729 623 10 98 0 12 634 1089 467 Helicobacter sp. MIT 99-5507 23S ribosomal RNA gene, partial sequence blastn 93209 1096 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter sp. MIT 99-5507
20040936 20040936 PRJNA939369_S_NODE_2856_length_672_cov_3.457429_g2460_i0 PRJNA939369 2856 672 3.457429 23.23392288 Helicobacter sp. MIT 99-5507 152489 Bacteria Bacteria 1230 0   NTclustered gi|50957179|gb|AY596264.1| 152489 g2460 i0 99.851 139.712797619048 669 1 99 0 4 672 1675 1007 Helicobacter sp. MIT 99-5507 23S ribosomal RNA gene, partial sequence blastn 93887 1230 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter sp. MIT 99-5507
25482664 25482664 PRJNA939369_S_NODE_59520_length_249_cov_0.875000_g59103_i0 PRJNA939369 59520 249 0.875 2.17875 Arcobacter 28196 Bacteria Bacteria 56.5 0.002   NTclustered gi|1847331607|gb|CP053835.1| 873191 g59103 i0 94.595 0.29718875502008 37 1 15 1 136 172 2566064 2566099 Arcobacter defluvii strain LMG 25694 chromosome, complete genome blastn 74 56.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter defluvii

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;