contig_metadata
8 rows where bioproject = "PRJNA934472", tax_kingdom = "Pseudomonadati" and tax_phylum = "Abditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 911304 | 911304 | PRJNA934472_P_NODE_4881_length_619_cov_2.278388_g4572_i0 | PRJNA934472 | 4881 | 619 | 2.278388 | 14.10322172 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 739 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g4572 | i0 | 88.133 | 189.148626817448 | 632 | 61 | 100 | 9 | 1 | 619 | 2852145 | 2851515 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 117083 | 739 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 4739724 | 4739724 | PRJNA934472_P_NODE_9624_length_457_cov_2.611979_g9247_i0 | PRJNA934472 | 9624 | 457 | 2.611979 | 11.93674403 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 488 | 2.8499999999999995e-133 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g9247 | i0 | 86.057 | 302.98249452954 | 459 | 58 | 100 | 6 | 1 | 457 | 2851717 | 2851263 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 138463 | 488 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 6014551 | 6014551 | PRJNA934472_P_NODE_5005_length_612_cov_4.688312_g4696_i0 | PRJNA934472 | 5005 | 612 | 4.688312 | 28.69246944 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 270 | 1.5399999999999998e-67 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g4696 | i0 | 85.338 | 118.745098039216 | 266 | 33 | 85 | 6 | 348 | 610 | 2850969 | 2850707 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 72672 | 270 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 7288970 | 7288970 | PRJNA934472_P_NODE_19126_length_332_cov_2.073359_g18749_i0 | PRJNA934472 | 19126 | 332 | 2.073359 | 6.88355188 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 255 | 2.22e-63 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g18749 | i0 | 82.886 | 205.114457831325 | 298 | 37 | 87 | 13 | 12 | 300 | 2852463 | 2852171 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 68098 | 255 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 11114444 | 11114444 | PRJNA934472_P_NODE_17389_length_346_cov_4.589744_g17012_i0 | PRJNA934472 | 17389 | 346 | 4.589744 | 15.88051424 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 368 | 2.86e-97 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g17012 | i0 | 86.471 | 131.112716763006 | 340 | 40 | 97 | 6 | 10 | 346 | 2852809 | 2853145 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 45365 | 368 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 11114593 | 11114593 | PRJNA934472_P_NODE_24769_length_295_cov_1.387387_g24391_i0 | PRJNA934472 | 24769 | 295 | 1.387387 | 4.09279165 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 263 | 1.16e-65 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g24391 | i0 | 82.943 | 61.5254237288136 | 299 | 43 | 100 | 7 | 1 | 295 | 2851050 | 2850756 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 18150 | 263 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 14939182 | 14939182 | PRJNA934472_P_NODE_39332_length_236_cov_3.361963_g38954_i0 | PRJNA934472 | 39332 | 236 | 3.361963 | 7.93423268 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 387 | 5.11e-103 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g38954 | i0 | 96.581 | 307.474576271186 | 234 | 7 | 99 | 1 | 1 | 234 | 2853575 | 2853343 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 72564 | 387 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 22588228 | 22588228 | PRJNA934472_P_NODE_39018_length_240_cov_2.730539_g38640_i0 | PRJNA934472 | 39018 | 240 | 2.730539 | 6.5532936 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 165 | 2.66e-36 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g38640 | i0 | 85.802 | 1.35 | 162 | 16 | 66 | 6 | 82 | 240 | 2851023 | 2851180 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 324 | 165 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium |
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);;