contig_metadata
4 rows where bioproject = "PRJNA315399" and tax_phylum = "Candidatus Portnoyibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29807445 | 29807445 | PRJNA315399_P_NODE_78131_length_212_cov_5.274286_g77683_i0 | PRJNA315399 | 78131 | 212 | 5.274286 | 11.18148632 | Bacteria | 2 | Bacteria | Bacteria | 64.3 | 6.13e-10 | NR | PIZ69265.1 | 1974798 | g77683 | i0 | 66 | 1.99528301886792 | 47 | 16 | 66.5 | 0 | 42 | 182 | 130 | 176 | PIZ69265.1 MAG: hypothetical protein COY10_01735 [Candidatus Portnoybacteria bacterium CG_4_10_14_0_2_um_filter_43_36] | diamond | 423 | 64.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium CG_4_10_14_0_2_um_filter_43_36 | ||||||
| 30643056 | 30643056 | PRJNA315399_S_NODE_70393_length_196_cov_2.182390_g70192_i0 | PRJNA315399 | 70393 | 196 | 2.18239 | 4.2774844 | Candidatus Portnoybacteria bacterium | 2053593 | Bacteria | Bacteria | 62 | 3.23e-9 | NR | MBD3282083.1 | 2053593 | g70192 | i0 | 55 | 0.918367346938776 | 60 | 27 | 91.8 | 0 | 16 | 195 | 129 | 188 | MBD3282083.1 hypothetical protein [Candidatus Portnoybacteria bacterium] | diamond | 180 | 62 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium | ||||||
| 31148229 | 31148229 | PRJNA315399_P_NODE_497815_length_151_cov_5.122807_g497367_i0 | PRJNA315399 | 497815 | 151 | 5.122807 | 7.73543857 | Candidatus Portnoybacteria bacterium CG | 2053593 | Bacteria | Bacteria | 42 | 0.0194 | NR | PIU74874.1 | 1974809 | g497367 | i0 | 47.7 | 0.874172185430464 | 44 | 23 | 87.4 | 0 | 3 | 134 | 161 | 204 | PIU74874.1 MAG: hypothetical protein COS76_03785 [Candidatus Portnoybacteria bacterium CG06_land_8_20_14_3_00_39_12] | diamond | 132 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium CG06_land_8_20_14_3_00_39_12 | ||||||
| 32399966 | 32399966 | PRJNA315399_S_NODE_47639_length_217_cov_10.866667_g47438_i0 | PRJNA315399 | 47639 | 217 | 10.866667 | 23.58066739 | Bacteria | 2 | Bacteria | Bacteria | 58.2 | 9.88e-8 | NR | PIZ69265.1 | 1974798 | g47438 | i0 | 57.9 | 2.36405529953917 | 57 | 24 | 78.8 | 0 | 10 | 180 | 139 | 195 | PIZ69265.1 MAG: hypothetical protein COY10_01735 [Candidatus Portnoybacteria bacterium CG_4_10_14_0_2_um_filter_43_36] | diamond | 513 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium CG_4_10_14_0_2_um_filter_43_36 |
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);;