RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA605033" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 9 ✖

bioproject 1

  • PRJNA605033 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
26668308 26668308 PRJNA605033_P_NODE_66341_length_222_cov_3.663102_g64772_i0 PRJNA605033 66341 222 3.663102 8.13208644 uncultured Leptotrichia sp. 159271 Bacteria Bacteria 51.2 2.79e-5   NR WP_295725541.1 159271 g64772 i0 88 0.337837837837838 25 3 33.8 0 75 1 199 223 WP_295725541.1 transposase [uncultured Leptotrichia sp.] diamond 75 51.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia uncultured Leptotrichia sp.
27206263 27206263 PRJNA605033_P_NODE_91142_length_222_cov_2.160428_g89573_i0 PRJNA605033 91142 222 2.160428 4.79615016 Caviibacter abscessus 1766719 Bacteria Bacteria 59.7 2.91e-8   NR WP_068268297.1 1766719 g89573 i0 45.7 0.945945945945946 70 26 94.6 1 221 12 324 381 WP_068268297.1 type I pullulanase [Caviibacter abscessus] diamond 210 59.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Caviibacter Caviibacter abscessus
27680588 27680588 PRJNA605033_P_NODE_109424_length_222_cov_1.802139_g107855_i0 PRJNA605033 109424 222 1.802139 4.00074858 uncultured Fusobacterium sp. 159267 Bacteria Bacteria 45.4 3.84e-4   NR WP_177161293.1 159267 g107855 i0 100 0.310810810810811 23 0 31.1 0 74 6 44 66 WP_177161293.1 hypothetical protein [uncultured Fusobacterium sp.] diamond 69 45.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium uncultured Fusobacterium sp.
28009390 28009390 PRJNA605033_P_NODE_114085_length_222_cov_1.727273_g112516_i0 PRJNA605033 114085 222 1.727273 3.83454606 Leptotrichia 32067 Bacteria Bacteria 55.5 9.1e-7   NR WP_015770424.1 40542 g112516 i0 92 0.662162162162162 25 2 33.8 0 3 77 186 210 WP_015770424.1 beta-glucoside-specific PTS transporter subunit IIABC [Leptotrichia buccalis] diamond 147 55.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia buccalis
28735445 28735445 PRJNA605033_P_NODE_41487_length_253_cov_1.284404_g39919_i0 PRJNA605033 41487 253 1.284404 3.24954212 Fusobacterium 848 Bacteria Bacteria 99.4 4.47e-22   NR WP_187106739.1 850 g39919 i0 52.6 2.79841897233202 78 37 92.5 0 245 12 263 340 WP_187106739.1 hypothetical protein [Fusobacterium mortiferum] diamond 708 99.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium mortiferum
29416731 29416731 PRJNA605033_P_NODE_21789_length_312_cov_1.906137_g20228_i0 PRJNA605033 21789 312 1.906137 5.94714744 Leptotrichia sp. oral taxon 847 1785996 Bacteria Bacteria 60.8 7.08e-10   NR WP_156440379.1 1785996 g20228 i0 53.7 1.55769230769231 54 25 51.9 0 150 311 11 64 WP_156440379.1 hypothetical protein [Leptotrichia sp. oral taxon 847] diamond 486 60.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 847
30111565 30111565 PRJNA605033_P_NODE_111272_length_222_cov_1.775401_g109703_i0 PRJNA605033 111272 222 1.775401 3.94139022 Fusobacterium nucleatum 851 Bacteria Bacteria 70.1 6.28e-12   NR WP_005904179.1 851 g109703 i0 53.4 0.986486486486487 73 30 98.6 1 220 2 24 92 WP_005904179.1 pseudaminic acid synthase [Fusobacterium nucleatum] diamond 219 70.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
30585405 30585405 PRJNA605033_P_NODE_131013_length_215_cov_2.833333_g129444_i0 PRJNA605033 131013 215 2.833333 6.09166595 Streptobacillus moniliformis 34105 Bacteria Bacteria 141 6.62e-42   NR WP_196759730.1 34105 g129444 i0 98.6 5.93023255813953 70 1 97.7 0 214 5 23 92 WP_196759730.1 NADH-quinone oxidoreductase subunit H, partial [Streptobacillus moniliformis] diamond 1275 141 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis
31091094 31091094 PRJNA605033_P_NODE_134495_length_211_cov_1.840909_g132926_i0 PRJNA605033 134495 211 1.840909 3.88431799 Fusobacterium massiliense 1852365 Bacteria Bacteria 77.8 1.05e-14   NR WP_074016936.1 1852365 g132926 i0 54.2 12.824644549763 59 27 83.9 0 33 209 250 308 WP_074016936.1 ATP-dependent zinc metalloprotease FtsH [Fusobacterium massiliense] diamond 2706 77.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium massiliense

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