contig_metadata
10 rows where bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3730882 | 3730882 | PRJNA690592_S_NODE_43663_length_466_cov_1.900763_g42649_i0 | PRJNA690592 | 43663 | 466 | 1.900763 | 8.85755558 | Fusobacterium | 848 | Bacteria | Bacteria | 58.4 | 0.001 | NTclustered | gi|2446175567|gb|CP117964.1| | 851 | g42649 | i0 | 94.595 | 6.74892703862661 | 37 | 2 | 8 | 0 | 76 | 112 | 1498720 | 1498756 | Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome | blastn | 3145 | 58.4 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 5007426 | 5007426 | PRJNA690592_S_NODE_6544_length_1081_cov_1.588294_g5957_i0 | PRJNA690592 | 6544 | 1081 | 1.588294 | 17.16945814 | Cetobacterium | 180162 | Bacteria | Bacteria | 1947 | 0 | NTclustered | gi|2865368125|gb|CP122294.1| | 188913 | g5957 | i0 | 99.167 | 523.894542090657 | 1081 | 9 | 100 | 0 | 1 | 1081 | 279753 | 278673 | Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence | blastn | 566330 | 1947 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 14700210 | 14700210 | PRJNA690592_S_NODE_184392_length_252_cov_1.251397_g183378_i0 | PRJNA690592 | 184392 | 252 | 1.251397 | 3.15352044 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 96.3 | 1.35e-23 | NR | WP_047381601.1 | 2630983 | g183378 | i0 | 85.9 | 0.761904761904762 | 64 | 9 | 76.2 | 0 | 249 | 58 | 1 | 64 | WP_047381601.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] | diamond | 192 | 96.3 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 15207531 | 15207531 | PRJNA690592_S_NODE_128172_length_296_cov_1.524664_g127158_i0 | PRJNA690592 | 128172 | 296 | 1.524664 | 4.51300544 | Cetobacterium | 180162 | Bacteria | Bacteria | 536 | 6.2199999999999986e-148 | NTclustered | gi|2666488225|gb|CP143319.1| | 188913 | g127158 | i0 | 99.324 | 5 | 296 | 2 | 100 | 0 | 1 | 296 | 1368463 | 1368758 | Cetobacterium somerae strain ceto chromosome, complete genome | blastn | 1480 | 536 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 24897579 | 24897579 | PRJNA690592_S_NODE_192660_length_249_cov_0.875000_g191646_i0 | PRJNA690592 | 192660 | 249 | 0.875 | 2.17875 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 359 | 1.19e-94 | NTclustered | gi|2201062197|gb|CP092519.1| | 188913 | g191646 | i0 | 92.742 | 98.8795180722892 | 248 | 18 | 99 | 0 | 1 | 248 | 1561215 | 1561462 | Cetobacterium somerae strain CS2105-BJ chromosome, complete genome | blastn | 24621 | 359 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 26892823 | 26892823 | PRJNA690592_S_NODE_174461_length_258_cov_3.410811_g173447_i0 | PRJNA690592 | 174461 | 258 | 3.410811 | 8.79989238 | Haliovirga abyssi | 2996794 | Bacteria | Bacteria | 47.8 | 7.08e-4 | NR | WP_307904513.1 | 2996794 | g173447 | i0 | 25.9 | 0.988372093023256 | 85 | 60 | 98.8 | 1 | 3 | 257 | 75 | 156 | WP_307904513.1 WD40 repeat domain-containing protein [Haliovirga abyssi] | diamond | 255 | 47.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Haliovirgaceae | Haliovirga | Haliovirga abyssi | ||
| 27082493 | 27082493 | PRJNA690592_S_NODE_208042_length_243_cov_1.823529_g207028_i0 | PRJNA690592 | 208042 | 243 | 1.823529 | 4.43117547 | Fusobacteriota bacterium | 2060921 | Bacteria | Bacteria | 49.7 | 1.35e-4 | NR | HCB64194.1 | 2060921 | g207028 | i0 | 60 | 1.1358024691358 | 45 | 17 | 54.3 | 1 | 1 | 132 | 400 | 444 | HCB64194.1 hypothetical protein [Fusobacteriota bacterium] | diamond | 276 | 49.7 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriota bacterium | ||||||
| 28882466 | 28882466 | PRJNA690592_S_NODE_36368_length_505_cov_17.368056_g35358_i0 | PRJNA690592 | 36368 | 505 | 17.368056 | 87.7086828 | Cetobacterium sp. NK | 2071632 | Bacteria | Bacteria | 46.2 | 0.029 | NR | WP_256690544.1 | 2993530 | g35358 | i0 | 32.2 | 0.534653465346535 | 90 | 52 | 52.9 | 4 | 410 | 144 | 824 | 905 | WP_256690544.1 autotransporter domain-containing protein [Cetobacterium sp. NK01] | diamond | 270 | 46.2 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. NK01 | ||
| 29356293 | 29356293 | PRJNA690592_S_NODE_9789_length_917_cov_10.800948_g9052_i0 | PRJNA690592 | 9789 | 917 | 10.800948 | 99.04469316 | Fusobacterium sp. | 68766 | Bacteria | Bacteria | 57.4 | 3.41e-6 | NR | WP_177162534.1 | 68766 | g9052 | i0 | 41.3 | 0.206106870229008 | 63 | 37 | 20.6 | 0 | 235 | 423 | 22 | 84 | WP_177162534.1 ankyrin repeat domain-containing protein [Fusobacterium sp.] | diamond | 189 | 57.4 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium sp. | ||
| 32874889 | 32874889 | PRJNA690592_S_NODE_27660_length_573_cov_1.700000_g26664_i0 | PRJNA690592 | 27660 | 573 | 1.7 | 9.741 | Bacteria | 2 | Bacteria | Bacteria | 100 | 7.91e-22 | NR | WP_032840617.1 | 851 | g26664 | i0 | 37.6 | 2.02094240837696 | 133 | 83 | 69.6 | 0 | 568 | 170 | 108 | 240 | WP_032840617.1 ABC transporter ATP-binding protein [Fusobacterium nucleatum] | diamond | 1158 | 100 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum |
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);;