contig_metadata
5 rows where bioproject = "PRJNA827593", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 821781 | 821781 | PRJNA827593_P_NODE_68101_length_241_cov_0.916667_g67802_i0 | PRJNA827593 | 68101 | 241 | 0.916667 | 2.20916747 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 139 | 1.4399999999999998e-37 | NR | HVX90252.1 | 2053589 | g67802 | i0 | 81.9 | 2.06639004149378 | 83 | 11 | 98.3 | 1 | 238 | 2 | 243 | 325 | HVX90252.1 IS256 family transposase [Candidatus Paceibacterota bacterium] | diamond | 498 | 139 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28380962 | 28380962 | PRJNA827593_P_NODE_49186_length_285_cov_3.188679_g48887_i0 | PRJNA827593 | 49186 | 285 | 3.188679 | 9.08773515 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 125 | 2.49e-34 | NR | MBI5151336.1 | 2053589 | g48887 | i0 | 69.4 | 0.894736842105263 | 85 | 26 | 89.5 | 0 | 263 | 9 | 75 | 159 | MBI5151336.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 255 | 125 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31476749 | 31476749 | PRJNA827593_P_NODE_34996_length_346_cov_2.098901_g34697_i0 | PRJNA827593 | 34996 | 346 | 2.098901 | 7.26219746 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 47.4 | 0.00295 | NR | MDR3519291.1 | 2053589 | g34697 | i0 | 54.5 | 0.38150289017341 | 44 | 20 | 38.2 | 0 | 142 | 11 | 275 | 318 | MDR3519291.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Paceibacterota bacterium] | diamond | 132 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32077623 | 32077623 | PRJNA827593_P_NODE_22118_length_449_cov_2.859043_g21819_i0 | PRJNA827593 | 22118 | 449 | 2.859043 | 12.83710307 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 292 | 2.9299999999999993e-95 | NR | MDR3557945.1 | 2053589 | g21819 | i0 | 95.2 | 0.975501113585746 | 146 | 7 | 97.6 | 0 | 443 | 6 | 127 | 272 | MDR3557945.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 438 | 292 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32331178 | 32331178 | PRJNA827593_P_NODE_8139_length_782_cov_2.754584_g7858_i0 | PRJNA827593 | 8139 | 782 | 2.754584 | 21.54084688 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 136 | 2.3899999999999995e-32 | NR | MFA6271082.1 | 2053589 | g7858 | i0 | 67.3 | 1.16240409207161 | 101 | 31 | 38.7 | 1 | 777 | 475 | 1146 | 1244 | MFA6271082.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 909 | 136 | 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);;