RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA274362" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA274362 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
8711292 8711292 PRJNA274362_S_NODE_33447_length_167_cov_0.881356_g33327_i0 PRJNA274362 33447 167 0.881356 1.47186452 Cymbomonas tetramitiformis 36881 Plants Plants 105 7.5e-25   NR KAK3247435.1 36881 g33327 i0 80 0.988023952095808 55 11 98.8 0 166 2 181 235 KAK3247435.1 hypothetical protein CYMTET_43067, partial [Cymbomonas tetramitiformis] diamond 165 105 1 Eukaryota   Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Cymbomonas Cymbomonas tetramitiformis
9298346 9298346 PRJNA274362_S_NODE_11068_length_264_cov_1.186047_g10948_i0 PRJNA274362 11068 264 1.186047 3.13116408 Opisthokonta 33154 Plants Plants 94.4 3.84e-22   NR GHP03550.1 41880 g10948 i0 68.2 5.875 66 21 75 0 1 198 100 165 GHP03550.1 60S ribosomal protein L12 [Pycnococcus provasolii] diamond 1551 94.7 0.996832101372756 Eukaryota   Viridiplantae Chlorophyta Pseudoscourfieldiophyceae Pseudoscourfieldiales Pycnococcaceae Pycnococcus Pycnococcus provasolii
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
27263834 27263834 PRJNA274362_S_NODE_36683_length_163_cov_0.912281_g36563_i0 PRJNA274362 36683 163 0.912281 1.48701803 Ostreococcus tauri 70448 Plants Plants 65.1 1.66e-10   NR OUS47141.1 70448 g36563 i0 58.5 1.95092024539877 53 22 97.5 0 4 162 818 870 OUS47141.1 putative vacuolar proton-ATPase subunit [Ostreococcus tauri] diamond 318 65.1 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Ostreococcus Ostreococcus tauri
28639432 28639432 PRJNA274362_S_NODE_32187_length_169_cov_0.866667_g32067_i0 PRJNA274362 32187 169 0.866667 1.46466723 Viridiplantae 33090 Plants Plants 80.5 2.77e-17   NR GHP03550.1 41880 g32067 i0 74.5 2.75147928994083 51 13 90.5 0 2 154 114 164 GHP03550.1 60S ribosomal protein L12 [Pycnococcus provasolii] diamond 465 80.5 1 Eukaryota   Viridiplantae Chlorophyta Pseudoscourfieldiophyceae Pseudoscourfieldiales Pycnococcaceae Pycnococcus Pycnococcus provasolii
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
30913404 30913404 PRJNA274362_S_NODE_35914_length_164_cov_0.904348_g35794_i0 PRJNA274362 35914 164 0.904348 1.48313072 Opisthokonta 33154 Plants Plants 81.6 1.1e-16   NR QDZ20675.1 1764295 g35794 i0 67.9 8.59756097560976 53 17 97 0 163 5 265 317 QDZ20675.1 receptor of activated protein kinase C [Chloropicon primus] diamond 1410 82 0.995121951219512 Eukaryota   Viridiplantae Chlorophyta Chloropicophyceae Chloropicales Chloropicaceae Chloropicon Chloropicon primus
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
32241807 32241807 PRJNA274362_S_NODE_37038_length_162_cov_2.238938_g36918_i0 PRJNA274362 37038 162 2.238938 3.62707956 Eukaryota 2759 Plants Plants 70.5 1.99e-12   NR KAK3260030.1 36881 g36918 i0 62.7 4.83333333333333 51 19 94.4 0 8 160 135 185 KAK3260030.1 hypothetical protein CYMTET_30995, partial [Cymbomonas tetramitiformis] diamond 783 70.9 0.994358251057828 Eukaryota   Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Cymbomonas Cymbomonas tetramitiformis
32729264 32729264 PRJNA274362_S_NODE_22740_length_195_cov_3.000000_g22620_i0 PRJNA274362 22740 195 3 5.85 Micromonas pusilla CCMP1545 564608 Plants Plants 97.8 1.2699999999999999e-23   NR XP_003062276.1 564608 g22620 i0 68.8 4.89230769230769 64 20 98.5 0 194 3 19 82 XP_003062276.1 uncharacterized protein MICPUCDRAFT_48485 [Micromonas pusilla CCMP1545] diamond 954 97.8 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas pusilla

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;