contig_metadata
16 rows where bioproject = "PRJNA1108009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2295894 | 2295894 | PRJNA1108009_P_NODE_13662_length_358_cov_1.578947_g13344_i0 | PRJNA1108009 | 13662 | 358 | 1.578947 | 5.65263026 | Eukaryota | 2759 | Plants | Plants | 145 | 2.48e-39 | NR | KAF5836058.1 | 3046 | g13344 | i0 | 60.7 | 15.0418994413408 | 117 | 45 | 97.2 | 1 | 2 | 349 | 193 | 309 | KAF5836058.1 component of cytosolic 80S ribosome and 60S large subunit [Dunaliella salina] | diamond | 5385 | 146 | 0.993150684931507 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 6591208 | 6591208 | PRJNA1108009_P_NODE_27506_length_247_cov_0.885057_g27188_i0 | PRJNA1108009 | 27506 | 247 | 0.885057 | 2.18609079 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 200 | 7.529999999999999e-47 | NTclustered | gi|18250309|gb|AY050666.1| | 3055 | g27188 | i0 | 81.452 | 76.1619433198381 | 248 | 42 | 99 | 4 | 1 | 246 | 566 | 321 | Chlamydomonas reinhardtii eukaryotic release factor 1 mRNA, complete cds | blastn | 18812 | 200 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 11691428 | 11691428 | PRJNA1108009_P_NODE_13130_length_366_cov_1.406143_g12812_i0 | PRJNA1108009 | 13130 | 366 | 1.406143 | 5.14648338 | Haematococcus lacustris | 44745 | Plants | Plants | 385 | 3.02e-102 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g12812 | i0 | 85.637 | 175.03825136612 | 369 | 49 | 100 | 4 | 1 | 366 | 3590 | 3223 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 64064 | 385 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 26878142 | 26878142 | PRJNA1108009_P_NODE_21481_length_276_cov_1.137931_g21163_i0 | PRJNA1108009 | 21481 | 276 | 1.137931 | 3.14068956 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 65.5 | 2.23e-10 | NR | KAF6263477.1 | 2650976 | g21163 | i0 | 51.8 | 0.902173913043478 | 83 | 40 | 90.2 | 0 | 26 | 274 | 5 | 87 | KAF6263477.1 60S ribosomal protein L7 [Scenedesmus sp. NREL 46B-D3] | diamond | 249 | 65.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 27510208 | 27510208 | PRJNA1108009_P_NODE_28143_length_246_cov_0.890173_g27825_i0 | PRJNA1108009 | 28143 | 246 | 0.890173 | 2.18982558 | Tetradesmus obliquus | 3088 | Plants | Plants | 45.4 | 0.00411 | NR | WIA17126.1 | 3088 | g27825 | i0 | 28.4 | 0.902439024390244 | 74 | 53 | 90.2 | 0 | 226 | 5 | 248 | 321 | WIA17126.1 hypothetical protein OEZ85_014019 [Tetradesmus obliquus] | diamond | 222 | 45.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 28488948 | 28488948 | PRJNA1108009_P_NODE_30247_length_243_cov_0.905882_g29929_i0 | PRJNA1108009 | 30247 | 243 | 0.905882 | 2.20129326 | Tetradesmus obliquus | 3088 | Plants | Plants | 92 | 1.54e-19 | NR | WIA12288.1 | 3088 | g29929 | i0 | 53.3 | 3.7037037037037 | 75 | 35 | 92.6 | 0 | 225 | 1 | 269 | 343 | WIA12288.1 hypothetical protein OEZ85_012345 [Tetradesmus obliquus] | diamond | 900 | 92 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 29301161 | 29301161 | PRJNA1108009_P_NODE_11229_length_400_cov_1.397554_g10911_i0 | PRJNA1108009 | 11229 | 400 | 1.397554 | 5.590216 | Eukaryota | 2759 | Plants | Plants | 111 | 1.8e-25 | NR | KAL4856227.1 | 3077 | g10911 | i0 | 63.2 | 5.985 | 133 | 47 | 99.8 | 1 | 400 | 2 | 2034 | 2164 | KAL4856227.1 Guanine nucleotide-binding protein subunit beta-like protein [Chlorella vulgaris] | diamond | 2394 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 29783353 | 29783353 | PRJNA1108009_P_NODE_15331_length_336_cov_1.171103_g15013_i0 | PRJNA1108009 | 15331 | 336 | 1.171103 | 3.93490608 | Raphidocelis subcapitata | 307507 | Plants | Plants | 169 | 2.38e-51 | NR | GBF92135.1 | 307507 | g15013 | i0 | 69.6 | 11.9196428571429 | 112 | 34 | 100 | 0 | 336 | 1 | 33 | 144 | GBF92135.1 40S ribosomal protein S13 [Raphidocelis subcapitata] | diamond | 4005 | 169 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 29964294 | 29964294 | PRJNA1108009_P_NODE_26131_length_249_cov_0.875000_g25813_i0 | PRJNA1108009 | 26131 | 249 | 0.875 | 2.17875 | Chlorophyta | 3041 | Plants | Plants | 75.5 | 1.2e-13 | NR | KAK2080949.1 | 3111 | g25813 | i0 | 52.3 | 5.14457831325301 | 65 | 29 | 75.9 | 1 | 19 | 207 | 202 | 266 | KAK2080949.1 hypothetical protein QBZ16_000803 [Prototheca wickerhamii] | diamond | 1281 | 75.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 30067640 | 30067640 | PRJNA1108009_P_NODE_22312_length_269_cov_1.178571_g21994_i0 | PRJNA1108009 | 22312 | 269 | 1.178571 | 3.17035599 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 117 | 1.8099999999999999e-28 | NR | GMH33391.1 | 3041901 | g21994 | i0 | 84.5 | 1.65055762081784 | 71 | 11 | 79.2 | 0 | 213 | 1 | 7 | 77 | GMH33391.1 hypothetical protein BSKO_01225 [Bryopsis sp. KO-2023] | diamond | 444 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 30572975 | 30572975 | PRJNA1108009_P_NODE_26933_length_248_cov_0.880000_g26615_i0 | PRJNA1108009 | 26933 | 248 | 0.88 | 2.1824 | Astrephomene gubernaculifera | 47775 | Plants | Plants | 54.3 | 1.07e-6 | NR | GFR40709.1 | 47775 | g26615 | i0 | 47.2 | 0.641129032258065 | 53 | 28 | 64.1 | 0 | 159 | 1 | 14 | 66 | GFR40709.1 hypothetical protein Agub_g1315 [Astrephomene gubernaculifera] | diamond | 159 | 54.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 30825955 | 30825955 | PRJNA1108009_P_NODE_17474_length_311_cov_2.512605_g17156_i0 | PRJNA1108009 | 17474 | 311 | 2.512605 | 7.81420155 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 73.2 | 4.42e-14 | NR | CAG9460866.1 | 765719 | g17156 | i0 | 56.4 | 0.752411575562701 | 78 | 31 | 75.2 | 1 | 310 | 77 | 1 | 75 | CAG9460866.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 234 | 73.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 31892281 | 31892281 | PRJNA1108009_P_NODE_19997_length_287_cov_2.345794_g19679_i0 | PRJNA1108009 | 19997 | 287 | 2.345794 | 6.73242878 | root | 1 | Root_unresolved | Root_unresolved | 65.1 | 1.68e-10 | NR | KAG2501458.1 | 47281 | g19679 | i0 | 59.6 | 1.29616724738676 | 47 | 18 | 48.1 | 1 | 176 | 39 | 23 | 69 | KAG2501458.1 hypothetical protein HYH03_001238 [Edaphochlamys debaryana] | diamond | 372 | 65.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 32059168 | 32059168 | PRJNA1108009_P_NODE_22038_length_271_cov_1.510101_g21720_i0 | PRJNA1108009 | 22038 | 271 | 1.510101 | 4.09237371 | Micractinium conductrix | 554055 | Plants | Plants | 49.3 | 2.7e-4 | NR | PSC69994.1 | 554055 | g21720 | i0 | 45.2 | 0.686346863468635 | 62 | 31 | 65.3 | 1 | 95 | 271 | 51 | 112 | PSC69994.1 P-loop nucleoside triphosphate hydrolase superfamily [Micractinium conductrix] | diamond | 186 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 32217479 | 32217479 | PRJNA1108009_P_NODE_22378_length_268_cov_1.846154_g22060_i0 | PRJNA1108009 | 22378 | 268 | 1.846154 | 4.94769272 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 74.3 | 4e-13 | NR | BDA48776.1 | 2315456 | g22060 | i0 | 45 | 3.48134328358209 | 80 | 44 | 89.6 | 0 | 240 | 1 | 817 | 896 | BDA48776.1 probable beta-Ala-His dipeptidase at C-terminar half [Coccomyxa sp. Obi] | diamond | 933 | 74.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 32249422 | 32249422 | PRJNA1108009_P_NODE_10518_length_415_cov_1.576023_g10200_i0 | PRJNA1108009 | 10518 | 415 | 1.576023 | 6.54049545 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 168 | 4.9e-50 | NR | GAX77325.1 | 1157962 | g10200 | i0 | 67.7 | 0.896385542168675 | 124 | 40 | 89.6 | 0 | 414 | 43 | 72 | 195 | GAX77325.1 hypothetical protein CEUSTIGMA_g4771.t1 [Chlamydomonas eustigma] | diamond | 372 | 168 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma |
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);;