RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA944150" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 8 ✖

bioproject 1

  • PRJNA944150 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
3474438 3474438 PRJNA944150_P_NODE_35063_length_168_cov_1.403361_g34812_i0 PRJNA944150 35063 168 1.403361 2.35764648 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 300 4.56e-77   NTclustered gi|922689899|gb|CP012410.1| 712357 g34812 i0 98.81 390.25 168 2 100 0 1 168 53336 53503 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 65562 300 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
12402972 12402972 PRJNA944150_P_NODE_44470_length_161_cov_1.669643_g44219_i0 PRJNA944150 44470 161 1.669643 2.68812523 Leptotrichia wadei 157687 Bacteria Bacteria 250 4.42e-62   NTclustered gi|1708582457|dbj|AP019841.1| 157687 g44219 i0 97.931 0.900621118012422 145 2 89 1 1 144 1835812 1835668 Leptotrichia wadei JMUB3936 DNA, complete genome blastn 145 250 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
13677394 13677394 PRJNA944150_P_NODE_39011_length_165_cov_0.879310_g38760_i0 PRJNA944150 39011 165 0.87931 1.4508615 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 294 2.08e-75   NTclustered gi|1276705688|gb|CP024698.1| 2663009 g38760 i0 98.788 334.006060606061 165 2 100 0 1 165 241832 241996 Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome blastn 55111 294 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
15286999 15286999 PRJNA944150_P_NODE_28752_length_180_cov_1.061069_g28501_i0 PRJNA944150 28752 180 1.061069 1.9099242 Fusobacterium 848 Bacteria Bacteria 283 4.97e-72   NTclustered gi|2706038927|gb|CP056017.1| 76857 g28501 i0 95 99.0611111111111 180 9 100 0 1 180 1937519 1937340 Fusobacterium polymorphum strain SB009 chromosome, complete genome blastn 17831 283 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
18775410 18775410 PRJNA944150_P_NODE_33215_length_171_cov_1.934426_g32964_i0 PRJNA944150 33215 171 1.934426 3.30786846 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 246 6.1199999999999987e-61   NTclustered gi|922689899|gb|CP012410.1| 712357 g32964 i0 92.941 0.994152046783626 170 11 99 1 3 171 179484 179653 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 170 246 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
19110525 19110525 PRJNA944150_P_NODE_37035_length_166_cov_1.632479_g36784_i0 PRJNA944150 37035 166 1.632479 2.70991514 Fusobacterium 848 Bacteria Bacteria 291 2.7099999999999998e-74   NTclustered gi|1370537877|gb|CP028108.1| 860 g36784 i0 98.193 97.5602409638554 166 3 100 0 1 166 249027 248862 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 16195 291 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
22936940 22936940 PRJNA944150_P_NODE_41278_length_163_cov_2.254386_g41027_i0 PRJNA944150 41278 163 2.254386 3.67464918 Fusobacterium 848 Bacteria Bacteria 274 2.66e-69   NTclustered gi|2706424020|gb|CP077136.1| 76857 g41027 i0 96.933 99.9447852760736 163 5 100 0 1 163 516856 517018 Fusobacterium polymorphum strain KCOM3036 chromosome, complete genome blastn 16291 274 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
22936968 22936968 PRJNA944150_P_NODE_45318_length_161_cov_0.910714_g45067_i0 PRJNA944150 45318 161 0.910714 1.46624954 Fusobacterium 848 Bacteria Bacteria 298 1.56e-76   NTclustered gi|2573686249|gb|CP133474.1| 851 g45067 i0 100 98.6832298136646 161 0 100 0 1 161 1952508 1952668 Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome blastn 15888 298 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum

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);;