RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 23 ✖

bioproject 1

  • PRJEB20058 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
25748216 25748216 PRJEB20058_P_NODE_106842_length_392_cov_1.166163_g104034_i0 PRJEB20058 106842 392 1.166163 4.57135896 Fusobacteriota bacterium 2060921 Bacteria Bacteria 125 1.8099999999999999e-31   NR KAF0091675.1 2060921 g104034 i0 80.8 0.558673469387755 73 14 55.9 0 166 384 6 78 KAF0091675.1 MAG: diaminohydroxyphosphoribosylaminopyrimidine deaminase [Fusobacteriota bacterium] diamond 219 125 1 Bacteria   Fusobacteriati Fusobacteriota         Fusobacteriota bacterium
26058187 26058187 PRJEB20058_P_NODE_127981_length_349_cov_11.809028_g125162_i0 PRJEB20058 127981 349 11.809028 41.21350772 Bacteria 2 Bacteria Bacteria 70.1 3.36e-11   NR OQY08877.1 1971640 g125162 i0 34.3 6.24928366762178 108 71 92.8 0 1 324 635 742 OQY08877.1 MAG: hypothetical protein B6I28_04040 [Fusobacteriia bacterium 4572_132] diamond 2181 70.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia       Fusobacteriia bacterium 4572_132
26194484 26194484 PRJEB20058_P_NODE_127190_length_351_cov_1.493103_g124371_i0 PRJEB20058 127190 351 1.493103 5.24079153 Bacteria 2 Bacteria Bacteria 110 1.39e-26   NR MBZ4683887.1 2044942 g124371 i0 81.3 2.18803418803419 64 12 54.7 0 193 2 105 168 MBZ4683887.1 pyridoxal phosphate synthase yaaD subunit [Fusobacteriales bacterium] diamond 768 110 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales     Fusobacteriales bacterium
32910671 32910671 PRJEB20058_P_NODE_155745_length_305_cov_19.196721_g152922_i0 PRJEB20058 155745 305 19.196721 58.54999905 Leptotrichiaceae bacterium 2782225 Bacteria Bacteria 91.3 3.47e-20   NR MBP6125816.1 2782225 g152922 i0 72.2 0.531147540983607 54 15 53.1 0 7 168 76 129 MBP6125816.1 membrane protein insertase YidC [Leptotrichiaceae bacterium] diamond 162 91.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae   Leptotrichiaceae bacterium
32944794 32944794 PRJEB20058_P_NODE_129514_length_346_cov_500.129825_g126695_i0 PRJEB20058 129514 346 500.129825 1730.4491945 Fusobacterium necrophorum 859 Bacteria Bacteria 188 2e-59   NR WP_285056812.1 859 g126695 i0 99 0.841040462427746 97 1 84.1 0 292 2 16 112 WP_285056812.1 metal-dependent transcriptional regulator [Fusobacterium necrophorum] diamond 291 188 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium necrophorum
32957351 32957351 PRJEB20058_P_NODE_42746_length_643_cov_7.134021_g40082_i0 PRJEB20058 42746 643 7.134021 45.87175503 Bacteria 2 Bacteria Bacteria 59.3 2.69e-6   NR WP_285061131.1 859 g40082 i0 39.4 1.89424572317263 94 51 43.4 3 469 191 121 209 WP_285061131.1 terminase large subunit domain-containing protein [Fusobacterium necrophorum] diamond 1218 59.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium necrophorum
32980173 32980173 PRJEB20058_P_NODE_90507_length_432_cov_1.439353_g87709_i0 PRJEB20058 90507 432 1.439353 6.21800496 unclassified Cetobacterium 2630983 Bacteria Bacteria 174 3.37e-51   NR WP_081982672.1 2630983 g87709 i0 100 0.645833333333333 93 0 64.6 0 431 153 193 285 WP_081982672.1 MULTISPECIES: sugar ABC transporter permease [unclassified Cetobacterium] diamond 279 174 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
32991486 32991486 PRJEB20058_P_NODE_234795_length_226_cov_3.193939_g231970_i0 PRJEB20058 234795 226 3.193939 7.21830214 root 1 Root_unresolved Root_unresolved 42.7 0.0065   NR WP_187105728.1 859 g231970 i0 58 1.2212389380531 50 19 63.7 1 207 64 39 88 WP_187105728.1 hypothetical protein, partial [Fusobacterium necrophorum] diamond 276 42.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium necrophorum
32996397 32996397 PRJEB20058_P_NODE_194619_length_260_cov_8.904523_g191795_i0 PRJEB20058 194619 260 8.904523 23.1517598 Pseudostreptobacillus hongkongensis 1162717 Bacteria Bacteria 118 1.43e-31   NR WP_066895366.1 1162717 g191795 i0 88.4 0.796153846153846 69 8 79.6 0 207 1 5 73 WP_066895366.1 translation initiation factor IF-3 [Pseudostreptobacillus hongkongensis] diamond 207 118 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Pseudostreptobacillus Pseudostreptobacillus hongkongensis
32997082 32997082 PRJEB20058_P_NODE_93043_length_425_cov_2.151099_g90243_i0 PRJEB20058 93043 425 2.151099 9.14217075 Haliovirga abyssi 2996794 Bacteria Bacteria 180 6.08e-51   NR WP_307904538.1 2996794 g90243 i0 79.2 1.49647058823529 106 22 74.8 0 3 320 420 525 WP_307904538.1 biosynthetic-type acetolactate synthase large subunit [Haliovirga abyssi] diamond 636 180 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Haliovirgaceae Haliovirga Haliovirga abyssi
33025633 33025633 PRJEB20058_P_NODE_61180_length_535_cov_20.204641_g58418_i0 PRJEB20058 61180 535 20.204641 108.09482935 FCB group 1783270 Bacteria Bacteria 190 9.49e-56   NR WP_047396600.1 1339239 g58418 i0 100 1.64859813084112 98 0 55 0 302 9 1 98 WP_047396600.1 replication initiation protein [Cetobacterium sp. ZOR0034] diamond 882 190 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZOR0034
33030687 33030687 PRJEB20058_P_NODE_207684_length_251_cov_0.936842_g204860_i0 PRJEB20058 207684 251 0.936842 2.35147342 unclassified Cetobacterium 2630983 Bacteria Bacteria 145 8.139999999999997e-42   NR WP_047381160.1 2630983 g204860 i0 98.7 0.920318725099602 77 1 92 0 21 251 1 77 WP_047381160.1 MULTISPECIES: chorismate mutase [unclassified Cetobacterium] diamond 231 145 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
33030870 33030870 PRJEB20058_P_NODE_242492_length_210_cov_4.765101_g239667_i0 PRJEB20058 242492 210 4.765101 10.0067121 Fusobacterium periodonticum 860 Bacteria Bacteria 98.6 5.24e-22   NR WP_005966283.1 860 g239667 i0 86.9 0.871428571428571 61 8 87.1 0 184 2 127 187 WP_005966283.1 UvrD-helicase domain-containing protein [Fusobacterium periodonticum] diamond 183 98.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
33064488 33064488 PRJEB20058_P_NODE_170693_length_286_cov_16.311111_g167870_i0 PRJEB20058 170693 286 16.311111 46.64977746 Streptobacillus canis 2678686 Bacteria Bacteria 105 2.77e-25   NR WP_156299308.1 2678686 g167870 i0 65.8 0.797202797202797 76 26 79.7 0 56 283 146 221 WP_156299308.1 site-2 protease family protein [Streptobacillus canis] diamond 228 105 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus canis
33081572 33081572 PRJEB20058_P_NODE_178438_length_278_cov_0.976959_g175615_i0 PRJEB20058 178438 278 0.976959 2.71594602 Fusobacterium naviforme 77917 Bacteria Bacteria 182 5.759999999999999e-57   NR KAB0577826.1 77917 g175615 i0 97.8 0.982014388489209 91 2 98.2 0 273 1 55 145 KAB0577826.1 YbaK/EbsC family protein [Fusobacterium naviforme] diamond 273 182 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium naviforme
33081940 33081940 PRJEB20058_P_NODE_239558_length_216_cov_6.993548_g236733_i0 PRJEB20058 239558 216 6.993548 15.10606368 Fusobacterium sp. oral taxon 37 68766 Bacteria Bacteria 65.1 3.73e-12   NR WP_158306654.1 712288 g236733 i0 53.7 0.75 54 25 75 0 36 197 1 54 WP_158306654.1 hypothetical protein [Fusobacterium sp. oral taxon 370] diamond 162 65.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp. oral taxon 370
33093841 33093841 PRJEB20058_P_NODE_76694_length_474_cov_2.355932_g73916_i0 PRJEB20058 76694 474 2.355932 11.16711768 Bacteria 2 Bacteria Bacteria 182 2.68e-51   NR WP_304178784.1 109328 g73916 i0 62.5 4.82278481012658 152 51 96.2 3 472 17 393 538 WP_304178784.1 hypothetical protein [Leptotrichia trevisanii] diamond 2286 183 0.994535519125683 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia trevisanii
33132409 33132409 PRJEB20058_P_NODE_108055_length_389_cov_4.161585_g105244_i0 PRJEB20058 108055 389 4.161585 16.18856565 Cetobacterium sp. ZWU 2071632 Bacteria Bacteria 242 2.01e-72   NR WP_047384830.1 1340502 g105244 i0 100 0.917737789203085 119 0 91.8 0 19 375 333 451 WP_047384830.1 hypothetical protein [Cetobacterium sp. ZWU0022] diamond 357 242 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZWU0022
33149646 33149646 PRJEB20058_P_NODE_147888_length_317_cov_1.390625_g145067_i0 PRJEB20058 147888 317 1.390625 4.40828125 Cetobacterium sp. ZOR 2071632 Bacteria Bacteria 224 3.26e-71   NR WP_047395781.1 1339239 g145067 i0 100 0.993690851735016 105 0 99.4 0 317 3 150 254 WP_047395781.1 hypothetical protein [Cetobacterium sp. ZOR0034] diamond 315 224 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZOR0034
33161892 33161892 PRJEB20058_P_NODE_248096_length_198_cov_9.204380_g245271_i0 PRJEB20058 248096 198 9.20438 18.2246724 Leptotrichia 32067 Bacteria Bacteria 108 1.1300000000000002e-27   NR MBF1337602.1 104608 g245271 i0 91.7 1.81818181818182 60 5 90.9 0 180 1 79 138 MBF1337602.1 phosphoglucosamine mutase [Leptotrichia sp.] diamond 360 108 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
33166844 33166844 PRJEB20058_P_NODE_173960_length_283_cov_1.153153_g171137_i0 PRJEB20058 173960 283 1.153153 3.26342299 Fusobacterium naviforme 77917 Bacteria Bacteria 124 3.5600000000000004e-33   NR KAB0577559.1 77917 g171137 i0 100 0.657243816254417 62 0 65.7 0 261 76 161 222 KAB0577559.1 L-serine ammonia-lyase, iron-sulfur-dependent, subunit beta [Fusobacterium naviforme] diamond 186 124 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium naviforme
33167153 33167153 PRJEB20058_P_NODE_231152_length_230_cov_8.319527_g228327_i0 PRJEB20058 231152 230 8.319527 19.1349121 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 103 6.330000000000001e-27   NR WP_314320536.1 2663009 g228327 i0 90.7 1.40869565217391 54 5 70.4 0 209 48 18 71 WP_314320536.1 GIY-YIG nuclease family protein [Fusobacterium pseudoperiodonticum] diamond 324 103 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
33167183 33167183 PRJEB20058_P_NODE_237296_length_221_cov_5.681250_g234471_i0 PRJEB20058 237296 221 5.68125 12.5555625 Pseudoleptotrichia goodfellowii 157692 Bacteria Bacteria 63.5 1.4e-11   NR MBF4805340.1 157692 g234471 i0 67.4 1.91402714932127 43 14 58.4 0 61 189 1 43 MBF4805340.1 hypothetical protein [Pseudoleptotrichia goodfellowii] diamond 423 63.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Pseudoleptotrichia Pseudoleptotrichia goodfellowii

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