contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA608894" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5689546 | 5689546 | PRJNA608894_P_NODE_58525_length_242_cov_1.822485_g58026_i0 | PRJNA608894 | 58525 | 242 | 1.822485 | 4.4104137 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 73.1 | 1.67e-8 | NTclustered | gi|2082246007|ref|XM_001700625.2| | 3055 | g58026 | i0 | 85.507 | 1.64876033057851 | 69 | 10 | 29 | 0 | 139 | 207 | 1709 | 1641 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_05g234639v5), mRNA | blastn | 399 | 73.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 6963397 | 6963397 | PRJNA608894_P_NODE_19426_length_467_cov_2.692893_g18930_i0 | PRJNA608894 | 19426 | 467 | 2.692893 | 12.57581031 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 285 | 4.11e-72 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g18930 | i0 | 84.158 | 59.3276231263383 | 303 | 38 | 64 | 9 | 1 | 298 | 560 | 857 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 27706 | 285 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 9514277 | 9514277 | PRJNA608894_P_NODE_58688_length_242_cov_1.443787_g58189_i0 | PRJNA608894 | 58688 | 242 | 1.443787 | 3.49396454 | Volvox carteri | 3067 | Plants | Plants | 147 | 9.72e-31 | NTclustered | gi|302837739|ref|XM_002950383.1| | 3068 | g58189 | i0 | 82.456 | 51.0578512396694 | 171 | 27 | 69 | 1 | 75 | 242 | 111 | 281 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_74602), mRNA | blastn | 12356 | 147 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 14614140 | 14614140 | PRJNA608894_P_NODE_22732_length_412_cov_1.669617_g22235_i0 | PRJNA608894 | 22732 | 412 | 1.669617 | 6.87882204 | Monoraphidium neglectum | 145388 | Plants | Plants | 278 | 5.999999999999999e-70 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g22235 | i0 | 83.333 | 66.9029126213592 | 300 | 50 | 73 | 0 | 99 | 398 | 61 | 360 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 27564 | 278 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 19711924 | 19711924 | PRJNA608894_P_NODE_31976_length_321_cov_2.032258_g31477_i0 | PRJNA608894 | 31976 | 321 | 2.032258 | 6.52354818 | Monoraphidium neglectum | 145388 | Plants | Plants | 143 | 1.74e-29 | NTclustered | gi|926781367|ref|XM_014043704.1| | 145388 | g31477 | i0 | 80.874 | 0.570093457943925 | 183 | 33 | 57 | 2 | 4 | 185 | 303 | 122 | Monoraphidium neglectum 60S ribosomal protein L26-1 mRNA | blastn | 183 | 143 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 21549034 | 21549034 | PRJNA608894_P_NODE_58557_length_242_cov_1.816568_g58058_i0 | PRJNA608894 | 58557 | 242 | 1.816568 | 4.39609456 | Chlamydomonas | 3052 | Plants | Plants | 132 | 2.7200000000000003e-26 | NTclustered | gi|18144|emb|X53574.1| | 3055 | g58058 | i0 | 80.663 | 50.698347107438 | 181 | 25 | 73 | 9 | 67 | 242 | 1643 | 1468 | C. reinhardtii Cblp gene for a G protein beta subunit-like polypeptide | blastn | 12269 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 24811706 | 24811706 | PRJNA608894_P_NODE_35600_length_302_cov_2.641921_g35101_i0 | PRJNA608894 | 35600 | 302 | 2.641921 | 7.97860142 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 54.7 | 0.008 | NTclustered | gi|760445178|ref|XM_011401356.1| | 3075 | g35101 | i0 | 94.444 | 0.119205298013245 | 36 | 0 | 12 | 2 | 24 | 58 | 1404 | 1438 | Auxenochlorella protothecoides Ubiquitin carboxyl-terminal hydrolase 7 partial mRNA | blastn | 36 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides |
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);;