contig_metadata
12 rows where bioproject = "PRJNA577226" and tax_kingdom = "Fusobacteriati"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1137190 | 1137190 | PRJNA577226_S_NODE_2301_length_1185_cov_18.551394_g1203_i2 | PRJNA577226 | 2301 | 1185 | 18.551394 | 219.8340189 | Fusobacteriaceae | 203492 | Bacteria | Bacteria | 1884 | 0 | NTclustered | gi|2706496642|gb|CP084152.1| | 76857 | g1203 | i2 | 95.443 | 492.79746835443 | 1185 | 49 | 100 | 4 | 1 | 1185 | 2461744 | 2460565 | Fusobacterium polymorphum strain KCOM2594 chromosome, complete genome | blastn | 583965 | 1893 | 0.995245641838352 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 5665149 | 5665149 | PRJNA577226_S_NODE_24565_length_253_cov_5.944444_g23626_i0 | PRJNA577226 | 24565 | 253 | 5.944444 | 15.03944332 | Leptotrichia hofstadii | 157688 | Bacteria | Bacteria | 366 | 7.22e-97 | NTclustered | gi|1708566027|dbj|AP019823.1| | 157688 | g23626 | i0 | 92.885 | 143.00395256917 | 253 | 17 | 100 | 1 | 1 | 253 | 577294 | 577545 | Leptotrichia hofstadii JCM16775 DNA, complete genome | blastn | 36180 | 366 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia hofstadii | ||
| 8215313 | 8215313 | PRJNA577226_S_NODE_50287_length_176_cov_1.474820_g49348_i0 | PRJNA577226 | 50287 | 176 | 1.47482 | 2.5956832 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 259 | 8.15e-65 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g49348 | i0 | 93.182 | 5 | 176 | 12 | 100 | 0 | 1 | 176 | 51845 | 52020 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 880 | 259 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 10766792 | 10766792 | PRJNA577226_S_NODE_6269_length_548_cov_14.463796_g5345_i0 | PRJNA577226 | 6269 | 548 | 14.463796 | 79.26160208 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 846 | 0 | NTclustered | gi|2201062197|gb|CP092519.1| | 188913 | g5345 | i0 | 94.698 | 507.54197080292 | 547 | 26 | 99 | 3 | 1 | 547 | 49409 | 48866 | Cetobacterium somerae strain CS2105-BJ chromosome, complete genome | blastn | 278133 | 846 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 12616110 | 12616110 | PRJNA577226_S_NODE_16150_length_319_cov_108.755319_g15211_i0 | PRJNA577226 | 16150 | 319 | 108.755319 | 346.92946761 | Leptotrichia | 32067 | Bacteria | Bacteria | 507 | 5.31e-139 | NTclustered | gi|470484715|ref|NR_076664.1| | 40542 | g15211 | i0 | 95.298 | 500.862068965517 | 319 | 15 | 100 | 0 | 1 | 319 | 2271 | 1953 | Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence | blastn | 159775 | 507 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia buccalis | ||
| 15165755 | 15165755 | PRJNA577226_S_NODE_6292_length_547_cov_17.368627_g5367_i0 | PRJNA577226 | 6292 | 547 | 17.368627 | 95.00638969 | Fusobacterium | 848 | Bacteria | Bacteria | 1000 | 0 | NTclustered | gi|1370537877|gb|CP028108.1| | 860 | g5367 | i0 | 99.634 | 483.040219378428 | 547 | 2 | 100 | 0 | 1 | 547 | 461562 | 462108 | Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome | blastn | 264223 | 1005 | 0.995024875621891 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium periodonticum | ||
| 15165756 | 15165756 | PRJNA577226_S_NODE_63072_length_158_cov_3.958678_g62133_i0 | PRJNA577226 | 63072 | 158 | 3.958678 | 6.25471124 | Leptotrichia | 32067 | Bacteria | Bacteria | 241 | 2.6e-59 | NTclustered | gi|1227268105|gb|CP016753.1| | 712368 | g62133 | i0 | 94.805 | 68.3037974683544 | 154 | 8 | 97 | 0 | 5 | 158 | 594012 | 594165 | Leptotrichia sp. oral taxon 498, complete genome | blastn | 10792 | 241 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 498 | ||
| 16439846 | 16439846 | PRJNA577226_S_NODE_2313_length_1177_cov_13.361404_g1203_i3 | PRJNA577226 | 2313 | 1177 | 13.361404 | 157.26372508 | Cetobacterium | 180162 | Bacteria | Bacteria | 1753 | 0 | NTclustered | gi|2865366169|gb|CP122292.1| | 188913 | g1203 | i3 | 93.633 | 518.932030586236 | 1178 | 67 | 99 | 8 | 6 | 1177 | 1578199 | 1577024 | Cetobacterium somerae strain MSU41 chromosome, complete genome | blastn | 610783 | 1753 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 17715003 | 17715003 | PRJNA577226_S_NODE_13134_length_357_cov_117.271875_g12195_i0 | PRJNA577226 | 13134 | 357 | 117.271875 | 418.66059375 | Fusobacterium | 848 | Bacteria | Bacteria | 654 | 0 | NTclustered | gi|2573686249|gb|CP133474.1| | 851 | g12195 | i0 | 99.72 | 481.532212885154 | 357 | 1 | 100 | 0 | 1 | 357 | 321911 | 322267 | Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome | blastn | 171907 | 654 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 27711903 | 27711903 | PRJNA577226_S_NODE_9984_length_417_cov_2.323684_g9048_i0 | PRJNA577226 | 9984 | 417 | 2.323684 | 9.68976228 | Fusobacterium necrophorum | 859 | Bacteria | Bacteria | 45.1 | 0.0376 | NR | WP_261791110.1 | 859 | g9048 | i0 | 26.5 | 0.841726618705036 | 117 | 69 | 71.9 | 3 | 323 | 24 | 369 | 485 | WP_261791110.1 YadA-like family protein [Fusobacterium necrophorum] | diamond | 351 | 45.1 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium necrophorum | ||
| 30346427 | 30346427 | PRJNA577226_S_NODE_47732_length_180_cov_2.881119_g46793_i0 | PRJNA577226 | 47732 | 180 | 2.881119 | 5.1860142 | root | 1 | Root_unresolved | Root_unresolved | 65.9 | 1.11e-10 | NR | WP_021746646.1 | 157687 | g46793 | i0 | 49.2 | 2.83333333333333 | 59 | 29 | 96.7 | 1 | 176 | 3 | 668 | 726 | WP_021746646.1 ribonucleotide reductase N-terminal alpha domain-containing protein [Leptotrichia wadei] | diamond | 510 | 65.9 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 30630105 | 30630105 | PRJNA577226_S_NODE_58273_length_164_cov_1.748031_g57334_i0 | PRJNA577226 | 58273 | 164 | 1.748031 | 2.86677084 | FCB group | 1783270 | Bacteria | Bacteria | 54.7 | 7.75e-7 | NR | WP_021746646.1 | 157687 | g57334 | i0 | 47.2 | 2.8719512195122 | 53 | 28 | 97 | 0 | 5 | 163 | 612 | 664 | WP_021746646.1 ribonucleotide reductase N-terminal alpha domain-containing protein [Leptotrichia wadei] | diamond | 471 | 55.1 | 0.992740471869329 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei |
Advanced export
JSON shape: default, array, newline-delimited
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);;