contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJEB81463" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 997289 | 997289 | PRJEB81463_P_NODE_11561_length_299_cov_1.283186_g11289_i0 | PRJEB81463 | 11561 | 299 | 1.283186 | 3.83672614 | Eukaryota | 2759 | Plants | Plants | 211 | 4.33e-50 | NTclustered | gi|760449500|ref|XM_011403517.1| | 3075 | g11289 | i0 | 84.579 | 68.2040133779264 | 214 | 31 | 71 | 2 | 79 | 291 | 738 | 526 | Auxenochlorella protothecoides 60S ribosomal protein L8 partial mRNA | blastn | 20393 | 213 | 0.990610328638498 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 6518769 | 6518769 | PRJEB81463_P_NODE_27526_length_243_cov_0.917647_g27254_i0 | PRJEB81463 | 27526 | 243 | 0.917647 | 2.22988221 | Lobosphaera incisa | 312850 | Plants | Plants | 158 | 4.51e-34 | NTclustered | gi|2717096004|gb|PP658226.1| | 312850 | g27254 | i0 | 78.689 | 48.559670781893 | 244 | 46 | 99 | 5 | 2 | 243 | 582 | 343 | Lobosphaera incisa isolate CFRC-1 large subunit ribosomal RNA gene, partial sequence | blastn | 11800 | 158 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Lobosphaera | Lobosphaera incisa | |
| 7792607 | 7792607 | PRJEB81463_P_NODE_14687_length_279_cov_1.101942_g14415_i0 | PRJEB81463 | 14687 | 279 | 1.101942 | 3.07441818 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 305 | 1.79e-78 | NTclustered | gi|2082238339|ref|XM_001701832.2| | 3055 | g14415 | i0 | 86.38 | 100.634408602151 | 279 | 38 | 100 | 0 | 1 | 279 | 910 | 1188 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g080600v5), mRNA | blastn | 28077 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 10343418 | 10343418 | PRJEB81463_P_NODE_19249_length_256_cov_2.240437_g18977_i0 | PRJEB81463 | 19249 | 256 | 2.240437 | 5.73551872 | Dunaliella salina | 3046 | Plants | Plants | 156 | 1.72e-33 | NTclustered | gi|333691276|gb|JF346104.1| | 3046 | g18977 | i0 | 79.039 | 0.89453125 | 229 | 46 | 89 | 2 | 29 | 256 | 219 | 446 | Dunaliella salina receptor of activated protein kinase C 1 mRNA, complete cds | blastn | 229 | 156 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 11200650 | 11200650 | PRJEB81463_P_NODE_20229_length_253_cov_0.866667_g19957_i0 | PRJEB81463 | 20229 | 253 | 0.866667 | 2.19266751 | Eukaryota | 2759 | Plants | Plants | 134 | 7.970000000000001e-27 | NTclustered | gi|6119991|gb|AF183451.1| | 50039 | g19957 | i0 | 87.931 | 45.8498023715415 | 116 | 10 | 45 | 4 | 1 | 115 | 329 | 217 | Bracteacoccus giganteus strain UTEX 1251 28S ribosomal RNA gene, partial sequence | blastn | 11600 | 135 | 0.992592592592593 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus giganteus | |
| 19265996 | 19265996 | PRJEB81463_P_NODE_23376_length_248_cov_1.731429_g23104_i0 | PRJEB81463 | 23376 | 248 | 1.731429 | 4.29394392 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 220 | 5.81e-53 | NTclustered | gi|2917930141|emb|OZ234926.1| | 3350044 | g23104 | i0 | 83.6 | 1.45161290322581 | 250 | 25 | 100 | 9 | 1 | 248 | 91855 | 91620 | Trebouxia sp. SL0000003 genome assembly, organelle: mitochondrion | blastn | 360 | 220 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 |
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);;