contig_metadata
5 rows where bioproject = "PRJNA1182301", tax_clade = "core chlorophytes" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16895248 | 16895248 | PRJNA1182301_P_NODE_1614_length_636_cov_2.625222_g1494_i0 | PRJNA1182301 | 1614 | 636 | 2.625222 | 16.69641192 | Chlamydomonas incerta | 51695 | Plants | Plants | 350 | 2e-91 | NTclustered | gi|74272614|gb|DQ122872.1| | 51695 | g1494 | i0 | 77.597 | 10.5125786163522 | 616 | 112 | 94 | 21 | 40 | 636 | 956 | 348 | Chlamydomonas incerta mitochondrial ADP/ATP translocator (ANT) mRNA, complete cds; nuclear gene for mitochondrial product | blastn | 6686 | 350 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 19444610 | 19444610 | PRJNA1182301_P_NODE_36176_length_267_cov_1.530928_g36051_i0 | PRJNA1182301 | 36176 | 267 | 1.530928 | 4.08757776 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 75 | 5.21e-9 | NTclustered | gi|2917929624|emb|OZ234912.1| | 3350044 | g36051 | i0 | 100 | 0.299625468164794 | 40 | 0 | 15 | 0 | 4 | 43 | 350854 | 350893 | Trebouxia sp. SL0000003 genome assembly, chromosome: 7 | blastn | 80 | 75 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 22718663 | 22718663 | PRJNA1182301_P_NODE_58098_length_244_cov_2.684211_g57973_i0 | PRJNA1182301 | 58098 | 244 | 2.684211 | 6.54947484 | Chlorophyta | 3041 | Plants | Plants | 374 | 4.1399999999999986e-99 | NTclustered | gi|2445342045|gb|OP765320.1| | 34112 | g57973 | i0 | 94.606 | 104.065573770492 | 241 | 13 | 99 | 0 | 4 | 244 | 56415 | 56175 | Chlorolobion braunii chloroplast, complete genome | blastn | 25392 | 375 | 0.997333333333333 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Chlorolobion | Chlorolobion braunii | |
| 27735970 | 27735970 | PRJNA1182301_P_NODE_65224_length_235_cov_3.845679_g65099_i0 | PRJNA1182301 | 65224 | 235 | 3.845679 | 9.03734565 | Volvox africanus | 51714 | Plants | Plants | 41.2 | 0.0319 | NR | GIL47022.1 | 51714 | g65099 | i0 | 43.2 | 0.561702127659575 | 44 | 23 | 56.2 | 1 | 216 | 85 | 38 | 79 | GIL47022.1 hypothetical protein Vafri_3857, partial [Volvox africanus] | diamond | 132 | 41.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 31842099 | 31842099 | PRJNA1182301_P_NODE_55077_length_247_cov_0.885057_g54952_i0 | PRJNA1182301 | 55077 | 247 | 0.885057 | 2.18609079 | Raphidocelis subcapitata | 307507 | Plants | Plants | 114 | 2.34e-30 | NR | GBG00329.1 | 307507 | g54952 | i0 | 59.5 | 4.08097165991903 | 84 | 31 | 98.4 | 1 | 245 | 3 | 33 | 116 | GBG00329.1 60S ribosomal protein L27a [Raphidocelis subcapitata] | diamond | 1008 | 114 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata |
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);;