contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25795595 | 25795595 | PRJEB6584b_S_NODE_6491_length_172_cov_3.065693_g6473_i0 | PRJEB6584 | 6491 | 172 | 3.065693 | 5.27299196 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 79.3 | 1.75e-15 | NR | TXG76615.1 | 2052139 | g6473 | i0 | 78.8 | 0.906976744186046 | 52 | 11 | 90.7 | 0 | 171 | 16 | 130 | 181 | TXG76615.1 MAG: mannose-1-phosphate guanylyltransferase/mannose-6-phosphate isomerase [Patescibacteria group bacterium] | diamond | 156 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 26069514 | 26069514 | PRJEB6584o_S_NODE_6365_length_330_cov_11.376271_g6257_i0 | PRJEB6584 | 6365 | 330 | 11.376271 | 37.5416943 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 107 | 3.89e-27 | NR | MBT4936660.1 | 2030811 | g6257 | i0 | 62.8 | 0.709090909090909 | 78 | 29 | 70.9 | 0 | 305 | 72 | 71 | 148 | MBT4936660.1 50S ribosomal protein L15 [Candidatus Peregrinibacteria bacterium] | diamond | 234 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 26160302 | 26160302 | PRJEB6584e_S_NODE_877_length_269_cov_6.286325_g862_i0 | PRJEB6584 | 877 | 269 | 6.286325 | 16.91021425 | Bacteria | 2 | Bacteria | Bacteria | 79 | 1.14e-16 | NR | KKQ34433.1 | 1618742 | g862 | i0 | 70.4 | 3.9814126394052 | 54 | 16 | 60.2 | 0 | 267 | 106 | 34 | 87 | KKQ34433.1 MAG: RNP-1 like protein RNA-binding protein [Candidatus Nomurabacteria bacterium GW2011_GWB1_37_5] | diamond | 1071 | 79.3 | 0.996216897856242 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium GW2011_GWB1_37_5 | ||||||
| 32923077 | 32923077 | PRJEB6584o_S_NODE_41273_length_171_cov_2.779412_g41165_i0 | PRJEB6584 | 41273 | 171 | 2.779412 | 4.75279452 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 89 | 2.1200000000000003e-21 | NR | MDB5258941.1 | 2052153 | g41165 | i0 | 70.4 | 3.78947368421053 | 54 | 16 | 94.7 | 0 | 1 | 162 | 17 | 70 | MDB5258941.1 mitomycin resistance protein [Candidatus Taylorbacteria bacterium] | diamond | 648 | 89 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 32981088 | 32981088 | PRJEB6584o_S_NODE_7635_length_308_cov_18.384615_g7527_i0 | PRJEB6584 | 7635 | 308 | 18.384615 | 56.6246142 | Parcubacteria group bacterium | 2026774 | Bacteria | Bacteria | 58.2 | 2e-8 | NR | NMB92271.1 | 2026774 | g7527 | i0 | 42.9 | 2.72727272727273 | 70 | 39 | 68.2 | 1 | 307 | 98 | 5 | 73 | NMB92271.1 RNA-binding protein [Parcubacteria group bacterium] | diamond | 840 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Parcubacteria group bacterium | |||||||
| 33014837 | 33014837 | PRJEB6584o_S_NODE_26324_length_187_cov_2.434211_g26216_i0 | PRJEB6584 | 26324 | 187 | 2.434211 | 4.55197457 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 48.5 | 1.65e-4 | NR | HXJ79892.1 | 2032687 | g26216 | i0 | 60.5 | 0.689839572192513 | 43 | 17 | 69 | 0 | 187 | 59 | 1080 | 1122 | HXJ79892.1 response regulator [Candidatus Methylomirabilis sp.] | diamond | 129 | 48.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 33031860 | 33031860 | PRJEB6584o_S_NODE_18492_length_209_cov_2.155172_g18384_i0 | PRJEB6584 | 18492 | 209 | 2.155172 | 4.50430948 | Candidatus Stahlbacteria bacterium | 2528828 | Bacteria | Bacteria | 47.8 | 4.01e-4 | NR | TEU00595.1 | 2528828 | g18384 | i0 | 55.9 | 0.947368421052632 | 34 | 15 | 48.8 | 0 | 198 | 97 | 404 | 437 | TEU00595.1 MAG: saccharopine dehydrogenase [Candidatus Stahlbacteria bacterium] | diamond | 198 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Stahliibacteriota | Candidatus Stahliibacteriota bacterium | ||||||
| 33133988 | 33133988 | PRJEB6584e_S_NODE_2175_length_196_cov_3.472050_g2160_i0 | PRJEB6584 | 2175 | 196 | 3.47205 | 6.805218 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 42.7 | 0.00885 | NR | MBU1083113.1 | 2052139 | g2160 | i0 | 56.7 | 0.887755102040816 | 30 | 13 | 45.9 | 0 | 25 | 114 | 104 | 133 | MBU1083113.1 30S ribosomal protein S8 [Patescibacteria group bacterium] | diamond | 174 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 33134281 | 33134281 | PRJEB6584o_S_NODE_20975_length_199_cov_6.823171_g20867_i0 | PRJEB6584 | 20975 | 199 | 6.823171 | 13.57811029 | Candidatus Daviesbacteria bacterium GW2 | 2053542 | Bacteria | Bacteria | 47 | 6.76e-4 | NR | KKS14343.1 | 1618429 | g20867 | i0 | 33.9 | 2.75879396984925 | 62 | 41 | 93.5 | 0 | 1 | 186 | 598 | 659 | KKS14343.1 MAG: Tetratricopeptide repeat domain protein [Candidatus Daviesbacteria bacterium GW2011_GWB1_41_5] | diamond | 549 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium GW2011_GWB1_41_5 |
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);;