contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJEB50332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1393893 | 1393893 | PRJEB50332_P_NODE_5982_length_254_cov_1.658031_g5900_i0 | PRJEB50332 | 5982 | 254 | 1.658031 | 4.21139874 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 85.5 | 3.9e-17 | NR | XP_011397204.1 | 3075 | g5900 | i0 | 48.8 | 6 | 84 | 43 | 99.2 | 0 | 253 | 2 | 937 | 1020 | XP_011397204.1 Eukaryotic translation initiation factor 5B [Auxenochlorella protothecoides] | diamond | 1524 | 85.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 6497739 | 6497739 | PRJEB50332_P_NODE_766_length_609_cov_1.614964_g689_i0 | PRJEB50332 | 766 | 609 | 1.614964 | 9.83513076 | Eukaryota | 2759 | Plants | Plants | 169 | 2.8e-45 | NR | KAK9819769.1 | 41462 | g689 | i0 | 56.3 | 2.5615763546798 | 176 | 65 | 85.7 | 6 | 8 | 529 | 288 | 453 | KAK9819769.1 hypothetical protein WJX72_002177 [[Myrmecia] bisecta] | diamond | 1560 | 169 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 19245067 | 19245067 | PRJEB50332_P_NODE_616_length_693_cov_4.221519_g546_i0 | PRJEB50332 | 616 | 693 | 4.221519 | 29.25512667 | root | 1 | Root_unresolved | Root_unresolved | 227 | 4.39e-71 | NR | XP_011396691.1 | 3075 | g546 | i0 | 53.6 | 10.6796536796537 | 224 | 104 | 97 | 0 | 21 | 692 | 5 | 228 | XP_011396691.1 60S ribosomal protein L7-2 [Auxenochlorella protothecoides] | diamond | 7401 | 229 | 0.991266375545852 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 20520355 | 20520355 | PRJEB50332_P_NODE_1917_length_404_cov_9.428571_g1836_i0 | PRJEB50332 | 1917 | 404 | 9.428571 | 38.09142684 | Trebouxia sp. C | 2796353 | Plants | Plants | 74.3 | 3.43e-14 | NR | KAL0042167.1 | 2905653 | g1836 | i0 | 54 | 1.47772277227723 | 63 | 28 | 46 | 1 | 362 | 177 | 3 | 65 | KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004] | diamond | 597 | 74.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 27279774 | 27279774 | PRJEB50332_P_NODE_7443_length_239_cov_1.455056_g7361_i0 | PRJEB50332 | 7443 | 239 | 1.455056 | 3.47758384 | Volvocaceae | 3065 | Plants | Plants | 102 | 4.65e-24 | NR | KXZ55742.1 | 33097 | g7361 | i0 | 73.5 | 6.75313807531381 | 68 | 18 | 85.4 | 0 | 238 | 35 | 130 | 197 | KXZ55742.1 hypothetical protein GPECTOR_2g1292 [Gonium pectorale] | diamond | 1614 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 27318152 | 27318152 | PRJEB50332_P_NODE_12103_length_213_cov_1.282895_g12021_i0 | PRJEB50332 | 12103 | 213 | 1.282895 | 2.73256635 | Gonium pectorale | 33097 | Plants | Plants | 101 | 6.72e-24 | NR | KXZ42127.1 | 33097 | g12021 | i0 | 71 | 1.94366197183099 | 69 | 20 | 97.2 | 0 | 208 | 2 | 178 | 246 | KXZ42127.1 hypothetical protein GPECTOR_199g355 [Gonium pectorale] | diamond | 414 | 101 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 27349854 | 27349854 | PRJEB50332_P_NODE_8723_length_232_cov_1.163743_g8641_i0 | PRJEB50332 | 8723 | 232 | 1.163743 | 2.69988376 | Chlorella sorokiniana | 3076 | Plants | Plants | 61.2 | 3.48e-9 | NR | PRW58146.1 | 3076 | g8641 | i0 | 47.4 | 0.982758620689655 | 76 | 32 | 98.3 | 2 | 230 | 3 | 78 | 145 | PRW58146.1 histidine triad nucleotide-binding 3 [Chlorella sorokiniana] | diamond | 228 | 61.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 27469355 | 27469355 | PRJEB50332_P_NODE_1543_length_447_cov_2.134715_g1462_i0 | PRJEB50332 | 1543 | 447 | 2.134715 | 9.54217605 | Eukaryota | 2759 | Plants | Plants | 104 | 1.8e-25 | NR | KAI3429597.1 | 3077 | g1462 | i0 | 50.4 | 7.81208053691275 | 131 | 64 | 87.2 | 1 | 23 | 412 | 3 | 133 | KAI3429597.1 hypothetical protein D9Q98_005683 [Chlorella vulgaris] | diamond | 3492 | 105 | 0.990476190476191 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 27949614 | 27949614 | PRJEB50332_P_NODE_4525_length_283_cov_1.171171_g4443_i0 | PRJEB50332 | 4525 | 283 | 1.171171 | 3.31441393 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 88.2 | 6.5e-20 | NR | XP_005645581.1 | 574566 | g4443 | i0 | 76.6 | 2.03533568904594 | 64 | 15 | 67.8 | 0 | 192 | 1 | 73 | 136 | XP_005645581.1 ClpS-like protein, partial [Coccomyxa subellipsoidea C-169] | diamond | 576 | 88.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 28605900 | 28605900 | PRJEB50332_P_NODE_2507_length_359_cov_0.872483_g2425_i0 | PRJEB50332 | 2507 | 359 | 0.872483 | 3.13221397 | Eukaryota | 2759 | Plants | Plants | 159 | 1.3099999999999999e-42 | NR | PRW44958.1 | 3076 | g2425 | i0 | 67.8 | 8.92479108635098 | 118 | 38 | 98.6 | 0 | 359 | 6 | 682 | 799 | PRW44958.1 tyrosine--tRNA ligase cytoplasmic [Chlorella sorokiniana] | diamond | 3204 | 160 | 0.99375 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 28612647 | 28612647 | PRJEB50332_P_NODE_8547_length_233_cov_1.261628_g8465_i0 | PRJEB50332 | 8547 | 233 | 1.261628 | 2.93959324 | Symbiochloris irregularis | 706552 | Plants | Plants | 45.1 | 0.00492 | NR | KAK9794941.1 | 706552 | g8465 | i0 | 39.7 | 1.5450643776824 | 58 | 30 | 73.4 | 2 | 2 | 172 | 49 | 102 | KAK9794941.1 hypothetical protein WJX73_003217 [Symbiochloris irregularis] | diamond | 360 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 29174375 | 29174375 | PRJEB50332_P_NODE_3829_length_302_cov_0.917012_g3747_i0 | PRJEB50332 | 3829 | 302 | 0.917012 | 2.76937624 | root | 1 | Root_unresolved | Root_unresolved | 127 | 4.98e-32 | NR | KXZ48195.1 | 33097 | g3747 | i0 | 58.2 | 5.82119205298013 | 98 | 41 | 97.4 | 0 | 294 | 1 | 270 | 367 | KXZ48195.1 hypothetical protein GPECTOR_29g102 [Gonium pectorale] | diamond | 1758 | 127 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 29237500 | 29237500 | PRJEB50332_P_NODE_14889_length_207_cov_0.890411_g14807_i0 | PRJEB50332 | 14889 | 207 | 0.890411 | 1.84315077 | Picochlorum | 249344 | Plants | Plants | 148 | 1.91e-39 | NR | WPT16125.1 | 1470871 | g14807 | i0 | 97.1 | 1.97101449275362 | 68 | 2 | 98.6 | 0 | 2 | 205 | 977 | 1044 | WPT16125.1 Putative formate transporter [Picochlorum sp. SENEW3] | diamond | 408 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. SENEW3 | |||
| 30159676 | 30159676 | PRJEB50332_P_NODE_14652_length_207_cov_1.458904_g14570_i0 | PRJEB50332 | 14652 | 207 | 1.458904 | 3.01993128 | [Myrmecia] bisecta | 41462 | Plants | Plants | 60.1 | 1.78e-8 | NR | KAK9812620.1 | 41462 | g14570 | i0 | 51.7 | 0.840579710144927 | 58 | 28 | 84.1 | 0 | 197 | 24 | 398 | 455 | KAK9812620.1 hypothetical protein WJX72_000751 [[Myrmecia] bisecta] | diamond | 174 | 60.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 30279999 | 30279999 | PRJEB50332_P_NODE_11412_length_217_cov_0.910256_g11330_i0 | PRJEB50332 | 11412 | 217 | 0.910256 | 1.97525552 | Chlorophyta | 3041 | Plants | Plants | 124 | 7.22e-31 | NR | XP_002949227.1 | 3068 | g11330 | i0 | 75 | 42.7465437788018 | 72 | 18 | 99.5 | 0 | 216 | 1 | 1269 | 1340 | XP_002949227.1 uncharacterized protein VOLCADRAFT_104170 [Volvox carteri f. nagariensis] | diamond | 9276 | 125 | 0.992 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 30570401 | 30570401 | PRJEB50332_P_NODE_18413_length_192_cov_2.473282_g18331_i0 | PRJEB50332 | 18413 | 192 | 2.473282 | 4.74870144 | Raphidocelis subcapitata | 307507 | Plants | Plants | 79.7 | 1.71e-15 | NR | GBF90904.1 | 307507 | g18331 | i0 | 61.9 | 3.84375 | 63 | 23 | 98.4 | 1 | 2 | 190 | 71 | 132 | GBF90904.1 aldehyde dehydrogenase [Raphidocelis subcapitata] | diamond | 738 | 79.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 31132349 | 31132349 | PRJEB50332_P_NODE_675_length_657_cov_1.887584_g601_i0 | PRJEB50332 | 675 | 657 | 1.887584 | 12.40142688 | Eukaryota | 2759 | Plants | Plants | 315 | 5.02e-105 | NR | BAC57979.1 | 3055 | g601 | i0 | 67.7 | 161.680365296804 | 220 | 70 | 100 | 1 | 657 | 1 | 34 | 253 | BAC57979.1 casein kinase I, partial [Chlamydomonas reinhardtii] | diamond | 106224 | 318 | 0.990566037735849 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 31259108 | 31259108 | PRJEB50332_P_NODE_16475_length_204_cov_1.433566_g16393_i0 | PRJEB50332 | 16475 | 204 | 1.433566 | 2.92447464 | Coccomyxa | 41891 | Plants | Plants | 72.4 | 4.36e-13 | NR | KAK9917142.1 | 248742 | g16393 | i0 | 54.1 | 2.69117647058824 | 61 | 21 | 89.7 | 2 | 15 | 197 | 200 | 253 | KAK9917142.1 hypothetical protein WJX75_001261 [Coccomyxa subellipsoidea] | diamond | 549 | 72.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 31607044 | 31607044 | PRJEB50332_P_NODE_836_length_585_cov_1.988550_g758_i0 | PRJEB50332 | 836 | 585 | 1.98855 | 11.6330175 | Volvocaceae | 3065 | Plants | Plants | 76.3 | 2.16e-12 | NR | KXZ53948.1 | 33097 | g758 | i0 | 31.7 | 5.56923076923077 | 183 | 110 | 89.7 | 6 | 533 | 9 | 2 | 177 | KXZ53948.1 hypothetical protein GPECTOR_6g866 [Gonium pectorale] | diamond | 3258 | 76.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 32625773 | 32625773 | PRJEB50332_P_NODE_760_length_611_cov_1.274545_g683_i0 | PRJEB50332 | 760 | 611 | 1.274545 | 7.78746995 | Chlorella ohadii | 2649997 | Plants | Plants | 48.5 | 0.00741 | NR | KAI7842820.1 | 2649997 | g683 | i0 | 48.7 | 0.191489361702128 | 39 | 20 | 19.1 | 0 | 2 | 118 | 239 | 277 | KAI7842820.1 hypothetical protein COHA_003566 [Chlorella ohadii] | diamond | 117 | 48.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella ohadii |
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);;