contig_metadata
6 rows where bioproject = "PRJNA630162" and tax_phylum = "Calditrichota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3152284 | 3152284 | PRJNA630162_P_NODE_103603_length_183_cov_2.477612_g102080_i0 | PRJNA630162 | 103603 | 183 | 2.477612 | 4.53402996 | Caldithrix abyssi | 187145 | Bacteria | Bacteria | 113 | 7.050000000000001e-21 | NTclustered | gi|1108618394|gb|CP018099.1| | 880073 | g102080 | i0 | 93.421 | 207.704918032787 | 76 | 5 | 42 | 0 | 108 | 183 | 1053782 | 1053857 | Caldithrix abyssi DSM 13497, complete genome | blastn | 38010 | 113 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichia | Calditrichales | Calditrichaceae | Caldithrix | Caldithrix abyssi | ||
| 24828134 | 24828134 | PRJNA630162_P_NODE_162400_length_161_cov_6.473214_g160877_i0 | PRJNA630162 | 162400 | 161 | 6.473214 | 10.42187454 | Caldithrix abyssi | 187145 | Bacteria | Bacteria | 158 | 2.76e-34 | NTclustered | gi|1108618394|gb|CP018099.1| | 880073 | g160877 | i0 | 90.756 | 122.937888198758 | 119 | 9 | 73 | 2 | 43 | 160 | 1053740 | 1053857 | Caldithrix abyssi DSM 13497, complete genome | blastn | 19793 | 158 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichia | Calditrichales | Calditrichaceae | Caldithrix | Caldithrix abyssi | ||
| 26922440 | 26922440 | PRJNA630162_P_NODE_100302_length_185_cov_2.514706_g98779_i0 | PRJNA630162 | 100302 | 185 | 2.514706 | 4.6522061 | Calditrichota bacterium | 2212469 | Bacteria | Bacteria | 73.2 | 3.18e-13 | NR | RMF56515.1 | 2212469 | g98779 | i0 | 57.4 | 5.88648648648649 | 61 | 26 | 98.9 | 0 | 1 | 183 | 146 | 206 | RMF56515.1 MAG: polyribonucleotide nucleotidyltransferase [Calditrichota bacterium] | diamond | 1089 | 73.2 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichota bacterium | ||||||
| 27460122 | 27460122 | PRJNA630162_P_NODE_27803_length_345_cov_1.320946_g26281_i0 | PRJNA630162 | 27803 | 345 | 1.320946 | 4.5572637 | Calditrichota bacterium | 2212469 | Bacteria | Bacteria | 59.3 | 1.87e-7 | NR | RMD95280.1 | 2212469 | g26281 | i0 | 58.3 | 0.817391304347826 | 48 | 19 | 41.7 | 1 | 340 | 197 | 160 | 206 | RMD95280.1 MAG: choice-of-anchor D domain-containing protein, partial [Calditrichota bacterium] | diamond | 282 | 59.3 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichota bacterium | ||||||
| 29669792 | 29669792 | PRJNA630162_P_NODE_51330_length_246_cov_1.964467_g49807_i0 | PRJNA630162 | 51330 | 246 | 1.964467 | 4.83258882 | Caldithrix abyssi | 187145 | Bacteria | Bacteria | 45.4 | 0.00413 | NR | WP_006928400.1 | 187145 | g49807 | i0 | 47.9 | 0.585365853658537 | 48 | 23 | 58.5 | 1 | 212 | 69 | 310 | 355 | WP_006928400.1 hypothetical protein [Caldithrix abyssi] | diamond | 144 | 45.4 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichia | Calditrichales | Calditrichaceae | Caldithrix | Caldithrix abyssi | ||
| 30365447 | 30365447 | PRJNA630162_P_NODE_150492_length_164_cov_1.739130_g148969_i0 | PRJNA630162 | 150492 | 164 | 1.73913 | 2.8521732 | Calditrichia bacterium | 2268178 | Bacteria | Bacteria | 56.6 | 1.61e-7 | NR | MEJ2637424.1 | 2268178 | g148969 | i0 | 50 | 0.98780487804878 | 54 | 26 | 98.8 | 1 | 162 | 1 | 414 | 466 | MEJ2637424.1 multicopper oxidase domain-containing protein [Calditrichia bacterium] | diamond | 162 | 56.6 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichia | Calditrichia 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);;