contig_metadata
8 rows where bioproject = "PRJNA1237888" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1621284 | 1621284 | PRJNA1237888_S_NODE_3302_length_223_cov_2.425287_g3252_i0 | PRJNA1237888 | 3302 | 223 | 2.425287 | 5.40839001 | Candidatus Chromulinivorax destructor | 2066483 | Bacteria | Bacteria | 409 | 1.02e-109 | NTclustered | gi|1443103054|gb|CP025544.1| | 2066483 | g3252 | i0 | 100 | 102.434977578475 | 221 | 0 | 99 | 0 | 3 | 223 | 663774 | 663554 | Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome | blastn | 22843 | 409 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Chromulinivoraceae | Candidatus Chromulinivorax | Candidatus Chromulinivorax destructor | |||
| 5450157 | 5450157 | PRJNA1237888_S_NODE_7745_length_155_cov_2.933962_g7695_i0 | PRJNA1237888 | 7745 | 155 | 2.933962 | 4.5476411 | Candidatus Chromulinivorax destructor | 2066483 | Bacteria | Bacteria | 287 | 3.21e-73 | NTclustered | gi|1443103054|gb|CP025544.1| | 2066483 | g7695 | i0 | 100 | 177.61935483871 | 155 | 0 | 100 | 0 | 1 | 155 | 665043 | 665197 | Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome | blastn | 27531 | 287 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Chromulinivoraceae | Candidatus Chromulinivorax | Candidatus Chromulinivorax destructor | |||
| 6724488 | 6724488 | PRJNA1237888_S_NODE_1066_length_386_cov_1.952522_g1016_i0 | PRJNA1237888 | 1066 | 386 | 1.952522 | 7.53673492 | Candidatus Chromulinivorax destructor | 2066483 | Bacteria | Bacteria | 418 | 3.149999999999999e-112 | NTclustered | gi|1443103054|gb|CP025544.1| | 2066483 | g1016 | i0 | 87.297 | 65.3264248704663 | 370 | 41 | 95 | 5 | 1 | 368 | 664065 | 663700 | Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome | blastn | 25216 | 418 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Chromulinivoraceae | Candidatus Chromulinivorax | Candidatus Chromulinivorax destructor | |||
| 6724509 | 6724509 | PRJNA1237888_S_NODE_5506_length_176_cov_2.031496_g5456_i0 | PRJNA1237888 | 5506 | 176 | 2.031496 | 3.57543296 | Candidatus Chromulinivorax destructor | 2066483 | Bacteria | Bacteria | 326 | 7.92e-85 | NTclustered | gi|1443103054|gb|CP025544.1| | 2066483 | g5456 | i0 | 100 | 171.488636363636 | 176 | 0 | 100 | 0 | 1 | 176 | 664912 | 664737 | Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome | blastn | 30182 | 326 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Chromulinivoraceae | Candidatus Chromulinivorax | Candidatus Chromulinivorax destructor | |||
| 11825418 | 11825418 | PRJNA1237888_S_NODE_4730_length_189_cov_2.750000_g4680_i0 | PRJNA1237888 | 4730 | 189 | 2.75 | 5.1975 | Candidatus Chromulinivorax destructor | 2066483 | Bacteria | Bacteria | 350 | 5.14e-92 | NTclustered | gi|1443103054|gb|CP025544.1| | 2066483 | g4680 | i0 | 100 | 452.417989417989 | 189 | 0 | 100 | 0 | 1 | 189 | 663265 | 663077 | Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome | blastn | 85507 | 350 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Chromulinivoraceae | Candidatus Chromulinivorax | Candidatus Chromulinivorax destructor | |||
| 19472745 | 19472745 | PRJNA1237888_S_NODE_3816_length_209_cov_1.281250_g3766_i0 | PRJNA1237888 | 3816 | 209 | 1.28125 | 2.6778125 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 270 | 4.65e-68 | NTclustered | gi|2874254002|emb|OY970327.1| | 2890869 | g3766 | i0 | 89.952 | 483.153110047847 | 209 | 21 | 100 | 0 | 1 | 209 | 680685 | 680893 | MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1 | blastn | 100979 | 270 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 20748158 | 20748158 | PRJNA1237888_S_NODE_2117_length_280_cov_1.995671_g2067_i0 | PRJNA1237888 | 2117 | 280 | 1.995671 | 5.5878788 | Candidatus Chromulinivorax destructor | 2066483 | Bacteria | Bacteria | 516 | 7.61e-142 | NTclustered | gi|1443103054|gb|CP025544.1| | 2066483 | g2067 | i0 | 100 | 177.635714285714 | 279 | 0 | 99 | 0 | 2 | 280 | 665494 | 665216 | Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome | blastn | 49738 | 516 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Chromulinivoraceae | Candidatus Chromulinivorax | Candidatus Chromulinivorax destructor | |||
| 23299098 | 23299098 | PRJNA1237888_S_NODE_6159_length_168_cov_2.084034_g6109_i0 | PRJNA1237888 | 6159 | 168 | 2.084034 | 3.50117712 | Candidatus Chromulinivorax destructor | 2066483 | Bacteria | Bacteria | 311 | 2.11e-80 | NTclustered | gi|1443103054|gb|CP025544.1| | 2066483 | g6109 | i0 | 100 | 13.2857142857143 | 168 | 0 | 100 | 0 | 1 | 168 | 664596 | 664763 | Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome | blastn | 2232 | 311 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Chromulinivoraceae | Candidatus Chromulinivorax | Candidatus Chromulinivorax destructor |
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);;