RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1111146" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 15 ✖

bioproject 1

  • PRJNA1111146 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
1491293 1491293 PRJNA1111146_P_NODE_371362_length_181_cov_0.882812_g370224_i0 PRJNA1111146 371362 181 0.882812 1.59788972 Leptotrichia 32067 Bacteria Bacteria 111 1.09e-28   NR MBF1336844.1 104608 g370224 i0 100 1.98895027624309 60 0 99.4 0 180 1 36 95 MBF1336844.1 GTP-binding protein [Leptotrichia sp.] diamond 360 111 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
16794171 16794171 PRJNA1111146_P_NODE_59654_length_276_cov_1.013453_g58517_i0 PRJNA1111146 59654 276 1.013453 2.79713028 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 166 8.15e-50   NR WP_021767589.1 712359 g58517 i0 94.5 0.989130434782609 91 5 98.9 0 276 4 22 112 WP_021767589.1 hypothetical protein [Leptotrichia sp. oral taxon 215] diamond 273 166 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
24442031 24442031 PRJNA1111146_P_NODE_251160_length_196_cov_1.531469_g250022_i0 PRJNA1111146 251160 196 1.531469 3.00167924 Fusobacterium 848 Bacteria Bacteria 132 5.7199999999999985e-34   NR WP_249525283.1 851 g250022 i0 93.8 3.97959183673469 65 4 99.5 0 195 1 215 279 WP_249525283.1 autotransporter-associated N-terminal domain-containing protein [Fusobacterium nucleatum] diamond 780 132 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
27699963 27699963 PRJNA1111146_P_NODE_312244_length_185_cov_1.257576_g311106_i0 PRJNA1111146 312244 185 1.257576 2.3265156 Leptotrichia trevisanii 109328 Bacteria Bacteria 85.1 2.02e-17   NR WP_146997207.1 109328 g311106 i0 70 0.972972972972973 60 18 97.3 0 182 3 45 104 WP_146997207.1 autotransporter domain-containing protein [Leptotrichia trevisanii] diamond 180 85.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia trevisanii
27699965 27699965 PRJNA1111146_P_NODE_319544_length_184_cov_1.595420_g318406_i0 PRJNA1111146 319544 184 1.59542 2.9355728 uncultured Fusobacterium sp. 159267 Bacteria Bacteria 133 1.64e-36   NR WP_294066951.1 159267 g318406 i0 100 0.994565217391304 61 0 99.5 0 1 183 116 176 WP_294066951.1 ROK family protein [uncultured Fusobacterium sp.] diamond 183 133 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium uncultured Fusobacterium sp.
28394167 28394167 PRJNA1111146_P_NODE_201306_length_206_cov_1.450980_g200168_i0 PRJNA1111146 201306 206 1.45098 2.9890188 Leptotrichia wadei 157687 Bacteria Bacteria 90.1 2.16e-19   NR WP_146964119.1 157687 g200168 i0 66.2 1.89320388349515 65 22 94.7 0 201 7 4 68 WP_146964119.1 SMI1/KNR4 family protein [Leptotrichia wadei] diamond 390 90.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
28394198 28394198 PRJNA1111146_P_NODE_430886_length_177_cov_0.919355_g429748_i0 PRJNA1111146 430886 177 0.919355 1.62725835 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 118 7.129999999999999e-31   NR WP_021767922.1 712359 g429748 i0 96.6 1 59 2 100 0 1 177 26 84 WP_021767922.1 uroporphyrinogen decarboxylase family protein [Leptotrichia sp. oral taxon 215] diamond 177 118 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
28583841 28583841 PRJNA1111146_P_NODE_244667_length_197_cov_1.583333_g243529_i0 PRJNA1111146 244667 197 1.583333 3.11916601 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 77 1.39e-16   NR WP_021767135.1 712359 g243529 i0 86 0.654822335025381 43 6 65.5 0 131 3 1 43 WP_021767135.1 FtsB family cell division protein [Leptotrichia sp. oral taxon 215] diamond 129 77 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
28764271 28764271 PRJNA1111146_P_NODE_388367_length_180_cov_0.889764_g387229_i0 PRJNA1111146 388367 180 0.889764 1.6015752 Bacteria 2 Bacteria Bacteria 68.9 3.72e-12   NR STO27363.1 77917 g387229 i0 100 1 30 0 50 0 92 3 1 30 STO27363.1 Uncharacterized response regulatory protein SA0215 [Fusobacterium naviforme] diamond 180 68.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium naviforme
29088961 29088961 PRJNA1111146_P_NODE_350088_length_182_cov_1.263566_g348950_i0 PRJNA1111146 350088 182 1.263566 2.29969012 Streptobacillus moniliformis 34105 Bacteria Bacteria 46.2 2.87e-4   NR WP_064613702.1 34105 g348950 i0 76.7 0.494505494505495 30 7 49.5 0 161 72 3 32 WP_064613702.1 hypothetical protein, partial [Streptobacillus moniliformis] diamond 90 46.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis
30541717 30541717 PRJNA1111146_P_NODE_338213_length_183_cov_0.876923_g337075_i0 PRJNA1111146 338213 183 0.876923 1.60476909 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 78.6 3.8e-15   NR WP_036099800.1 712359 g337075 i0 97.4 0.639344262295082 39 1 63.9 0 183 67 422 460 WP_036099800.1 oxaloacetate decarboxylase subunit alpha [Leptotrichia sp. oral taxon 215] diamond 117 78.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
30889323 30889323 PRJNA1111146_P_NODE_193374_length_208_cov_0.929032_g192236_i0 PRJNA1111146 193374 208 0.929032 1.93238656 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 133 2.69e-34   NR WP_021767792.1 712359 g192236 i0 91.3 0.995192307692308 69 6 99.5 0 207 1 2925 2993 WP_021767792.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia sp. oral taxon 215] diamond 207 133 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
31711311 31711311 PRJNA1111146_P_NODE_181657_length_210_cov_1.452229_g180519_i0 PRJNA1111146 181657 210 1.452229 3.0496809 Fusobacterium polymorphum 76857 Bacteria Bacteria 76.3 3.68e-14   NR WP_336005213.1 76857 g180519 i0 83.7 0.614285714285714 43 7 61.4 0 130 2 1 43 WP_336005213.1 sacsin N-terminal ATP-binding-like domain-containing protein [Fusobacterium polymorphum] diamond 129 76.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
31869372 31869372 PRJNA1111146_P_NODE_302957_length_186_cov_1.714286_g301819_i0 PRJNA1111146 302957 186 1.714286 3.18857196 Fusobacterium naviforme 77917 Bacteria Bacteria 128 2.64e-35   NR KAB0575638.1 77917 g301819 i0 100 0.983870967741935 61 0 98.4 0 185 3 84 144 KAB0575638.1 N-formylglutamate amidohydrolase [Fusobacterium naviforme] diamond 183 128 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium naviforme
32659798 32659798 PRJNA1111146_P_NODE_387440_length_180_cov_0.889764_g386302_i0 PRJNA1111146 387440 180 0.889764 1.6015752 Fusobacterium naviforme 77917 Bacteria Bacteria 115 1.7299999999999999e-28   NR KAB0578349.1 77917 g386302 i0 100 0.983333333333333 59 0 98.3 0 2 178 216 274 KAB0578349.1 dihydroorotase [Fusobacterium naviforme] diamond 177 115 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium naviforme

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