contig_metadata
15 rows where bioproject = "PRJEB673" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 7787295 | 7787295 | PRJEB673_P_NODE_4327_length_460_cov_2.188235_g3984_i0 | PRJEB673 | 4327 | 460 | 2.188235 | 10.065881 | Eukaryota | 2759 | Plants | Plants | 223 | 2.87e-64 | NR | PRW60132.1 | 3076 | g3984 | i0 | 68.8 | 72.8086956521739 | 160 | 42 | 99.1 | 1 | 3 | 458 | 41 | 200 | PRW60132.1 60S ribosomal L15 [Chlorella sorokiniana] | diamond | 33492 | 225 | 0.991111111111111 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 10338014 | 10338014 | PRJEB673_P_NODE_9749_length_188_cov_1.751634_g9400_i0 | PRJEB673 | 9749 | 188 | 1.751634 | 3.29307192 | Eukaryota | 2759 | Plants | Plants | 88.2 | 1.74e-18 | NR | PRW44927.1 | 3076 | g9400 | i0 | 61.3 | 15.3829787234043 | 62 | 24 | 98.9 | 0 | 1 | 186 | 725 | 786 | PRW44927.1 60S ribosomal L3 [Chlorella sorokiniana] | diamond | 2892 | 89 | 0.991011235955056 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 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 | |
| 23086700 | 23086700 | PRJEB673_P_NODE_3439_length_538_cov_1.347913_g3121_i0 | PRJEB673 | 3439 | 538 | 1.347913 | 7.25177194 | Eukaryota | 2759 | Plants | Plants | 239 | 3.01e-76 | NR | KAF5839439.1 | 3046 | g3121 | i0 | 65.4 | 78.8531598513011 | 179 | 61 | 99.8 | 1 | 538 | 2 | 76 | 253 | KAF5839439.1 ribosoaml protein S2 [Dunaliella salina] | diamond | 42423 | 240 | 0.995833333333333 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 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 | |
| 26781030 | 26781030 | PRJEB673_P_NODE_10241_length_178_cov_1.118881_g9892_i0 | PRJEB673 | 10241 | 178 | 1.118881 | 1.99160818 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 99.4 | 1.0399999999999997e-23 | NR | KAG1656054.1 | 1653778 | g9892 | i0 | 78.9 | 4.83707865168539 | 57 | 12 | 96.1 | 0 | 174 | 4 | 44 | 100 | KAG1656054.1 hypothetical protein FOA52_004473 [Chlamydomonas sp. UWO 241] | diamond | 861 | 99.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 | |
| 27191996 | 27191996 | PRJEB673_P_NODE_10302_length_177_cov_1.049296_g9953_i0 | PRJEB673 | 10302 | 177 | 1.049296 | 1.85725392 | Chlamydomonas incerta | 51695 | Plants | Plants | 81.6 | 2.93e-16 | NR | KAG2439423.1 | 51695 | g9953 | i0 | 70.7 | 17.6949152542373 | 58 | 17 | 98.3 | 0 | 176 | 3 | 510 | 567 | KAG2439423.1 hypothetical protein HXX76_004780 [Chlamydomonas incerta] | diamond | 3132 | 81.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 28107866 | 28107866 | PRJEB673_P_NODE_13045_length_150_cov_1.043478_g12696_i0 | PRJEB673 | 13045 | 150 | 1.043478 | 1.565217 | Gonium pectorale | 33097 | Plants | Plants | 61.6 | 2.22e-9 | NR | KXZ50275.1 | 33097 | g12696 | i0 | 54.2 | 2.92 | 48 | 22 | 96 | 0 | 3 | 146 | 299 | 346 | KXZ50275.1 hypothetical protein GPECTOR_17g914 [Gonium pectorale] | diamond | 438 | 61.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 28953562 | 28953562 | PRJEB673_P_NODE_8528_length_265_cov_1.217391_g8179_i0 | PRJEB673 | 8528 | 265 | 1.217391 | 3.22608615 | Eukaryota | 2759 | Plants | Plants | 103 | 2.2699999999999994e-23 | NR | XP_011401541.1 | 3075 | g8179 | i0 | 62.1 | 7.6188679245283 | 87 | 33 | 98.5 | 0 | 265 | 5 | 403 | 489 | XP_011401541.1 T-complex protein 1 subunit alpha [Auxenochlorella protothecoides] | diamond | 2019 | 103 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 29528949 | 29528949 | PRJEB673_P_NODE_8390_length_280_cov_1.306122_g8041_i0 | PRJEB673 | 8390 | 280 | 1.306122 | 3.6571416 | Symbiochloris irregularis | 706552 | Plants | Plants | 119 | 3.53e-29 | NR | KAK9805450.1 | 706552 | g8041 | i0 | 71.7 | 4.92857142857143 | 92 | 25 | 98.6 | 1 | 278 | 3 | 386 | 476 | KAK9805450.1 hypothetical protein WJX73_008571 [Symbiochloris irregularis] | diamond | 1380 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 29876270 | 29876270 | PRJEB673_P_NODE_6971_length_328_cov_1.511945_g6622_i0 | PRJEB673 | 6971 | 328 | 1.511945 | 4.9591796 | Volvox carteri f. nagariensis | 3068 | Plants | Plants | 68.6 | 8.78e-11 | NR | XP_002951961.1 | 3068 | g6622 | i0 | 50 | 0.676829268292683 | 74 | 24 | 59.5 | 2 | 207 | 13 | 569 | 638 | XP_002951961.1 cysteine protease [Volvox carteri f. nagariensis] | diamond | 222 | 68.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 30508049 | 30508049 | PRJEB673_P_NODE_8493_length_269_cov_1.529915_g8144_i0 | PRJEB673 | 8493 | 269 | 1.529915 | 4.11547135 | [Myrmecia] bisecta | 41462 | Plants | Plants | 57 | 5.98e-8 | NR | KAK9808837.1 | 41462 | g8144 | i0 | 59 | 0.434944237918216 | 39 | 16 | 43.5 | 0 | 151 | 267 | 11 | 49 | KAK9808837.1 hypothetical protein WJX72_004716 [[Myrmecia] bisecta] | diamond | 117 | 57 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta |
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);;