contig_metadata
4 rows where bioproject = "PRJNA728642" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1988896 | 1988896 | PRJNA728642_P_NODE_19242_length_242_cov_0.911243_g18971_i0 | PRJNA728642 | 19242 | 242 | 0.911243 | 2.20520806 | Chlamydomonas sp. CCMP233 | 327069 | Plants | Plants | 58.4 | 4.69e-4 | NTclustered | gi|66864265|gb|DQ015720.1| | 327069 | g18971 | i0 | 100 | 12.6404958677686 | 31 | 0 | 13 | 0 | 131 | 161 | 1512 | 1542 | Chlamydomonas sp. CCMP233 strain CCMP 233 26S ribosomal RNA gene, partial sequence | blastn | 3059 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. CCMP233 | |
| 5816483 | 5816483 | PRJNA728642_P_NODE_17205_length_247_cov_1.005747_g16934_i0 | PRJNA728642 | 17205 | 247 | 1.005747 | 2.48419509 | Desmochloris halophila | 138176 | Plants | Plants | 433 | 6.82e-117 | NTclustered | gi|371782123|emb|HE610155.1| | 138176 | g16934 | i0 | 98.374 | 109.109311740891 | 246 | 4 | 99 | 0 | 1 | 246 | 3612 | 3857 | Desmochloris halophila plastid 16S rRNA gene (partial), 23S rRNA gene (partial) and ITS1, strain UTEX 2073 | blastn | 26950 | 433 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 20321361 | 20321361 | PRJNA728642_P_NODE_13276_length_276_cov_1.492611_g13005_i0 | PRJNA728642 | 13276 | 276 | 1.492611 | 4.11960636 | Desmochloris | 138596 | Plants | Plants | 501 | 2.1e-137 | NTclustered | gi|57864438|dbj|AB049416.2| | 138176 | g13005 | i0 | 99.635 | 99.7826086956522 | 274 | 1 | 99 | 0 | 3 | 276 | 922 | 649 | Desmochloris halophila gene for 18S rRNA | blastn | 27540 | 505 | 0.992079207920792 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 21115383 | 21115383 | PRJNA728642_P_NODE_15517_length_253_cov_1.711111_g15246_i0 | PRJNA728642 | 15517 | 253 | 1.711111 | 4.32911083 | Desmochloris halophila | 138176 | Plants | Plants | 412 | 9.14e-111 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g15246 | i0 | 96.063 | 70.1857707509881 | 254 | 9 | 100 | 1 | 1 | 253 | 3964 | 3711 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 17757 | 412 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila |
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);;