RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1145997" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 12 ✖

bioproject 1

  • PRJNA1145997 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
12512175 12512175 PRJNA1145997_P_NODE_37650_length_284_cov_1.042654_g35031_i0 PRJNA1145997 37650 284 1.042654 2.96113736 Fusobacterium periodonticum 860 Bacteria Bacteria 142 8.38e-37   NR WP_314295179.1 860 g35031 i0 77.1 1.01408450704225 96 20 99.3 1 284 3 407 502 WP_314295179.1 autotransporter-associated N-terminal domain-containing protein [Fusobacterium periodonticum] diamond 288 142 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
18141212 18141212 PRJNA1145997_P_NODE_37115_length_288_cov_1.451163_g34496_i0 PRJNA1145997 37115 288 1.451163 4.17934944 Fusobacterium 848 Bacteria Bacteria 154 4.259999999999999e-42   NR WP_005903518.1 851 g34496 i0 85.4 9 96 14 100 0 1 288 381 476 WP_005903518.1 YfcC family protein [Fusobacterium nucleatum] diamond 2592 154 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
26785889 26785889 PRJNA1145997_P_NODE_38641_length_276_cov_2.029557_g36022_i0 PRJNA1145997 38641 276 2.029557 5.60157732 uncultured Leptotrichia sp. 159271 Bacteria Bacteria 169 9.18e-52   NR WP_295727188.1 159271 g36022 i0 84.8 1 92 14 100 0 1 276 12 103 WP_295727188.1 HAD domain-containing protein [uncultured Leptotrichia sp.] diamond 276 169 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia uncultured Leptotrichia sp.
27386825 27386825 PRJNA1145997_P_NODE_47983_length_244_cov_0.912281_g45364_i0 PRJNA1145997 47983 244 0.912281 2.22596564 Pseudostreptobacillus hongkongensis 1162717 Bacteria Bacteria 93.2 2.06e-20   NR WP_066895221.1 1162717 g45364 i0 85.7 0.602459016393443 49 7 60.2 0 244 98 293 341 WP_066895221.1 galactose/glucose ABC transporter substrate-binding protein MglB [Pseudostreptobacillus hongkongensis] diamond 147 93.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Pseudostreptobacillus Pseudostreptobacillus hongkongensis
27628358 27628358 PRJNA1145997_P_NODE_42024_length_254_cov_1.022099_g39405_i0 PRJNA1145997 42024 254 1.022099 2.59613146 Leptotrichia 32067 Bacteria Bacteria 74.7 8.23e-14   NR WP_125236415.1 2491048 g39405 i0 43.2 2.07874015748031 88 44 98 3 5 253 120 206 WP_125236415.1 hypothetical protein [Leptotrichia sp. OH3620_COT-345] diamond 528 74.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. OH3620_COT-345
28670199 28670199 PRJNA1145997_P_NODE_33447_length_328_cov_1.223529_g30828_i0 PRJNA1145997 33447 328 1.223529 4.01317512 Leptotrichia 32067 Bacteria Bacteria 195 3.8599999999999984e-55   NR WP_012806591.1 40542 g30828 i0 79.4 13.7378048780488 107 22 97.9 0 1 321 925 1031 WP_012806591.1 PolC-type DNA polymerase III [Leptotrichia buccalis] diamond 4506 196 0.994897959183674 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia buccalis
29596465 29596465 PRJNA1145997_P_NODE_47990_length_244_cov_0.912281_g45371_i0 PRJNA1145997 47990 244 0.912281 2.22596564 Leptotrichia sp. OH362 104608 Bacteria Bacteria 61.2 7.68e-9   NR WP_158612469.1 2491048 g45371 i0 83.3 0.885245901639344 36 6 44.3 0 243 136 236 271 WP_158612469.1 TrbG/VirB9 family P-type conjugative transfer protein [Leptotrichia sp. OH3620_COT-345] diamond 216 61.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. OH3620_COT-345
29627937 29627937 PRJNA1145997_P_NODE_41630_length_256_cov_1.704918_g39011_i0 PRJNA1145997 41630 256 1.704918 4.36459008 Fusobacterium massiliense 1852365 Bacteria Bacteria 110 3.86e-26   NR WP_315524165.1 1852365 g39011 i0 62.4 0.99609375 85 32 99.6 0 1 255 399 483 WP_315524165.1 peptidylprolyl isomerase [Fusobacterium massiliense] diamond 255 110 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium massiliense
30070468 30070468 PRJNA1145997_P_NODE_38532_length_277_cov_1.529412_g35913_i0 PRJNA1145997 38532 277 1.529412 4.23647124 Leptotrichia sp. OH362 104608 Bacteria Bacteria 54.7 2.54e-6   NR WP_125236398.1 2491048 g35913 i0 34.1 0.953068592057762 88 56 95.3 1 273 10 8 93 WP_125236398.1 type IV secretion system protein [Leptotrichia sp. OH3620_COT-345] diamond 264 54.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. OH3620_COT-345
30828823 30828823 PRJNA1145997_P_NODE_43394_length_251_cov_0.876404_g40775_i0 PRJNA1145997 43394 251 0.876404 2.19977404 Leptotrichiaceae bacterium 2782225 Bacteria Bacteria 58.2 2.46e-8   NR MDO5089649.1 2782225 g40775 i0 43.2 0.968127490039841 81 41 90.8 2 2 229 64 144 MDO5089649.1 hypothetical protein [Leptotrichiaceae bacterium] diamond 243 58.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae   Leptotrichiaceae bacterium
31777285 31777285 PRJNA1145997_P_NODE_46397_length_246_cov_0.901734_g43778_i0 PRJNA1145997 46397 246 0.901734 2.21826564 uncultured Fusobacterium sp. 159267 Bacteria Bacteria 53.9 9.51e-7   NR WP_294707213.1 159267 g43778 i0 92 0.304878048780488 25 2 30.5 0 2 76 108 132 WP_294707213.1 toxin-antitoxin system YwqK family antitoxin [uncultured Fusobacterium sp.] diamond 75 53.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium uncultured Fusobacterium sp.
32505231 32505231 PRJNA1145997_P_NODE_38699_length_276_cov_1.384236_g36080_i0 PRJNA1145997 38699 276 1.384236 3.82049136 Leptotrichia sp. 104608 Bacteria Bacteria 65.1 4.74e-11   NR MBF1333977.1 104608 g36080 i0 41.2 0.923913043478261 85 49 91.3 1 258 7 1 85 MBF1333977.1 hypothetical protein [Leptotrichia sp.] diamond 255 65.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.

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