contig_metadata
16 rows where bioproject = "PRJNA274362" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370814 | 370814 | PRJNA274362_S_NODE_36021_length_164_cov_0.904348_g35901_i0 | PRJNA274362 | 36021 | 164 | 0.904348 | 1.48313072 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 117 | 4.79e-22 | NTclustered | gi|2082237132|ref|XM_001689609.2| | 3055 | g35901 | i0 | 80.667 | 1.82926829268293 | 150 | 29 | 91 | 0 | 13 | 162 | 513 | 662 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g038400v5), mRNA | blastn | 300 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 2921543 | 2921543 | PRJNA274362_S_NODE_5203_length_366_cov_2.451104_g5083_i0 | PRJNA274362 | 5203 | 366 | 2.451104 | 8.97104064 | Astrephomene gubernaculifera | 47775 | Plants | Plants | 85.9 | 1.82e-18 | NR | GFR49314.1 | 47775 | g5083 | i0 | 50 | 1.68032786885246 | 104 | 50 | 85.2 | 1 | 363 | 52 | 48 | 149 | GFR49314.1 hypothetical protein Agub_g11337, partial [Astrephomene gubernaculifera] | diamond | 615 | 85.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 5473690 | 5473690 | PRJNA274362_S_NODE_12565_length_250_cov_1.671642_g12445_i0 | PRJNA274362 | 12565 | 250 | 1.671642 | 4.179105 | Trebouxia | 13786 | Plants | Plants | 136 | 4.18e-39 | NR | KAA6423511.1 | 2608996 | g12445 | i0 | 80.5 | 6.888 | 82 | 16 | 98.4 | 0 | 3 | 248 | 2 | 83 | KAA6423511.1 MAG: ribosomal component of cytosolic 80S ribosome and 40S small subunit [Trebouxia sp. A1-2] | diamond | 1722 | 136 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 5474312 | 5474312 | PRJNA274362_S_NODE_7165_length_319_cov_1.622222_g7045_i0 | PRJNA274362 | 7165 | 319 | 1.622222 | 5.17488818 | Prototheca blaschkeae | 328666 | Plants | Plants | 300 | 9.67e-77 | NTclustered | gi|1159431138|gb|KX389282.1| | 328666 | g7045 | i0 | 83.81 | 67.2539184952978 | 315 | 51 | 99 | 0 | 5 | 319 | 826 | 512 | Prototheca blaschkeae isolate SAG-2064 alpha tubulin (TUA1) mRNA, complete cds | blastn | 21454 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca blaschkeae | |
| 8024233 | 8024233 | PRJNA274362_S_NODE_5527_length_357_cov_2.701299_g5407_i0 | PRJNA274362 | 5527 | 357 | 2.701299 | 9.64363743 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 193 | 1.91e-44 | NTclustered | gi|28193497|emb|AJ439528.1| | 37502 | g5407 | i0 | 77.313 | 77.0224089635854 | 335 | 70 | 93 | 5 | 4 | 335 | 584 | 253 | Polytomella sp. 'Pringsheim 198.80' mRNA for 40S ribosomal protein s5 (rs5 gene) | blastn | 27497 | 193 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 12537076 | 12537076 | PRJNA274362_S_NODE_14730_length_234_cov_1.113514_g14610_i0 | PRJNA274362 | 14730 | 234 | 1.113514 | 2.60562276 | Eukaryota | 2759 | Plants | Plants | 120 | 1.36e-32 | NR | KAK2076719.1 | 3111 | g14610 | i0 | 70.5 | 40.3333333333333 | 78 | 21 | 97.4 | 1 | 232 | 5 | 76 | 153 | KAK2076719.1 30S ribosomal protein S11, chloroplastic [Prototheca wickerhamii] | diamond | 9438 | 120 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 18222370 | 18222370 | PRJNA274362_S_NODE_29095_length_176_cov_1.220472_g28975_i0 | PRJNA274362 | 29095 | 176 | 1.220472 | 2.14803072 | Chlorophyta | 3041 | Plants | Plants | 90.1 | 1.2600000000000002e-21 | NR | CAG9463659.1 | 765719 | g28975 | i0 | 76.4 | 1.89204545454545 | 55 | 13 | 93.8 | 0 | 169 | 5 | 4 | 58 | CAG9463659.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 333 | 90.9 | 0.991199119911991 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 22047446 | 22047446 | PRJNA274362_S_NODE_9038_length_287_cov_1.256303_g8918_i0 | PRJNA274362 | 9038 | 287 | 1.256303 | 3.60558961 | Trebouxia sp. C | 2796353 | Plants | Plants | 73.6 | 1.82e-14 | NR | KAL0042167.1 | 2905653 | g8918 | i0 | 55.4 | 0.585365853658537 | 56 | 25 | 58.5 | 0 | 243 | 76 | 5 | 60 | KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004] | diamond | 168 | 73.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 23322414 | 23322414 | PRJNA274362_S_NODE_16039_length_225_cov_1.994318_g15919_i0 | PRJNA274362 | 16039 | 225 | 1.994318 | 4.4872155 | Chlorophyta | 3041 | Plants | Plants | 81.6 | 9.87e-18 | NR | XP_011398628.1 | 3075 | g15919 | i0 | 59.7 | 1.66666666666667 | 67 | 27 | 89.3 | 0 | 7 | 207 | 64 | 130 | XP_011398628.1 40S ribosomal protein S17 [Auxenochlorella protothecoides] | diamond | 375 | 81.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 24596544 | 24596544 | PRJNA274362_S_NODE_17280_length_219_cov_0.858824_g17160_i0 | PRJNA274362 | 17280 | 219 | 0.858824 | 1.88082456 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 54.7 | 0.005 | NTclustered | gi|2082257431|ref|XM_043067004.1| | 3055 | g17160 | i0 | 100 | 0.132420091324201 | 29 | 0 | 13 | 0 | 144 | 172 | 3514 | 3486 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_10g453500v5), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 26884380 | 26884380 | PRJNA274362_S_NODE_14801_length_233_cov_1.695652_g14681_i0 | PRJNA274362 | 14801 | 233 | 1.695652 | 3.95086916 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 105 | 1.32e-25 | NR | KAF6257032.1 | 2650976 | g14681 | i0 | 70.7 | 14.4721030042918 | 75 | 20 | 94 | 1 | 3 | 221 | 60 | 134 | KAF6257032.1 component of cytosolic 80S ribosome and 40S small subunit [Scenedesmus sp. NREL 46B-D3] | diamond | 3372 | 105 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 29933996 | 29933996 | PRJNA274362_S_NODE_27331_length_181_cov_1.181818_g27211_i0 | PRJNA274362 | 27331 | 181 | 1.181818 | 2.13909058 | Chlamydomonadales | 3042 | Plants | Plants | 85.5 | 1.09e-17 | NR | GFR39621.1 | 47775 | g27211 | i0 | 63.3 | 4.97237569060773 | 60 | 22 | 99.4 | 0 | 1 | 180 | 145 | 204 | GFR39621.1 hypothetical protein Agub_g85 [Astrephomene gubernaculifera] | diamond | 900 | 86.3 | 0.990730011587486 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 30281764 | 30281764 | PRJNA274362_S_NODE_34392_length_166_cov_0.888889_g34272_i0 | PRJNA274362 | 34392 | 166 | 0.888889 | 1.47555574 | Eukaryota | 2759 | Plants | Plants | 94 | 7.189999999999999e-23 | NR | XP_011398510.1 | 3075 | g34272 | i0 | 70.4 | 15.7771084337349 | 54 | 16 | 97.6 | 0 | 166 | 5 | 64 | 117 | XP_011398510.1 FK506-binding protein 2 [Auxenochlorella protothecoides] | diamond | 2619 | 94.4 | 0.995762711864407 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 30881591 | 30881591 | PRJNA274362_S_NODE_35894_length_164_cov_0.904348_g35774_i0 | PRJNA274362 | 35894 | 164 | 0.904348 | 1.48313072 | Eukaryota | 2759 | Plants | Plants | 84 | 4.42e-18 | NR | KAJ9523531.1 | 44745 | g35774 | i0 | 76.6 | 13.8475609756098 | 47 | 11 | 86 | 0 | 146 | 6 | 153 | 199 | KAJ9523531.1 hypothetical protein QJQ45_007193 [Haematococcus lacustris] | diamond | 2271 | 84.7 | 0.991735537190083 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 31260870 | 31260870 | PRJNA274362_S_NODE_12975_length_247_cov_1.222222_g12855_i0 | PRJNA274362 | 12975 | 247 | 1.222222 | 3.01888834 | Eukaryota | 2759 | Plants | Plants | 114 | 4.39e-29 | NR | KAJ9522600.1 | 44745 | g12855 | i0 | 71.6 | 16.748987854251 | 74 | 21 | 89.9 | 0 | 5 | 226 | 155 | 228 | KAJ9522600.1 hypothetical protein QJQ45_019660 [Haematococcus lacustris] | diamond | 4137 | 114 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 31622616 | 31622616 | PRJNA274362_S_NODE_26116_length_185_cov_0.977941_g25996_i0 | PRJNA274362 | 26116 | 185 | 0.977941 | 1.80919085 | Edaphochlamys debaryana | 47281 | Plants | Plants | 73.6 | 1.15e-13 | NR | KAG2489093.1 | 47281 | g25996 | i0 | 60 | 9.0972972972973 | 55 | 22 | 89.2 | 0 | 173 | 9 | 41 | 95 | KAG2489093.1 hypothetical protein HYH03_012319 [Edaphochlamys debaryana] | diamond | 1683 | 73.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana |
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);;