contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1196384" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7976010 | 7976010 | PRJNA1196384_S_NODE_2367_length_252_cov_0.902326_g2303_i0 | PRJNA1196384 | 2367 | 252 | 0.902326 | 2.27386152 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 193 | 1.29e-44 | NTclustered | gi|760443472|ref|XM_011400503.1| | 3075 | g2303 | i0 | 81.048 | 35.0912698412698 | 248 | 41 | 97 | 6 | 8 | 252 | 4280 | 4036 | Auxenochlorella protothecoides Pyrophosphate-energized vacuolar membrane proton pump 1 partial mRNA | blastn | 8843 | 193 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 15625459 | 15625459 | PRJNA1196384_S_NODE_3173_length_218_cov_2.900552_g3109_i0 | PRJNA1196384 | 3173 | 218 | 2.900552 | 6.32320336 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 117 | 6.740000000000001e-22 | NTclustered | gi|2082256028|ref|XM_001702556.2| | 3055 | g3109 | i0 | 80.124 | 1.87614678899083 | 161 | 28 | 72 | 3 | 56 | 213 | 412 | 253 | Chlamydomonas reinhardtii ribosomal protein L30 (CHLRE_10g420750v5), mRNA | blastn | 409 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 15625517 | 15625517 | PRJNA1196384_S_NODE_6593_length_164_cov_0.897638_g6529_i0 | PRJNA1196384 | 6593 | 164 | 0.897638 | 1.47212632 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 185 | 1.2899999999999997e-42 | NTclustered | gi|2082243702|ref|XM_043061450.1| | 3055 | g6529 | i0 | 89.189 | 81.280487804878 | 148 | 16 | 90 | 0 | 16 | 163 | 1160 | 1307 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g204250v5), mRNA | blastn | 13330 | 185 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18174332 | 18174332 | PRJNA1196384_S_NODE_5735_length_172_cov_4.555556_g5671_i0 | PRJNA1196384 | 5735 | 172 | 4.555556 | 7.83555632 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 100 | 5.08e-17 | NTclustered | gi|2082239523|ref|XM_001699755.2| | 3055 | g5671 | i0 | 98.246 | 24.6976744186047 | 57 | 1 | 33 | 0 | 9 | 65 | 221 | 277 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g101350v5), mRNA | blastn | 4248 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 24548768 | 24548768 | PRJNA1196384_S_NODE_2320_length_254_cov_3.244240_g2256_i0 | PRJNA1196384 | 2320 | 254 | 3.24424 | 8.2403696 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 135 | 2.2300000000000003e-27 | NTclustered | gi|760444762|ref|XM_011401148.1| | 3075 | g2256 | i0 | 77.119 | 3.41338582677165 | 236 | 52 | 93 | 2 | 5 | 239 | 256 | 22 | Auxenochlorella protothecoides 40S ribosomal protein S16 partial mRNA | blastn | 867 | 135 | 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);;