contig_metadata
9 rows where bioproject = "PRJNA1237347", tax_kingdom = "Bacillati" and tax_phylum = "Candidatus Dormiibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27988980 | 27988980 | PRJNA1237347_P_NODE_224905_length_401_cov_1.957317_g218333_i0 | PRJNA1237347 | 224905 | 401 | 1.957317 | 7.84884117 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 44.7 | 0.04 | NR | HEY1456198.1 | 2052315 | g218333 | i0 | 32.3 | 0.486284289276808 | 65 | 41 | 46.4 | 1 | 175 | 360 | 281 | 345 | HEY1456198.1 proline--tRNA ligase [Candidatus Dormiibacterota bacterium] | diamond | 195 | 44.7 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 28399593 | 28399593 | PRJNA1237347_P_NODE_400286_length_279_cov_2.165049_g393713_i0 | PRJNA1237347 | 400286 | 279 | 2.165049 | 6.04048671 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 82.4 | 1.32e-17 | NR | HWZ99514.1 | 2052315 | g393713 | i0 | 43.9 | 0.881720430107527 | 82 | 46 | 88.2 | 0 | 274 | 29 | 61 | 142 | HWZ99514.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 246 | 82.4 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29567563 | 29567563 | PRJNA1237347_P_NODE_278210_length_350_cov_1.472924_g271637_i0 | PRJNA1237347 | 278210 | 350 | 1.472924 | 5.155234 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 78.6 | 3.58e-14 | NR | HUY10388.1 | 2052315 | g271637 | i0 | 39.8 | 0.925714285714286 | 108 | 44 | 92.6 | 2 | 15 | 338 | 118 | 204 | HUY10388.1 aminopeptidase N [Candidatus Dormiibacterota bacterium] | diamond | 324 | 78.6 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 30389245 | 30389245 | PRJNA1237347_P_NODE_178473_length_467_cov_4.578680_g171902_i0 | PRJNA1237347 | 178473 | 467 | 4.57868 | 21.3824356 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 45.8 | 0.0281 | NR | HVA95464.1 | 2052315 | g171902 | i0 | 35.9 | 0.591006423982869 | 92 | 53 | 55.2 | 4 | 461 | 204 | 43 | 134 | HVA95464.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 276 | 45.8 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 30641930 | 30641930 | PRJNA1237347_P_NODE_547073_length_242_cov_0.911243_g540500_i0 | PRJNA1237347 | 547073 | 242 | 0.911243 | 2.20520806 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 45.8 | 0.00291 | NR | MBV8526945.1 | 2052315 | g540500 | i0 | 37.3 | 0.929752066115702 | 75 | 47 | 93 | 0 | 227 | 3 | 305 | 379 | MBV8526945.1 insulinase family protein [Candidatus Dormiibacterota bacterium] | diamond | 225 | 45.8 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 30976454 | 30976454 | PRJNA1237347_P_NODE_59934_length_944_cov_2.495982_g54479_i0 | PRJNA1237347 | 59934 | 944 | 2.495982 | 23.56207008 | root | 1 | Root_unresolved | Root_unresolved | 311 | 9.98e-100 | NR | MDP9325428.1 | 2052315 | g54479 | i0 | 59 | 8.03389830508475 | 249 | 101 | 79.1 | 1 | 4 | 750 | 200 | 447 | MDP9325428.1 glutamate decarboxylase [Candidatus Dormiibacterota bacterium] | diamond | 7584 | 311 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 31052694 | 31052694 | PRJNA1237347_P_NODE_241555_length_383_cov_1.238710_g234982_i0 | PRJNA1237347 | 241555 | 383 | 1.23871 | 4.7442593 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 45.4 | 0.0162 | NR | HEV7676970.1 | 2052315 | g234982 | i0 | 35.8 | 0.634464751958224 | 81 | 42 | 63.4 | 3 | 141 | 383 | 102 | 172 | HEV7676970.1 alpha/beta hydrolase [Candidatus Dormiibacterota bacterium] | diamond | 243 | 45.4 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 32381114 | 32381114 | PRJNA1237347_P_NODE_354859_length_300_cov_3.066079_g348286_i0 | PRJNA1237347 | 354859 | 300 | 3.066079 | 9.198237 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 89.7 | 1.58e-18 | NR | HXJ76494.1 | 2052315 | g348286 | i0 | 46.4 | 3.02 | 110 | 48 | 99 | 1 | 297 | 1 | 35 | 144 | HXJ76494.1 NHL repeat-containing protein [Candidatus Dormiibacterota bacterium] | diamond | 906 | 89.7 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 32571296 | 32571296 | PRJNA1237347_P_NODE_485319_length_249_cov_2.284091_g478746_i0 | PRJNA1237347 | 485319 | 249 | 2.284091 | 5.68738659 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 139 | 4.4999999999999996e-38 | NR | HZL08271.1 | 2052315 | g478746 | i0 | 89.5 | 1.83132530120482 | 76 | 8 | 91.6 | 0 | 247 | 20 | 244 | 319 | HZL08271.1 FAD-dependent oxidoreductase [Candidatus Dormiibacterota bacterium] | diamond | 456 | 139 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota 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);;