contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1120060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6631975 | 6631975 | PRJNA1120060_P_NODE_2641766_length_250_cov_0.881356_g2623686_i0 | PRJNA1120060 | 2641766 | 250 | 0.881356 | 2.20339 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 103 | 2.38e-24 | NR | HSQ00825.1 | 2052315 | g2623686 | i0 | 84.6 | 0.624 | 52 | 8 | 62.4 | 0 | 156 | 1 | 6 | 57 | HSQ00825.1 agmatine deiminase family protein [Candidatus Dormiibacterota bacterium] | diamond | 156 | 103 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 11734943 | 11734943 | PRJNA1120060_P_NODE_2844950_length_245_cov_0.906977_g2826864_i0 | PRJNA1120060 | 2844950 | 245 | 0.906977 | 2.22209365 | Candidatus Nephthysia bennettiae | 3127016 | Bacteria | Bacteria | 124 | 2.9999999999999998e-33 | NR | WP_338200654.1 | 3127016 | g2826864 | i0 | 86.4 | 0.808163265306122 | 66 | 9 | 80.8 | 0 | 241 | 44 | 171 | 236 | WP_338200654.1 transaldolase [Candidatus Nephthysia bennettiae] | diamond | 198 | 124 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormibacteria | Candidatus Dormibacterales | Candidatus Dormibacteraceae | Candidatus Nephthysia | Candidatus Nephthysia bennettiae | ||
| 27763337 | 27763337 | PRJNA1120060_P_NODE_1037144_length_311_cov_6.252101_g1019209_i0 | PRJNA1120060 | 1037144 | 311 | 6.252101 | 19.44403411 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 88.2 | 9.26e-18 | NR | HLQ98099.1 | 2052315 | g1019209 | i0 | 93.9 | 0.472668810289389 | 49 | 3 | 47.3 | 0 | 2 | 148 | 464 | 512 | HLQ98099.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 147 | 88.2 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 28047797 | 28047797 | PRJNA1120060_P_NODE_193765_length_472_cov_4.862155_g177365_i0 | PRJNA1120060 | 193765 | 472 | 4.862155 | 22.9493716 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 46.2 | 0.0208 | NR | MBV8194545.1 | 2052315 | g177365 | i0 | 32.1 | 0.514830508474576 | 81 | 36 | 50.8 | 3 | 232 | 471 | 150 | 212 | MBV8194545.1 ABC transporter substrate-binding protein [Candidatus Dormiibacterota bacterium] | diamond | 243 | 46.2 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 28079469 | 28079469 | PRJNA1120060_P_NODE_2185345_length_265_cov_3.489583_g2167293_i0 | PRJNA1120060 | 2185345 | 265 | 3.489583 | 9.24739495 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 46.2 | 0.00279 | NR | HZV48845.1 | 2052315 | g2167293 | i0 | 35.6 | 0.984905660377358 | 87 | 49 | 96.2 | 4 | 6 | 260 | 318 | 399 | HZV48845.1 helix-turn-helix domain-containing protein [Candidatus Dormiibacterota bacterium] | diamond | 261 | 46.2 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 28742755 | 28742755 | PRJNA1120060_P_NODE_2333987_length_260_cov_1.352941_g2315927_i0 | PRJNA1120060 | 2333987 | 260 | 1.352941 | 3.5176466 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 106 | 5.3699999999999995e-25 | NR | HLQ97775.1 | 2052315 | g2315927 | i0 | 90.9 | 0.634615384615385 | 55 | 5 | 63.5 | 0 | 94 | 258 | 249 | 303 | HLQ97775.1 DUF3991 and TOPRIM domain-containing protein [Candidatus Dormiibacterota bacterium] | diamond | 165 | 106 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29500640 | 29500640 | PRJNA1120060_P_NODE_2695130_length_248_cov_4.148571_g2677047_i0 | PRJNA1120060 | 2695130 | 248 | 4.148571 | 10.28845608 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 42.7 | 0.0235 | NR | HSP98635.1 | 2052315 | g2677047 | i0 | 39.2 | 0.616935483870968 | 51 | 31 | 61.7 | 0 | 24 | 176 | 51 | 101 | HSP98635.1 acyltransferase [Candidatus Dormiibacterota bacterium] | diamond | 153 | 42.7 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29743108 | 29743108 | PRJNA1120060_P_NODE_2559390_length_252_cov_1.441341_g2541315_i0 | PRJNA1120060 | 2559390 | 252 | 1.441341 | 3.63217932 | Bacillati | 1783272 | Bacteria | Bacteria | 101 | 3.89e-25 | NR | MDQ6898499.1 | 2052315 | g2541315 | i0 | 58.7 | 7.79761904761905 | 75 | 30 | 88.1 | 1 | 4 | 225 | 44 | 118 | MDQ6898499.1 SRPBCC domain-containing protein [Candidatus Dormiibacterota bacterium] | diamond | 1965 | 102 | 0.990196078431373 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29942206 | 29942206 | PRJNA1120060_P_NODE_1524831_length_292_cov_2.534247_g1506842_i0 | PRJNA1120060 | 1524831 | 292 | 2.534247 | 7.40000124 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 42.7 | 0.0234 | NR | HEY3084679.1 | 2052315 | g1506842 | i0 | 42.2 | 0.462328767123288 | 45 | 26 | 46.2 | 0 | 152 | 18 | 43 | 87 | HEY3084679.1 transcriptional repressor [Candidatus Dormiibacterota bacterium] | diamond | 135 | 42.7 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 30795816 | 30795816 | PRJNA1120060_P_NODE_2728134_length_248_cov_0.880000_g2710051_i0 | PRJNA1120060 | 2728134 | 248 | 0.88 | 2.1824 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 99.8 | 2.1e-24 | NR | HLQ98107.1 | 2052315 | g2710051 | i0 | 60.5 | 1.95967741935484 | 81 | 31 | 98 | 1 | 245 | 3 | 67 | 146 | HLQ98107.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 486 | 99.8 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 32408726 | 32408726 | PRJNA1120060_P_NODE_258659_length_436_cov_5.280992_g241784_i0 | PRJNA1120060 | 258659 | 436 | 5.280992 | 23.02512512 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 145 | 1.72e-39 | NR | HLQ98109.1 | 2052315 | g241784 | i0 | 64.5 | 0.853211009174312 | 124 | 42 | 83.9 | 1 | 383 | 18 | 209 | 332 | HLQ98109.1 replication initiator protein A [Candidatus Dormiibacterota bacterium] | diamond | 372 | 145 | 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);;