contig_metadata
12 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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);;