RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA1158727" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 20 ✖

bioproject 1

  • PRJNA1158727 · 20 ✖

analysis 1

  • blastn · 20 ✖

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
2854966 2854966 PRJNA1158727_P_NODE_144343_length_248_cov_0.880000_g136881_i0 PRJNA1158727 144343 248 0.88 2.1824 Fusobacterium vincentii 155615 Bacteria Bacteria 444 3.17e-120   NTclustered gi|2706461406|gb|CP084075.1| 155615 g136881 i0 99.588 56.3064516129032 243 1 98 0 1 243 1180764 1181006 Fusobacterium vincentii strain SB055 plasmid pSB055A, complete sequence blastn 13964 444 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium vincentii
2855261 2855261 PRJNA1158727_P_NODE_160383_length_242_cov_0.911243_g152921_i0 PRJNA1158727 160383 242 0.911243 2.20520806 Fusobacterium polymorphum 76857 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|2078816781|gb|CP071094.1| 76857 g152921 i0 100 99.9338842975207 242 0 100 0 1 242 1983460 1983219 Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome blastn 24184 448 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
2855353 2855353 PRJNA1158727_P_NODE_164503_length_239_cov_3.439759_g157041_i0 PRJNA1158727 164503 239 3.439759 8.22102401 Leptotrichia sp. oral taxon 221 712362 Bacteria Bacteria 436 5.0799999999999985e-118   NTclustered gi|2028889048|gb|CP072378.1| 712362 g157041 i0 99.582 1 239 1 100 0 1 239 1158551 1158789 Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome blastn 239 436 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 221
3587965 3587965 PRJNA1158727_P_NODE_136463_length_251_cov_0.865169_g129001_i0 PRJNA1158727 136463 251 0.865169 2.17157419 Leptotrichia 32067 Bacteria Bacteria 392 1.18e-104   NTclustered gi|1708572621|dbj|AP019831.1| 109328 g129001 i0 97.391 66.6334661354582 230 6 99 0 22 251 1460868 1460639 Leptotrichia trevisanii JMUB3870 DNA, complete genome blastn 16725 394 0.99492385786802 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia trevisanii
4131099 4131099 PRJNA1158727_P_NODE_153084_length_244_cov_1.801170_g145622_i0 PRJNA1158727 153084 244 1.80117 4.3948548 Leptotrichia alba 3239304 Bacteria Bacteria 217 7.38e-52   NTclustered gi|2785244533|gb|CP165647.1| 3239304 g145622 i0 93.75 3.2172131147541 144 9 83 0 8 151 1551662 1551805 Leptotrichia sp. HSP-536 chromosome, complete genome blastn 785 217 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia alba
5406746 5406746 PRJNA1158727_P_NODE_127445_length_259_cov_1.322581_g119984_i0 PRJNA1158727 127445 259 1.322581 3.42548479 Leptotrichia sp. oral taxon 221 712362 Bacteria Bacteria 429 9.329999999999999e-116   NTclustered gi|2028889048|gb|CP072378.1| 712362 g119984 i0 96.525 15.3281853281853 259 9 100 0 1 259 1352598 1352856 Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome blastn 3970 429 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 221
6140688 6140688 PRJNA1158727_P_NODE_98065_length_296_cov_3.031390_g90604_i0 PRJNA1158727 98065 296 3.03139 8.9729144 Fusobacterium 848 Bacteria Bacteria 278 4.1700000000000005e-70   NTclustered gi|2706506546|gb|CP084156.1| 76857 g90604 i0 100 59.8682432432432 150 0 100 0 147 296 381422 381273 Fusobacterium polymorphum strain KCOM2510 chromosome blastn 17721 278 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
6681185 6681185 PRJNA1158727_P_NODE_111586_length_277_cov_2.186275_g104125_i0 PRJNA1158727 111586 277 2.186275 6.05598175 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 512 9.73e-141   NTclustered gi|2705022034|gb|CP084128.1| 2663009 g104125 i0 100 89.5415162454874 277 0 100 0 1 277 2215497 2215221 Fusobacterium pseudoperiodonticum strain KCOM1322 chromosome, complete genome blastn 24803 512 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
7415438 7415438 PRJNA1158727_P_NODE_151566_length_245_cov_0.895349_g144104_i0 PRJNA1158727 151566 245 0.895349 2.19360505 Fusobacterium 848 Bacteria Bacteria 448 2.41e-121   NTclustered gi|2444100754|gb|CP117525.1| 851 g144104 i0 99.592 89.5755102040816 245 1 100 0 1 245 1755850 1755606 Fusobacterium nucleatum strain FNV chromosome, complete genome blastn 21946 448 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
7957324 7957324 PRJNA1158727_P_NODE_151727_length_245_cov_0.895349_g144265_i0 PRJNA1158727 151727 245 0.895349 2.19360505 Fusobacterium nucleatum 851 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|1721134154|emb|LR698955.1| 851 g144265 i0 100 99.1632653061225 245 0 100 0 1 245 1505577 1505821 Fusobacterium nucleatum isolate MGYG-HGUT-01347 genome assembly, chromosome: 1 blastn 24295 453 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
9231830 9231830 PRJNA1158727_P_NODE_134268_length_251_cov_2.067416_g126806_i0 PRJNA1158727 134268 251 2.067416 5.18921416 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 436 5.369999999999999e-118   NTclustered gi|1276705688|gb|CP024698.1| 2663009 g126806 i0 98.008 98.2270916334661 251 5 100 0 1 251 2192746 2192996 Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome blastn 24655 436 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
9965708 9965708 PRJNA1158727_P_NODE_146868_length_247_cov_0.885057_g139406_i0 PRJNA1158727 146868 247 0.885057 2.18609079 Leptotrichia 32067 Bacteria Bacteria 451 1.88e-122   NTclustered gi|1791353085|dbj|AP019829.2| 157687 g139406 i0 99.595 10.9028340080972 247 1 100 0 1 247 1127055 1126809 Leptotrichia wadei JCM16777 DNA, complete genome blastn 2693 451 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
12516243 12516243 PRJNA1158727_P_NODE_142710_length_248_cov_1.382857_g135248_i0 PRJNA1158727 142710 248 1.382857 3.42948536 Fusobacterium 848 Bacteria Bacteria 453 5.2600000000000005e-123   NTclustered gi|586941090|dbj|AB910749.1| 860 g135248 i0 99.597 291.33064516129 248 1 100 0 1 248 251 4 Fusobacterium periodonticum gene for 16S ribosomal RNA, partial sequence blastn 72250 453 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
14332723 14332723 PRJNA1158727_P_NODE_130692_length_255_cov_1.692308_g123231_i0 PRJNA1158727 130692 255 1.692308 4.3153854 Leptotrichia sp. HMT-225 3058373 Bacteria Bacteria 416 7.129999999999998e-112   NTclustered gi|2557559843|gb|CP130323.1| 3058373 g123231 i0 96.078 10.9882352941176 255 10 100 0 1 255 1937633 1937379 Leptotrichia sp. HMT-225 chromosome, complete genome blastn 2802 416 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. HMT-225
15065137 15065137 PRJNA1158727_P_NODE_121492_length_265_cov_2.593750_g114031_i0 PRJNA1158727 121492 265 2.59375 6.8734375 Fusobacterium 848 Bacteria Bacteria 479 9.38e-131   NTclustered gi|2706069597|gb|CP077108.1| 76857 g114031 i0 99.245 479.332075471698 265 2 100 0 1 265 1186216 1185952 Fusobacterium polymorphum strain KCOM1281 chromosome, complete genome blastn 127023 479 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
19432342 19432342 PRJNA1158727_P_NODE_75316_length_354_cov_2.174377_g67855_i0 PRJNA1158727 75316 354 2.174377 7.69729458 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 599 9.539999999999998e-167   NTclustered gi|922689899|gb|CP012410.1| 712357 g67855 i0 97.175 414.471751412429 354 10 100 0 1 354 54099 53746 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 146723 599 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
20163924 20163924 PRJNA1158727_P_NODE_151536_length_245_cov_0.895349_g144074_i0 PRJNA1158727 151536 245 0.895349 2.19360505 Fusobacterium 848 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2704983719|gb|CP077132.1| 851 g144074 i0 100 99.8571428571429 245 0 100 0 1 245 1313274 1313518 Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome blastn 24465 453 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
21439404 21439404 PRJNA1158727_P_NODE_139637_length_249_cov_1.750000_g132175_i0 PRJNA1158727 139637 249 1.75 4.3575 Leptotrichia 32067 Bacteria Bacteria 411 3.2299999999999996e-110   NTclustered gi|1227268105|gb|CP016753.1| 712368 g132175 i0 96.386 3.95983935742972 249 9 100 0 1 249 1600341 1600093 Leptotrichia sp. oral taxon 498, complete genome blastn 986 411 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 498
23256495 23256495 PRJNA1158727_P_NODE_156619_length_243_cov_0.905882_g149157_i0 PRJNA1158727 156619 243 0.905882 2.20129326 Leptotrichia wadei 157687 Bacteria Bacteria 444 3.09e-120   NTclustered gi|1708575239|dbj|AP019834.1| 157687 g149157 i0 99.588 10 243 1 100 0 1 243 184002 183760 Leptotrichia wadei JMUB3933 DNA, complete genome blastn 2430 444 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
23989860 23989860 PRJNA1158727_P_NODE_165239_length_236_cov_2.417178_g157777_i0 PRJNA1158727 165239 236 2.417178 5.70454008 Fusobacterium 848 Bacteria Bacteria 436 4.999999999999999e-118   NTclustered gi|2706060605|gb|CP077187.1| 76859 g157777 i0 100 5 236 0 100 0 1 236 5595 5360 Fusobacterium animalis strain SB029 plasmid pSB029B, complete sequence blastn 1180 436 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium animalis

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