contig_metadata
9 rows where bioproject = "PRJNA1034995", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7820971 | 7820971 | PRJNA1034995_S_NODE_16247_length_459_cov_35.372596_g16094_i0 | PRJNA1034995 | 16247 | 459 | 35.372596 | 162.36021564 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 579 | 1.6499999999999994e-160 | NTclustered | gi|84452201|emb|AM180899.1| | 171953 | g16094 | i0 | 91.142 | 289.41394335512 | 429 | 35 | 93 | 3 | 13 | 440 | 1645 | 1219 | Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone LS_LKC11_kan2 | blastn | 132841 | 579 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 24394451 | 24394451 | PRJNA1034995_S_NODE_19940_length_384_cov_73.595308_g19785_i0 | PRJNA1034995 | 19940 | 384 | 73.595308 | 282.60598272 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 407 | 6.789999999999999e-109 | NTclustered | gi|1958093598|gb|CP065003.1| | 1978231 | g19785 | i0 | 89.905 | 91.0260416666667 | 317 | 30 | 82 | 2 | 39 | 353 | 317239 | 317555 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome | blastn | 34954 | 407 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26940066 | 26940066 | PRJNA1034995_S_NODE_21042_length_368_cov_13.735385_g20886_i0 | PRJNA1034995 | 21042 | 368 | 13.735385 | 50.5462168 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 68.2 | 3e-12 | NR | MDQ3714119.1 | 1978231 | g20886 | i0 | 87 | 0.375 | 46 | 6 | 37.5 | 0 | 192 | 55 | 1 | 46 | MDQ3714119.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 138 | 68.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27035136 | 27035136 | PRJNA1034995_S_NODE_36922_length_222_cov_1.787709_g36766_i0 | PRJNA1034995 | 36922 | 222 | 1.787709 | 3.96871398 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 78.2 | 1.72e-15 | NR | MCY7347090.1 | 2283092 | g36766 | i0 | 82.6 | 0.621621621621622 | 46 | 8 | 62.2 | 0 | 143 | 6 | 1 | 46 | MCY7347090.1 CsbD family protein [Pyrinomonadaceae bacterium] | diamond | 138 | 78.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27193058 | 27193058 | PRJNA1034995_S_NODE_15542_length_479_cov_21.094037_g15391_i0 | PRJNA1034995 | 15542 | 479 | 21.094037 | 101.04043723 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 125 | 3.11e-30 | NR | MBA2606296.1 | 1978231 | g15391 | i0 | 82.4 | 3.30688935281837 | 68 | 12 | 42.6 | 0 | 274 | 477 | 62 | 129 | MBA2606296.1 cytochrome c biogenesis protein CcsA [Acidobacteriota bacterium] | diamond | 1584 | 125 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28866788 | 28866788 | PRJNA1034995_S_NODE_28168_length_285_cov_26.681818_g28012_i0 | PRJNA1034995 | 28168 | 285 | 26.681818 | 76.0431813 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 46.6 | 0.00258 | NR | MYC65854.1 | 2081523 | g28012 | i0 | 39.2 | 0.536842105263158 | 51 | 31 | 53.7 | 0 | 95 | 247 | 178 | 228 | MYC65854.1 sulfatase-like hydrolase/transferase [Terriglobia bacterium] | diamond | 153 | 46.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 28866790 | 28866790 | PRJNA1034995_S_NODE_51188_length_160_cov_15.931624_g51032_i0 | PRJNA1034995 | 51188 | 160 | 15.931624 | 25.4905984 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 42.7 | 0.0114 | NR | HEX7729701.1 | 1964191 | g51032 | i0 | 41.7 | 0.9 | 48 | 28 | 90 | 0 | 158 | 15 | 213 | 260 | HEX7729701.1 hypothetical protein [Terracidiphilus sp.] | diamond | 144 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 31140586 | 31140586 | PRJNA1034995_S_NODE_28895_length_279_cov_7.677966_g28739_i0 | PRJNA1034995 | 28895 | 279 | 7.677966 | 21.42152514 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 168 | 1.45e-50 | NR | MCY7344970.1 | 2283092 | g28739 | i0 | 95.3 | 0.924731182795699 | 86 | 4 | 92.5 | 0 | 260 | 3 | 43 | 128 | MCY7344970.1 type IVB secretion system protein IcmH/DotU [Pyrinomonadaceae bacterium] | diamond | 258 | 168 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32216537 | 32216537 | PRJNA1034995_S_NODE_31398_length_259_cov_4.472222_g31242_i0 | PRJNA1034995 | 31398 | 259 | 4.472222 | 11.58305498 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 92 | 6.66e-21 | NR | MDQ3062607.1 | 1978231 | g31242 | i0 | 73.7 | 1.34362934362934 | 57 | 15 | 66 | 0 | 4 | 174 | 131 | 187 | MDQ3062607.1 DinB family protein [Acidobacteriota bacterium] | diamond | 348 | 92 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;