RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB29441 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
26413 26413 PRJEB29441_P_NODE_24681_length_212_cov_1.509202_g24240_i0 PRJEB29441 24681 212 1.509202 3.19950824 Sanguina aurantia 2578422 Plants Plants 76.6 9.94e-16   NR MEW5299406.1 2578422 g24240 i0 86 5.47641509433962 43 6 60.8 0 130 2 26 68 MEW5299406.1 hypothetical protein [Sanguina aurantia] diamond 1161 76.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Sanguina Sanguina aurantia
17878027 17878027 PRJEB29441_P_NODE_20975_length_231_cov_1.961538_g20534_i0 PRJEB29441 20975 231 1.961538 4.53115278 Chlorophyta 3041 Plants Plants 159 2.7399999999999997e-47   NR AIY63581.1 464287 g20534 i0 89.6 9 77 8 100 0 1 231 106 182 AIY63581.1 photosystem II 44 kDa protein, partial [Pseudococcomyxa simplex] diamond 2079 159 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Oocystaceae Pseudococcomyxa Pseudococcomyxa simplex
20427111 20427111 PRJEB29441_P_NODE_22837_length_221_cov_1.744186_g22396_i0 PRJEB29441 22837 221 1.744186 3.85465106 Auxenochlorella protothecoides 3075 Plants Plants 145 3.96e-40   NR YP_009019355.1 3075 g22396 i0 95.8 7.81900452488688 72 3 97.7 0 1 216 336 407 YP_009019355.1 CP43 chlorophyll apoprotein of photosystem II [Auxenochlorella protothecoides] diamond 1728 145 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella protothecoides
22978328 22978328 PRJEB29441_P_NODE_18219_length_251_cov_3.648515_g17778_i0 PRJEB29441 18219 251 3.648515 9.15777265 Eukaryota 2759 Plants Plants 181 6e-53   NR NP_958422.1 3055 g17778 i0 100 29.7490039840637 83 0 99.2 0 1 249 307 389 NP_958422.1 photosystem II 44 kDa protein [Chlamydomonas reinhardtii] diamond 7467 181 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
28296473 28296473 PRJEB29441_P_NODE_40106_length_166_cov_0.871795_g39665_i0 PRJEB29441 40106 166 0.871795 1.4471797 Coccomyxa viridis 1274662 Plants Plants 64.7 5.03e-11   NR CAL5220354.1 1274662 g39665 i0 51.9 2.81927710843373 52 25 94 0 156 1 32 83 CAL5220354.1 g2351 [Coccomyxa viridis] diamond 468 64.7 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa viridis
28549390 28549390 PRJEB29441_P_NODE_47447_length_161_cov_0.910714_g47006_i0 PRJEB29441 47447 161 0.910714 1.46624954 Coccomyxa subellipsoidea C-169 574566 Plants Plants 43.9 0.00487   NR XP_005649672.1 574566 g47006 i0 65.2 0.428571428571429 23 8 42.9 0 146 78 3372 3394 XP_005649672.1 hypothetical protein COCSUDRAFT_61368 [Coccomyxa subellipsoidea C-169] diamond 69 43.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea
29142854 29142854 PRJEB29441_P_NODE_44289_length_163_cov_0.894737_g43848_i0 PRJEB29441 44289 163 0.894737 1.45842131 Oedogoniaceae 2682485 Plants Plants 87.8 1.66e-18   NR AYQ95216.1 132247 g43848 i0 75.5 2.8159509202454 49 12 90.2 0 2 148 182 230 AYQ95216.1 hypothetical protein [Trochiscia hystrix] diamond 459 88.2 0.99546485260771 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae     Trochiscia Trochiscia hystrix
29149481 29149481 PRJEB29441_P_NODE_37949_length_169_cov_1.275000_g37508_i0 PRJEB29441 37949 169 1.275 2.15475 Ostreococcus tauri 70448 Plants Plants 44.7 0.00292   NR OUS48979.1 70448 g37508 i0 41.1 0.994082840236686 56 28 97.6 2 2 166 523 574 OUS48979.1 P-loop containing nucleoside triphosphate hydrolase protein [Ostreococcus tauri] diamond 168 44.7 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Ostreococcus Ostreococcus tauri
30096319 30096319 PRJEB29441_P_NODE_30152_length_191_cov_0.859155_g29711_i0 PRJEB29441 30152 191 0.859155 1.64098605 Ostreococcus tauri 70448 Plants Plants 65.1 2.43e-10   NR OUS48979.1 70448 g29711 i0 55.8 0.816753926701571 52 23 81.7 0 161 6 312 363 OUS48979.1 P-loop containing nucleoside triphosphate hydrolase protein [Ostreococcus tauri] diamond 156 65.1 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Ostreococcus Ostreococcus tauri
30665170 30665170 PRJEB29441_P_NODE_47753_length_160_cov_2.576577_g47312_i0 PRJEB29441 47753 160 2.576577 4.1225232 Auxenochlorella protothecoides 3075 Plants Plants 52.4 4.81e-6   NR RMZ56692.1 3075 g47312 i0 41.5 1.9875 53 31 99.4 0 1 159 364 416 RMZ56692.1 hypothetical protein APUTEX25_002781, partial [Auxenochlorella protothecoides] diamond 318 52.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella protothecoides
31170466 31170466 PRJEB29441_P_NODE_20455_length_235_cov_1.370968_g20014_i0 PRJEB29441 20455 235 1.370968 3.2217748 Ostreobium quekettii 121088 Plants Plants 50.8 4.83e-5   NR CAD7697224.1 121088 g20014 i0 42.6 2.60425531914894 61 33 76.6 2 2 181 456 515 CAD7697224.1 unnamed protein product [Ostreobium quekettii] diamond 612 50.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Bryopsidales Ostreobiaceae Ostreobium Ostreobium quekettii
31195404 31195404 PRJEB29441_P_NODE_40795_length_166_cov_0.871795_g40354_i0 PRJEB29441 40795 166 0.871795 1.4471797 Trebouxiophyceae 75966 Plants Plants 48.9 3.69e-5   NR KAK9805576.1 41462 g40354 i0 59.4 1.21084337349398 32 13 57.8 0 71 166 70 101 KAK9805576.1 hypothetical protein WJX72_006079 [[Myrmecia] bisecta] diamond 201 49.3 0.991886409736308 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Myrmecia [Myrmecia] bisecta
32056331 32056331 PRJEB29441_P_NODE_40458_length_166_cov_0.871795_g40017_i0 PRJEB29441 40458 166 0.871795 1.4471797 Chlorella vulgaris 3077 Plants Plants 73.2 2.46e-13   NR KAI3437931.1 3077 g40017 i0 54.1 3.21686746987952 61 22 99.4 2 166 2 206 266 KAI3437931.1 hypothetical protein D9Q98_000375 [Chlorella vulgaris] diamond 534 73.2 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella vulgaris
32271478 32271478 PRJEB29441_P_NODE_41818_length_165_cov_0.879310_g41377_i0 PRJEB29441 41818 165 0.87931 1.4508615 Chlorophyta 3041 Plants Plants 80.1 1.03e-17   NR YP_001382178.1 34116 g41377 i0 68.5 7.85454545454545 54 17 98.2 0 163 2 20 73 YP_001382178.1 ribosomal protein L20 [Pleurastrum terricola] diamond 1296 80.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Pleurastraceae Pleurastrum Pleurastrum terricola
32467948 32467948 PRJEB29441_P_NODE_40579_length_166_cov_0.871795_g40138_i0 PRJEB29441 40579 166 0.871795 1.4471797 Sanguina aurantia 2578422 Plants Plants 71.6 3.37e-14   NR MEW5301384.1 2578422 g40138 i0 79.6 7.12048192771084 49 10 88.6 0 17 163 4 52 MEW5301384.1 hypothetical protein [Sanguina aurantia] diamond 1182 71.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Sanguina Sanguina aurantia
32814474 32814474 PRJEB29441_P_NODE_14780_length_284_cov_2.272340_g14339_i0 PRJEB29441 14780 284 2.27234 6.4534456 Tetrabaena socialis 47790 Plants Plants 41.6 0.0449   NR PNH10538.1 47790 g14339 i0 36.7 0.517605633802817 49 31 51.8 0 164 18 58 106 PNH10538.1 hypothetical protein TSOC_002711 [Tetrabaena socialis] diamond 147 41.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Tetrabaenaceae Tetrabaena Tetrabaena socialis

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