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