contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA1227535" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30313226 | 30313226 | PRJNA1227535_P_NODE_11652_length_287_cov_1.004673_g11529_i0 | PRJNA1227535 | 11652 | 287 | 1.004673 | 2.88341151 | Chlorella | 3071 | Plants | Plants | 45.8 | 0.00542 | NR | PRW60203.1 | 3076 | g11529 | i0 | 55.6 | 0.752613240418119 | 36 | 16 | 37.6 | 0 | 144 | 251 | 594 | 629 | PRW60203.1 DNA repair RAD50 isoform A [Chlorella sorokiniana] | diamond | 216 | 45.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31937554 | 31937554 | PRJNA1227535_P_NODE_24937_length_249_cov_0.886364_g24813_i0 | PRJNA1227535 | 24937 | 249 | 0.886364 | 2.20704636 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 72 | 2.07e-12 | NR | KAA6421501.1 | 2608996 | g24813 | i0 | 56.7 | 0.72289156626506 | 60 | 26 | 72.3 | 0 | 37 | 216 | 85 | 144 | KAA6421501.1 MAG: hypothetical protein FRX49_08445 [Trebouxia sp. A1-2] | diamond | 180 | 72 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 32790689 | 32790689 | PRJNA1227535_P_NODE_18900_length_262_cov_1.650794_g18776_i0 | PRJNA1227535 | 18900 | 262 | 1.650794 | 4.32508028 | Chlorella vulgaris | 3077 | Plants | Plants | 46.2 | 0.00275 | NR | KAL4854672.1 | 3077 | g18776 | i0 | 76 | 0.286259541984733 | 25 | 6 | 28.6 | 0 | 6 | 80 | 224 | 248 | KAL4854672.1 Major capsid protein [Chlorella vulgaris] | diamond | 75 | 46.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris |
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);;