RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA939415" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 13 ✖

bioproject 1

  • PRJNA939415 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
916193 916193 PRJNA939415_P_NODE_83001_length_251_cov_1.730337_g82579_i0 PRJNA939415 83001 251 1.730337 4.34314587 Fusobacterium nucleatum 851 Bacteria Bacteria 464 2.47e-126   NTclustered gi|2704975947|gb|CP077128.1| 851 g82579 i0 100 100.211155378486 251 0 100 0 1 251 290370 290120 Fusobacterium nucleatum strain KCOM3457 chromosome, complete genome blastn 25153 464 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
2191829 2191829 PRJNA939415_P_NODE_94842_length_241_cov_4.065476_g94420_i0 PRJNA939415 94842 241 4.065476 9.79779716 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 403 5.199999999999998e-108   NTclustered gi|922689899|gb|CP012410.1| 712357 g94420 i0 97.071 0.991701244813278 239 7 99 0 3 241 37654 37416 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 239 403 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
7294000 7294000 PRJNA939415_P_NODE_58586_length_275_cov_2.188119_g58164_i0 PRJNA939415 58586 275 2.188119 6.01732725 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 508 1.2499999999999999e-139   NTclustered gi|1276720946|gb|CP024705.1| 2663009 g58164 i0 100 12.2690909090909 275 0 100 0 1 275 696135 695861 Fusobacterium pseudoperiodonticum strain KCOM 2653 chromosome, complete genome blastn 3374 508 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
7294324 7294324 PRJNA939415_P_NODE_77746_length_256_cov_2.792350_g77324_i0 PRJNA939415 77746 256 2.79235 7.148416 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 468 1.95e-127   NTclustered gi|1276707709|gb|CP024699.1| 2663009 g77324 i0 99.609 99.859375 256 1 100 0 1 256 1298957 1298702 Fusobacterium pseudoperiodonticum strain KCOM 1261 chromosome, complete genome blastn 25564 468 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
7294366 7294366 PRJNA939415_P_NODE_80066_length_254_cov_1.563536_g79644_i0 PRJNA939415 80066 254 1.563536 3.97138144 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 470 5.37e-128   NTclustered gi|1276718681|gb|CP024704.1| 2663009 g79644 i0 100 493.397637795276 254 0 100 0 1 254 395322 395575 Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome blastn 125323 470 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
9842873 9842873 PRJNA939415_P_NODE_111148_length_201_cov_5.921875_g110726_i0 PRJNA939415 111148 201 5.921875 11.90296875 Fusobacterium polymorphum 76857 Bacteria Bacteria 344 2.5799999999999998e-90   NTclustered gi|2645882547|gb|CP141278.1| 76857 g110726 i0 97.512 99.9452736318408 201 5 100 0 1 201 2199000 2198800 Fusobacterium polymorphum strain 149A chromosome, complete genome blastn 20089 344 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
12735853 12735853 PRJNA939415_P_NODE_35930_length_302_cov_3.043668_g35508_i0 PRJNA939415 35930 302 3.043668 9.19187736 Ilyobacter 167639 Bacteria Bacteria 86.1 2.77e-12   NTclustered gi|2621703980|emb|OY762935.1| 544433 g35508 i0 94.545 27.9403973509934 55 3 18 0 142 196 72073 72127 MAG: uncultured Ilyobacter sp. isolate b034904b-4944-4ecc-b743-47c946c9bc96 genome assembly, chromosome: 1 blastn 8438 86.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Ilyobacter uncultured Ilyobacter sp.
13669452 13669452 PRJNA939415_P_NODE_60731_length_273_cov_2.045000_g60309_i0 PRJNA939415 60731 273 2.045 5.58285 Leptotrichia alba 3239304 Bacteria Bacteria 366 7.88e-97   NTclustered gi|2785244533|gb|CP165647.1| 3239304 g60309 i0 90.876 1.996336996337 274 23 100 2 1 273 1894478 1894750 Leptotrichia sp. HSP-536 chromosome, complete genome blastn 545 366 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia alba
14942708 14942708 PRJNA939415_P_NODE_106392_length_223_cov_4.246667_g105970_i0 PRJNA939415 106392 223 4.246667 9.47006741 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 405 1.32e-108   NTclustered gi|2704959642|gb|CP077196.1| 2663009 g105970 i0 99.55 99.5874439461883 222 1 99 0 2 223 38952 38731 Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome blastn 22208 405 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
16218281 16218281 PRJNA939415_P_NODE_31413_length_310_cov_2.936709_g30991_i0 PRJNA939415 31413 310 2.936709 9.1037979 Leptotrichia sp. SK-5 3075818 Bacteria Bacteria 510 3.98e-140   NTclustered gi|2899356158|dbj|AP028931.1| 3075818 g30991 i0 95.208 3.03225806451613 313 12 100 1 1 310 1823011 1823323 Leptotrichia sp. SK-5 DNA, complete genome blastn 940 510 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. SK-5
17494543 17494543 PRJNA939415_P_NODE_83294_length_251_cov_0.865169_g82872_i0 PRJNA939415 83294 251 0.865169 2.17157419 Fusobacterium polymorphum 76857 Bacteria Bacteria 459 1.1499999999999996e-124   NTclustered gi|2706504035|gb|CP084159.1| 76857 g82872 i0 99.602 81.4342629482072 251 1 100 0 1 251 128702 128452 Fusobacterium polymorphum strain KCOM1330 chromosome, complete genome blastn 20440 459 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
20042207 20042207 PRJNA939415_P_NODE_45656_length_288_cov_1.706977_g45234_i0 PRJNA939415 45656 288 1.706977 4.91609376 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 532 7.8e-147   NTclustered gi|1276714546|gb|CP024702.1| 2663009 g45234 i0 100 96.7013888888889 288 0 100 0 1 288 448779 449066 Fusobacterium pseudoperiodonticum strain KCOM 1282 chromosome, complete genome blastn 27850 532 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
22591863 22591863 PRJNA939415_P_NODE_108258_length_214_cov_5.368794_g107836_i0 PRJNA939415 108258 214 5.368794 11.48921916 Leptotrichia sp. oral taxon 221 712362 Bacteria Bacteria 379 7.609999999999999e-101   NTclustered gi|2028889048|gb|CP072378.1| 712362 g107836 i0 98.598 1 214 3 100 0 1 214 1094870 1094657 Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome blastn 214 379 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 221

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