contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB673" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 134925 | 134925 | PRJEB673_P_NODE_3841_length_506_cov_2.033970_g3511_i0 | PRJEB673 | 3841 | 506 | 2.03397 | 10.2918882 | Monoraphidium neglectum | 145388 | Plants | Plants | 169 | 4.71e-37 | NTclustered | gi|926787363|ref|XM_014046702.1| | 145388 | g3511 | i0 | 83.889 | 4.91106719367589 | 180 | 25 | 35 | 4 | 58 | 235 | 870 | 693 | Monoraphidium neglectum Calreticulin Flags: Precursor mRNA | blastn | 2485 | 169 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 8648447 | 8648447 | PRJEB673_P_NODE_6707_length_335_cov_1.636667_g6358_i0 | PRJEB673 | 6707 | 335 | 1.636667 | 5.48283445 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.032 | NTclustered | gi|2863412631|gb|CP145450.1| | 1461544 | g6358 | i0 | 100 | 0.250746268656716 | 28 | 0 | 8 | 0 | 252 | 279 | 747765 | 747738 | Chloropicon roscoffensis strain CCMP1998 chromosome 10 | blastn | 84 | 52.8 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon roscoffensis | ||
| 9923348 | 9923348 | PRJEB673_P_NODE_12148_length_156_cov_0.983471_g11799_i0 | PRJEB673 | 12148 | 156 | 0.983471 | 1.53421476 | root | 1 | Root_unresolved | Root_unresolved | 147 | 5.73e-31 | NTclustered | gi|255087347|ref|XM_002505551.1| | 296587 | g11799 | i0 | 85.714 | 76.6923076923077 | 140 | 18 | 89 | 2 | 18 | 156 | 608 | 470 | Micromonas commoda predicted protein partial mRNA | blastn | 11964 | 147 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 10338015 | 10338015 | PRJEB673_P_NODE_9769_length_187_cov_3.355263_g9420_i0 | PRJEB673 | 9769 | 187 | 3.355263 | 6.27434181 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 58.4 | 3.44e-4 | NTclustered | gi|2082237163|ref|XM_043058766.1| | 3055 | g9420 | i0 | 100 | 0.561497326203209 | 31 | 0 | 17 | 0 | 146 | 176 | 198 | 228 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g039250v5), mRNA | blastn | 105 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 14163276 | 14163276 | PRJEB673_P_NODE_13052_length_150_cov_1.043478_g12703_i0 | PRJEB673 | 13052 | 150 | 1.043478 | 1.565217 | Chlorella variabilis | 554065 | Plants | Plants | 122 | 9.18e-24 | NTclustered | gi|552813385|ref|XM_005843877.1| | 554065 | g12703 | i0 | 82.857 | 2.53333333333333 | 140 | 21 | 93 | 2 | 1 | 140 | 1233 | 1369 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_59785) mRNA, complete cds | blastn | 380 | 122 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 17573194 | 17573194 | PRJEB673_P_NODE_12314_length_154_cov_2.210084_g11965_i0 | PRJEB673 | 12314 | 154 | 2.210084 | 3.40352936 | Eukaryota | 2759 | Plants | Plants | 110 | 7.39e-20 | NTclustered | gi|760450068|ref|XM_011403801.1| | 3075 | g11965 | i0 | 90.361 | 55.5974025974026 | 83 | 8 | 54 | 0 | 1 | 83 | 322 | 404 | Auxenochlorella protothecoides Peptidyl-prolyl cis-trans isomerase CYP18-4 partial mRNA | blastn | 8562 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 17986491 | 17986491 | PRJEB673_P_NODE_4315_length_462_cov_1.498829_g3972_i0 | PRJEB673 | 4315 | 462 | 1.498829 | 6.92458998 | Micromonas commoda | 296587 | Plants | Plants | 169 | 4.27e-37 | NTclustered | gi|255074984|ref|XM_002501121.1| | 296587 | g3972 | i0 | 80.169 | 1.504329004329 | 237 | 37 | 50 | 9 | 36 | 267 | 560 | 329 | Micromonas commoda mitochondrial carrier family partial mRNA | blastn | 695 | 169 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 24360738 | 24360738 | PRJEB673_P_NODE_6120_length_354_cov_1.645768_g5771_i0 | PRJEB673 | 6120 | 354 | 1.645768 | 5.82601872 | Monoraphidium neglectum | 145388 | Plants | Plants | 178 | 5.289999999999999e-40 | NTclustered | gi|926781811|ref|XM_014043926.1| | 145388 | g5771 | i0 | 89.855 | 44.0988700564972 | 138 | 14 | 39 | 0 | 216 | 353 | 225 | 88 | Monoraphidium neglectum peptidyl-prolyl cis-trans isomerase, cyclophilin-type mRNA | blastn | 15611 | 178 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum |
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);;