RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 18 ✖

bioproject 1

  • PRJEB10140 · 18 ✖

analysis 1

  • blastn · 18 ✖

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
12372 12372 PRJEB10140_P_NODE_245521_length_169_cov_0.866667_g228212_i0 PRJEB10140 245521 169 0.866667 1.46466723 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 300 4.56e-77   NTclustered gi|922689899|gb|CP012410.1| 712357 g228212 i0 98.81 0.994082840236686 168 2 99 0 1 168 357212 357379 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 168 300 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
2562633 2562633 PRJEB10140_P_NODE_272063_length_165_cov_0.887931_g254754_i0 PRJEB10140 272063 165 0.887931 1.46508615 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 300 4.46e-77   NTclustered gi|1276709865|gb|CP024700.1| 2663009 g254754 i0 99.394 55.5636363636364 165 1 100 0 1 165 334776 334940 Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome blastn 9168 300 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
3837843 3837843 PRJEB10140_P_NODE_143744_length_257_cov_1.187500_g126436_i0 PRJEB10140 143744 257 1.1875 3.051875 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 470 5.45e-128   NTclustered gi|2705022034|gb|CP084128.1| 2663009 g126436 i0 99.611 64.6303501945525 257 1 100 0 1 257 1408533 1408277 Fusobacterium pseudoperiodonticum strain KCOM1322 chromosome, complete genome blastn 16610 470 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
3839094 3839094 PRJEB10140_P_NODE_284284_length_163_cov_0.903509_g266975_i0 PRJEB10140 284284 163 0.903509 1.47271967 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 302 1.22e-77   NTclustered gi|1276705688|gb|CP024698.1| 2663009 g266975 i0 100 98.7546012269939 163 0 100 0 1 163 1895909 1895747 Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome blastn 16097 302 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
8939406 8939406 PRJEB10140_P_NODE_250708_length_168_cov_0.873950_g233399_i0 PRJEB10140 250708 168 0.87395 1.468236 Fusobacterium ulcerans 861 Bacteria Bacteria 305 9.81e-79   NTclustered gi|1370545701|gb|CP028105.1| 861 g233399 i0 99.405 10.9940476190476 168 1 100 0 1 168 1528765 1528932 Fusobacterium ulcerans strain ATCC 49185 chromosome, complete genome blastn 1847 305 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium ulcerans
10215642 10215642 PRJEB10140_P_NODE_280509_length_163_cov_1.368421_g263200_i0 PRJEB10140 280509 163 1.368421 2.23052623 Leptotrichia wadei 157687 Bacteria Bacteria 285 1.23e-72   NTclustered gi|1708582457|dbj|AP019841.1| 157687 g263200 i0 98.16 20.8895705521472 163 3 100 0 1 163 1661395 1661233 Leptotrichia wadei JMUB3936 DNA, complete genome blastn 3405 285 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
10215877 10215877 PRJEB10140_P_NODE_37309_length_946_cov_42.069119_g6971_i2 PRJEB10140 37309 946 42.069119 397.97386574 Leptotrichia mesophila 3239303 Bacteria Bacteria 54.7 0.027   NTclustered gi|2785242249|gb|CP165646.1| 3239303 g6971 i2 100 0.0306553911205074 29 0 3 0 605 633 1607872 1607900 Leptotrichia sp. HSP-342 chromosome, complete genome blastn 29 54.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia mesophila
12461508 12461508 PRJEB10140_P_NODE_69330_length_529_cov_27.254167_g52233_i0 PRJEB10140 69330 529 27.254167 144.17454343 Fusobacterium 848 Bacteria Bacteria 58.4 0.001   NTclustered gi|2706041172|gb|CP056018.1| 76857 g52233 i0 94.595 2.38185255198488 37 2 7 0 340 376 1052087 1052051 Fusobacterium polymorphum strain SB006 chromosome, complete genome blastn 1260 58.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
12766211 12766211 PRJEB10140_P_NODE_265311_length_166_cov_0.880342_g248002_i0 PRJEB10140 265311 166 0.880342 1.46136772 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 307 2.69e-79   NTclustered gi|2704959642|gb|CP077196.1| 2663009 g248002 i0 100 72.0060240963855 166 0 100 0 1 166 1407345 1407180 Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome blastn 11953 307 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
13735775 13735775 PRJEB10140_P_NODE_271431_length_165_cov_0.887931_g254122_i0 PRJEB10140 271431 165 0.887931 1.46508615 Fusobacterium 848 Bacteria Bacteria 305 9.59e-79   NTclustered gi|2446175567|gb|CP117964.1| 851 g254122 i0 100 99.2242424242424 165 0 100 0 1 165 920516 920352 Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome blastn 16372 305 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
17559936 17559936 PRJEB10140_P_NODE_141994_length_260_cov_0.985782_g124686_i0 PRJEB10140 141994 260 0.985782 2.5630332 Fusobacterium 848 Bacteria Bacteria 58.4 5.09e-4   NTclustered gi|2706435836|gb|CP077154.1| 76857 g124686 i0 94.595 0.853846153846154 37 2 14 0 43 79 1829854 1829818 Fusobacterium polymorphum strain KCOM1267 chromosome, complete genome blastn 222 58.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
17865137 17865137 PRJEB10140_P_NODE_81715_length_448_cov_4.092732_g64456_i0 PRJEB10140 81715 448 4.092732 18.33543936 Fusobacterium nucleatum 851 Bacteria Bacteria 56.5 0.003   NTclustered gi|2444100754|gb|CP117525.1| 851 g64456 i0 96.97 0.0736607142857143 33 1 7 0 384 416 1892650 1892682 Fusobacterium nucleatum strain FNV chromosome, complete genome blastn 33 56.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
18834136 18834136 PRJEB10140_P_NODE_284095_length_163_cov_0.903509_g266786_i0 PRJEB10140 284095 163 0.903509 1.47271967 Leptotrichia 32067 Bacteria Bacteria 302 1.22e-77   NTclustered gi|1227268105|gb|CP016753.1| 712368 g266786 i0 100 4 163 0 100 0 1 163 1484630 1484468 Leptotrichia sp. oral taxon 498, complete genome blastn 652 302 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 498
21688756 21688756 PRJEB10140_P_NODE_217358_length_184_cov_1.518519_g200049_i0 PRJEB10140 217358 184 1.518519 2.79407496 Fusobacterium nucleatum 851 Bacteria Bacteria 340 2.99e-89   NTclustered gi|2704998788|gb|CP077147.1| 851 g200049 i0 100 100 184 0 100 0 1 184 410024 409841 Fusobacterium nucleatum strain KCOM2373 chromosome, complete genome blastn 18400 340 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
22659017 22659017 PRJEB10140_P_NODE_126778_length_289_cov_1.679167_g109471_i0 PRJEB10140 126778 289 1.679167 4.85279263 Fusobacterium 848 Bacteria Bacteria 54.7 0.007   NTclustered gi|2705042081|gb|CP085192.1| 856 g109471 i0 90.476 0.491349480968858 42 2 15 2 50 91 2915033 2915072 Fusobacterium varium strain SB069 chromosome blastn 142 54.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium varium
22659155 22659155 PRJEB10140_P_NODE_195198_length_199_cov_1.360000_g177889_i0 PRJEB10140 195198 199 1.36 2.7064 Fusobacterium 848 Bacteria Bacteria 54.7 0.005   NTclustered gi|2705032171|gb|CP084140.1| 851 g177889 i0 96.875 1.44723618090452 32 1 16 0 78 109 518909 518878 Fusobacterium nucleatum strain KCOM3187 chromosome, complete genome blastn 288 54.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
22963479 22963479 PRJEB10140_P_NODE_135519_length_271_cov_2.126126_g118212_i0 PRJEB10140 135519 271 2.126126 5.76180146 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 52.8 0.025   NTclustered gi|1276720946|gb|CP024705.1| 2663009 g118212 i0 94.286 0.129151291512915 35 1 13 1 123 156 1384797 1384763 Fusobacterium pseudoperiodonticum strain KCOM 2653 chromosome, complete genome blastn 35 52.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
23934771 23934771 PRJEB10140_P_NODE_284279_length_163_cov_0.903509_g266970_i0 PRJEB10140 284279 163 0.903509 1.47271967 Fusobacterium 848 Bacteria Bacteria 302 1.22e-77   NTclustered gi|2706407748|gb|CP077116.1| 76857 g266970 i0 100 43 163 0 100 0 1 163 1888533 1888371 Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome blastn 7009 302 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum

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