contig_metadata
6 rows where bioproject = "PRJNA980585", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Minisyncoccota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27316953 | 27316953 | PRJNA980585_P_NODE_35863_length_263_cov_1.621053_g35609_i0 | PRJNA980585 | 35863 | 263 | 1.621053 | 4.26336939 | Bacteria | 2 | Bacteria | Bacteria | 116 | 2.75e-29 | NR | MDR3549237.1 | 2053589 | g35609 | i0 | 80 | 5.5893536121673 | 70 | 14 | 79.8 | 0 | 52 | 261 | 1 | 70 | MDR3549237.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 1470 | 117 | 0.991452991452991 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27405607 | 27405607 | PRJNA980585_P_NODE_22043_length_311_cov_3.218487_g21789_i0 | PRJNA980585 | 22043 | 311 | 3.218487 | 10.00949457 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 48.1 | 2.34e-4 | NR | MEX0596480.1 | 2053589 | g21789 | i0 | 33.8 | 0.713826366559486 | 74 | 49 | 71.4 | 0 | 89 | 310 | 21 | 94 | MEX0596480.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 222 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28131809 | 28131809 | PRJNA980585_P_NODE_41285_length_251_cov_0.865169_g41031_i0 | PRJNA980585 | 41285 | 251 | 0.865169 | 2.17157419 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 164 | 1.37e-49 | NR | MFM7088280.1 | 2053589 | g41031 | i0 | 90.4 | 0.99203187250996006 | 83 | 8 | 99.2 | 0 | 2 | 250 | 81 | 163 | MFM7088280.1 FAD-binding domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 249 | 164 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28289372 | 28289372 | PRJNA980585_P_NODE_8506_length_451_cov_3.251323_g8252_i0 | PRJNA980585 | 8506 | 451 | 3.251323 | 14.66346673 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 141 | 1.5699999999999999e-40 | NR | MDR3549538.1 | 2053589 | g8252 | i0 | 66.3 | 0.651884700665188 | 98 | 33 | 65.2 | 0 | 405 | 112 | 8 | 105 | MDR3549538.1 small nuclear ribonucleoprotein Sm D2 [Candidatus Paceibacterota bacterium] | diamond | 294 | 141 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29931621 | 29931621 | PRJNA980585_P_NODE_57951_length_242_cov_0.911243_g57697_i0 | PRJNA980585 | 57951 | 242 | 0.911243 | 2.20520806 | Candidatus Pacebacteria bacterium CG1 | 1974769 | Bacteria | Bacteria | 79.3 | 1.67e-15 | NR | PIR61648.1 | 1974769 | g57697 | i0 | 50.7 | 2.6404958677686 | 69 | 34 | 85.5 | 0 | 10 | 216 | 5 | 73 | PIR61648.1 MAG: hypothetical protein COU66_02695 [Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_44_11] | diamond | 639 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_44_11 | ||||||
| 31859273 | 31859273 | PRJNA980585_P_NODE_16337_length_348_cov_2.145455_g16083_i0 | PRJNA980585 | 16337 | 348 | 2.145455 | 7.4661834 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 94.7 | 9.47e-23 | NR | MDR3572201.1 | 2053589 | g16083 | i0 | 76.3 | 0.655172413793103 | 76 | 18 | 65.5 | 0 | 348 | 121 | 13 | 88 | MDR3572201.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 228 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota 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);;