contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 430848 | 430848 | PRJNA436017_P_NODE_25941_length_160_cov_1.268293_g25643_i0 | PRJNA436017 | 25941 | 160 | 1.268293 | 2.0292688 | Chloropicon roscoffensis | 1461544 | Plants | Plants | 94 | 1.5000000000000002e-22 | NR | XKU15059.1 | 1461544 | g25643 | i0 | 76.4 | 6.1875 | 55 | 11 | 99.4 | 1 | 160 | 2 | 32 | 86 | XKU15059.1 cyclophilin-type peptidyl-prolyl cis-trans isomerase [Chloropicon roscoffensis] | diamond | 990 | 94 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon roscoffensis | ||
| 8084279 | 8084279 | PRJNA436017_P_NODE_6567_length_349_cov_2.051282_g6270_i0 | PRJNA436017 | 6567 | 349 | 2.051282 | 7.15897418 | [Myrmecia] bisecta | 41462 | Plants | Plants | 112 | 6.18e-30 | NR | KAK9808664.1 | 41462 | g6270 | i0 | 66.2 | 2.03724928366762 | 77 | 26 | 66.2 | 0 | 302 | 72 | 8 | 84 | KAK9808664.1 hypothetical protein WJX72_001536 [[Myrmecia] bisecta] | diamond | 711 | 112 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 9359045 | 9359045 | PRJNA436017_P_NODE_4388_length_441_cov_2.675743_g4095_i0 | PRJNA436017 | 4388 | 441 | 2.675743 | 11.80002663 | Picochlorum sp. BPE23 | 2696299 | Plants | Plants | 194 | 1.13e-57 | NR | KAI8107334.1 | 2696299 | g4095 | i0 | 69.6 | 12.1904761904762 | 138 | 42 | 93.9 | 0 | 27 | 440 | 1 | 138 | KAI8107334.1 hypothetical protein M9434_001976 [Picochlorum sp. BPE23] | diamond | 5376 | 194 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. BPE23 | |||
| 18282577 | 18282577 | PRJNA436017_P_NODE_5315_length_394_cov_1.795518_g5019_i0 | PRJNA436017 | 5315 | 394 | 1.795518 | 7.07434092 | Eukaryota | 2759 | Plants | Plants | 107 | 2.06e-26 | NR | CAL5219011.1 | 1274662 | g5019 | i0 | 56.6 | 5.3756345177665 | 106 | 41 | 76.9 | 1 | 8 | 310 | 83 | 188 | CAL5219011.1 g767 [Coccomyxa viridis] | diamond | 2118 | 108 | 0.990740740740741 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 20215255 | 20215255 | PRJNA436017_P_NODE_2116_length_651_cov_2.379479_g1877_i0 | PRJNA436017 | 2116 | 651 | 2.379479 | 15.49040829 | Opisthokonta | 33154 | Plants | Plants | 107 | 1.72e-25 | NR | XP_003056162.1 | 564608 | g1877 | i0 | 46 | 6.08294930875576 | 126 | 66 | 57.1 | 2 | 617 | 246 | 1 | 126 | XP_003056162.1 40S ribosomal protein S10 [Micromonas pusilla CCMP1545] | diamond | 3960 | 107 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 27281994 | 27281994 | PRJNA436017_P_NODE_8883_length_293_cov_1.679688_g8585_i0 | PRJNA436017 | 8883 | 293 | 1.679688 | 4.92148584 | Eukaryota | 2759 | Plants | Plants | 110 | 6.04e-29 | NR | KAK2079218.1 | 3111 | g8585 | i0 | 69.6 | 35.9078498293515 | 79 | 23 | 80.9 | 1 | 292 | 56 | 21 | 98 | KAK2079218.1 40s ribosomal protein L44e [Prototheca wickerhamii] | diamond | 10521 | 111 | 0.990990990990991 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 27360474 | 27360474 | PRJNA436017_P_NODE_13123_length_232_cov_1.153846_g12825_i0 | PRJNA436017 | 13123 | 232 | 1.153846 | 2.67692272 | Prototheca wickerhamii | 3111 | Plants | Plants | 65.1 | 2.09e-10 | NR | KAK2076131.1 | 3111 | g12825 | i0 | 49.2 | 0.84051724137931 | 65 | 33 | 84.1 | 0 | 195 | 1 | 1 | 65 | KAK2076131.1 hypothetical protein QBZ16_001063 [Prototheca wickerhamii] | diamond | 195 | 65.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 27471601 | 27471601 | PRJNA436017_P_NODE_17963_length_193_cov_2.448718_g17665_i0 | PRJNA436017 | 17963 | 193 | 2.448718 | 4.72602574 | Opisthokonta | 33154 | Plants | Plants | 78.6 | 7.1e-17 | NR | KAK3249024.1 | 36881 | g17665 | i0 | 80 | 8.34715025906736 | 50 | 7 | 77.7 | 1 | 191 | 42 | 27 | 73 | KAK3249024.1 ribosomal protein S14, S11, partial [Cymbomonas tetramitiformis] | diamond | 1611 | 79.3 | 0.991172761664565 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 27833867 | 27833867 | PRJNA436017_P_NODE_4644_length_426_cov_3.372751_g4348_i0 | PRJNA436017 | 4644 | 426 | 3.372751 | 14.36791926 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 135 | 3.42e-37 | NR | KAK3279886.1 | 36881 | g4348 | i0 | 56.5 | 5.54929577464789 | 131 | 53 | 92.3 | 1 | 394 | 2 | 1 | 127 | KAK3279886.1 60S ribosomal protein L18 [Cymbomonas tetramitiformis] | diamond | 2364 | 135 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 28166189 | 28166189 | PRJNA436017_P_NODE_25325_length_162_cov_1.232000_g25027_i0 | PRJNA436017 | 25325 | 162 | 1.232 | 1.99584 | Viridiplantae | 33090 | Plants | Plants | 106 | 3.63e-25 | NR | XP_007508155.1 | 41875 | g25027 | i0 | 94.3 | 30.3333333333333 | 53 | 3 | 98.1 | 0 | 160 | 2 | 265 | 317 | XP_007508155.1 unnamed protein product [Bathycoccus prasinos] | diamond | 4914 | 106 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 29918030 | 29918030 | PRJNA436017_P_NODE_23231_length_169_cov_1.757576_g22933_i0 | PRJNA436017 | 23231 | 169 | 1.757576 | 2.97030344 | Volvox reticuliferus | 1737510 | Plants | Plants | 46.2 | 3.88e-4 | NR | GIL81710.1 | 1737510 | g22933 | i0 | 60 | 1.24260355029586 | 35 | 14 | 62.1 | 0 | 169 | 65 | 119 | 153 | GIL81710.1 hypothetical protein Vretifemale_10726, partial [Volvox reticuliferus] | diamond | 210 | 46.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox reticuliferus | |
| 30107331 | 30107331 | PRJNA436017_P_NODE_4992_length_408_cov_2.420485_g4696_i0 | PRJNA436017 | 4992 | 408 | 2.420485 | 9.8755788 | Bathycoccus prasinos | 41875 | Plants | Plants | 126 | 2.5e-34 | NR | XP_007512139.1 | 41875 | g4696 | i0 | 58.5 | 5.47058823529412 | 123 | 49 | 90.4 | 1 | 30 | 398 | 1 | 121 | XP_007512139.1 60S ribosomal protein L26 [Bathycoccus prasinos] | diamond | 2232 | 126 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 30201969 | 30201969 | PRJNA436017_P_NODE_1072_length_904_cov_3.083045_g909_i0 | PRJNA436017 | 1072 | 904 | 3.083045 | 27.8707268 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 192 | 9.859999999999996e-55 | NR | XP_005650389.1 | 574566 | g909 | i0 | 53.2 | 1.95796460176991 | 203 | 94 | 67 | 1 | 899 | 294 | 152 | 354 | XP_005650389.1 hypothetical protein COCSUDRAFT_52595 [Coccomyxa subellipsoidea C-169] | diamond | 1770 | 192 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 30439994 | 30439994 | PRJNA436017_P_NODE_10013_length_273_cov_1.644068_g9715_i0 | PRJNA436017 | 10013 | 273 | 1.644068 | 4.48830564 | Chlamydomonadales | 3042 | Plants | Plants | 83.2 | 5.15e-17 | NR | KAG2482049.1 | 47281 | g9715 | i0 | 50 | 11.6263736263736 | 86 | 41 | 93.4 | 2 | 8 | 262 | 5 | 89 | KAG2482049.1 hypothetical protein HYH03_018999 [Edaphochlamys debaryana] | diamond | 3174 | 83.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 31229506 | 31229506 | PRJNA436017_P_NODE_21995_length_174_cov_1.708029_g21697_i0 | PRJNA436017 | 21995 | 174 | 1.708029 | 2.97197046 | Viridiplantae | 33090 | Plants | Plants | 53.5 | 1.96e-6 | NR | QGN73910.1 | 156113 | g21697 | i0 | 46.4 | 7.70689655172414 | 56 | 30 | 96.6 | 0 | 172 | 5 | 20 | 75 | QGN73910.1 cytochrome c oxidase subunit 3 [prasinophyte sp. MBIC10622] | diamond | 1341 | 53.9 | 0.992578849721707 | Eukaryota | Viridiplantae | Chlorophyta | prasinophyte sp. MBIC10622 | ||||||
| 31655899 | 31655899 | PRJNA436017_P_NODE_4117_length_456_cov_3.040573_g3826_i0 | PRJNA436017 | 4117 | 456 | 3.040573 | 13.86501288 | Monoraphidium neglectum | 145388 | Plants | Plants | 121 | 3.4799999999999993e-31 | NR | XP_013906152.1 | 145388 | g3826 | i0 | 56.6 | 0.894736842105263 | 136 | 51 | 88.8 | 4 | 455 | 51 | 94 | 222 | XP_013906152.1 60S ribosomal protein L6 [Monoraphidium neglectum] | diamond | 408 | 121 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 32162423 | 32162423 | PRJNA436017_P_NODE_28758_length_152_cov_1.356522_g28460_i0 | PRJNA436017 | 28758 | 152 | 1.356522 | 2.06191344 | Pleodorina starrii | 330485 | Plants | Plants | 59.3 | 1.51e-8 | NR | GLC41738.1 | 330485 | g28460 | i0 | 54 | 1.97368421052632 | 50 | 23 | 98.7 | 0 | 2 | 151 | 213 | 262 | GLC41738.1 hypothetical protein PLESTM_001234400 [Pleodorina starrii] | diamond | 300 | 59.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pleodorina | Pleodorina starrii | |
| 32193984 | 32193984 | PRJNA436017_P_NODE_14078_length_222_cov_2.124324_g13780_i0 | PRJNA436017 | 14078 | 222 | 2.124324 | 4.71599928 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 109 | 6.52e-26 | NR | KAK3253051.1 | 36881 | g13780 | i0 | 65.8 | 0.986486486486487 | 73 | 24 | 98.6 | 1 | 220 | 2 | 117 | 188 | KAK3253051.1 hypothetical protein CYMTET_37680 [Cymbomonas tetramitiformis] | diamond | 219 | 109 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 32210398 | 32210398 | PRJNA436017_P_NODE_13698_length_226_cov_1.433862_g13400_i0 | PRJNA436017 | 13698 | 226 | 1.433862 | 3.24052812 | Eukaryota | 2759 | Plants | Plants | 80.1 | 4.85e-17 | NR | CAD7699508.1 | 121088 | g13400 | i0 | 50 | 5.8938053097345096 | 74 | 37 | 98.2 | 0 | 1 | 222 | 67 | 140 | CAD7699508.1 unnamed protein product [Ostreobium quekettii] | diamond | 1332 | 80.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 32793713 | 32793713 | PRJNA436017_P_NODE_23000_length_170_cov_1.466165_g22702_i0 | PRJNA436017 | 23000 | 170 | 1.466165 | 2.4924805 | Chlorochytrium lemnae | 1199099 | Plants | Plants | 87 | 2.31e-20 | NR | CCI69515.1 | 1199099 | g22702 | i0 | 73.2 | 1.97647058823529 | 56 | 15 | 98.8 | 0 | 168 | 1 | 31 | 86 | CCI69515.1 40S ribosomal protein S9, partial [Chlorochytrium lemnae] | diamond | 336 | 87 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlorochytriaceae | Chlorochytrium | Chlorochytrium lemnae | |
| 32825491 | 32825491 | PRJNA436017_P_NODE_13200_length_231_cov_1.608247_g12902_i0 | PRJNA436017 | 13200 | 231 | 1.608247 | 3.71505057 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 65.1 | 4.44e-10 | NR | KAG7671286.1 | 1650286 | g12902 | i0 | 46.8 | 1.98701298701299 | 79 | 40 | 100 | 1 | 231 | 1 | 167 | 245 | KAG7671286.1 hypothetical protein KSW81_003424 [Chlorella desiccata (nom. nud.)] | diamond | 459 | 65.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' |
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);;