contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA841653" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2105886 | 2105886 | PRJNA841653_P_NODE_31542_length_290_cov_1.410138_g30868_i0 | PRJNA841653 | 31542 | 290 | 1.410138 | 4.0894002 | Chloroidium sp. KL-2 | 2812591 | Plants | Plants | 167 | 1.55e-45 | NR | WDY12850.1 | 3031248 | g30868 | i0 | 89.4 | 0.972413793103448 | 94 | 10 | 97.2 | 0 | 5 | 286 | 410 | 503 | WDY12850.1 RNA polymerase beta'' subunit [Chloroidium sp. KL-2023a] | diamond | 282 | 167 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. KL-2023a | |
| 4658674 | 4658674 | PRJNA841653_P_NODE_23804_length_334_cov_1.057471_g23130_i0 | PRJNA841653 | 23804 | 334 | 1.057471 | 3.53195314 | Symbiochloris irregularis | 706552 | Plants | Plants | 162 | 2.08e-49 | NR | KAK9801411.1 | 706552 | g23130 | i0 | 80.6 | 1.8502994011976 | 103 | 20 | 92.5 | 0 | 8 | 316 | 14 | 116 | KAK9801411.1 hypothetical protein WJX73_008269 [Symbiochloris irregularis] | diamond | 618 | 162 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 12710243 | 12710243 | PRJNA841653_P_NODE_22830_length_341_cov_1.522388_g22156_i0 | PRJNA841653 | 22830 | 341 | 1.522388 | 5.19134308 | root | 1 | Root_unresolved | Root_unresolved | 135 | 1.27e-38 | NR | 8A22_Bl | 353565 | g22156 | i0 | 65.7 | 7.91788856304985 | 99 | 34 | 87.1 | 0 | 299 | 3 | 15 | 113 | 8A22_Bl Chain Bl, uS12m [Polytomella magna] | diamond | 2700 | 135 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella magna | |
| 12710380 | 12710380 | PRJNA841653_P_NODE_34910_length_278_cov_1.282927_g34236_i0 | PRJNA841653 | 34910 | 278 | 1.282927 | 3.56653706 | Eukaryota | 2759 | Plants | Plants | 129 | 2.9499999999999997e-32 | NR | PRW20811.1 | 3076 | g34236 | i0 | 72.8 | 5.25539568345324 | 81 | 19 | 84.2 | 1 | 277 | 44 | 236 | 316 | PRW20811.1 Receptor of activated kinase C component of 40S small ribosomal subunit isoform C [Chlorella sorokiniana] | diamond | 1461 | 129 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 19956475 | 19956475 | PRJNA841653_P_NODE_13796_length_444_cov_1.110512_g13125_i0 | PRJNA841653 | 13796 | 444 | 1.110512 | 4.93067328 | Chlamydomonadales | 3042 | Plants | Plants | 228 | 9.3e-72 | NR | KAJ9532284.1 | 44745 | g13125 | i0 | 75 | 6.81081081081081 | 144 | 36 | 97.3 | 0 | 432 | 1 | 127 | 270 | KAJ9532284.1 hypothetical protein QJQ45_010414 [Haematococcus lacustris] | diamond | 3024 | 228 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 27907293 | 27907293 | PRJNA841653_P_NODE_62225_length_241_cov_0.916667_g61551_i0 | PRJNA841653 | 62225 | 241 | 0.916667 | 2.20916747 | Trebouxia sp. C | 2796353 | Plants | Plants | 53.1 | 4.59e-6 | NR | KAL0037844.1 | 2905654 | g61551 | i0 | 60 | 1.71784232365145 | 45 | 18 | 56 | 0 | 140 | 6 | 146 | 190 | KAL0037844.1 hypothetical protein WJX79_001616 [Trebouxia sp. C0005] | diamond | 414 | 53.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0005 | |
| 28286208 | 28286208 | PRJNA841653_P_NODE_36926_length_271_cov_1.212121_g36252_i0 | PRJNA841653 | 36926 | 271 | 1.212121 | 3.28484791 | Micractinium conductrix | 554055 | Plants | Plants | 89 | 2.73e-18 | NR | PSC69391.1 | 554055 | g36252 | i0 | 76.3 | 0.653136531365314 | 59 | 7 | 57.6 | 1 | 270 | 115 | 388 | 446 | PSC69391.1 ferrochelatase-chloroplastic [Micractinium conductrix] | diamond | 177 | 89 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 28421400 | 28421400 | PRJNA841653_P_NODE_46946_length_249_cov_0.875000_g46272_i0 | PRJNA841653 | 46946 | 249 | 0.875 | 2.17875 | Trebouxia | 13786 | Plants | Plants | 83.2 | 5.71e-17 | NR | KAL3142158.1 | 3373144 | g46272 | i0 | 48.8 | 2.8433734939759 | 82 | 42 | 98.8 | 0 | 4 | 249 | 38 | 119 | KAL3142158.1 hypothetical protein ABBQ38_002516 [Trebouxia sp. C0009 RCD-2024] | diamond | 708 | 84 | 0.990476190476191 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0009 RCD-2024 | |
| 28831549 | 28831549 | PRJNA841653_P_NODE_18188_length_383_cov_1.654839_g17516_i0 | PRJNA841653 | 18188 | 383 | 1.654839 | 6.33803337 | Chlamydomonas | 3052 | Plants | Plants | 147 | 5.3e-40 | NR | BAA78600.1 | 108458 | g17516 | i0 | 59.1 | 4.57441253263708 | 115 | 47 | 90.1 | 0 | 12 | 356 | 189 | 303 | BAA78600.1 60S ribosomal protein L4 [Chlamydomonas sp. HS-5] | diamond | 1752 | 147 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. HS-5 | |
| 29084349 | 29084349 | PRJNA841653_P_NODE_32708_length_286_cov_1.070423_g32034_i0 | PRJNA841653 | 32708 | 286 | 1.070423 | 3.06140978 | Eukaryota | 2759 | Plants | Plants | 115 | 2.31e-27 | NR | PSC71066.1 | 554055 | g32034 | i0 | 57.3 | 2.8006993006993 | 89 | 38 | 93.4 | 0 | 18 | 284 | 6 | 94 | PSC71066.1 argonaute 1 isoform A [Micractinium conductrix] | diamond | 801 | 115 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 29715427 | 29715427 | PRJNA841653_P_NODE_24830_length_327_cov_2.212598_g24156_i0 | PRJNA841653 | 24830 | 327 | 2.212598 | 7.23519546 | Chlorellaceae | 35461 | Plants | Plants | 75.1 | 3.42e-14 | NR | KAH7617709.1 | 1650286 | g24156 | i0 | 46.2 | 5.96330275229358 | 78 | 42 | 71.6 | 0 | 3 | 236 | 58 | 135 | KAH7617709.1 putative 60S ribosomal protein L18a-2 [Chlorella desiccata (nom. nud.)] | diamond | 1950 | 75.5 | 0.994701986754967 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 29959901 | 29959901 | PRJNA841653_P_NODE_59451_length_242_cov_0.911243_g58777_i0 | PRJNA841653 | 59451 | 242 | 0.911243 | 2.20520806 | [Myrmecia] bisecta | 41462 | Plants | Plants | 64.3 | 9.15e-10 | NR | KAK9817180.1 | 41462 | g58777 | i0 | 51.4 | 0.867768595041322 | 70 | 30 | 86.8 | 1 | 33 | 242 | 464 | 529 | KAK9817180.1 hypothetical protein WJX72_010713 [[Myrmecia] bisecta] | diamond | 210 | 64.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 30276163 | 30276163 | PRJNA841653_P_NODE_43892_length_251_cov_0.865169_g43218_i0 | PRJNA841653 | 43892 | 251 | 0.865169 | 2.17157419 | Chlorella ohadii | 2649997 | Plants | Plants | 82.4 | 4.5e-16 | NR | KAI7839435.1 | 2649997 | g43218 | i0 | 90 | 1.43426294820717 | 40 | 4 | 47.8 | 0 | 245 | 126 | 88 | 127 | KAI7839435.1 hypothetical protein COHA_006836 [Chlorella ohadii] | diamond | 360 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella ohadii | |
| 30411046 | 30411046 | PRJNA841653_P_NODE_27173_length_313_cov_1.079167_g26499_i0 | PRJNA841653 | 27173 | 313 | 1.079167 | 3.37779271 | Eukaryota | 2759 | Plants | Plants | 109 | 1.22e-25 | NR | KDD74633.1 | 1291522 | g26499 | i0 | 59 | 8.70287539936102 | 100 | 39 | 95.8 | 2 | 301 | 2 | 52 | 149 | KDD74633.1 pyridine nucleotide-disulfide oxidoreductase, partial [Helicosporidium sp. ATCC 50920] | diamond | 2724 | 109 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ATCC 50920 | |
| 31255338 | 31255338 | PRJNA841653_P_NODE_25155_length_325_cov_1.797619_g24481_i0 | PRJNA841653 | 25155 | 325 | 1.797619 | 5.84226175 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 79.3 | 1.97e-16 | NR | CAG9460866.1 | 765719 | g24481 | i0 | 45.8 | 6.79384615384615 | 107 | 42 | 98.8 | 1 | 3 | 323 | 11 | 101 | CAG9460866.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 2208 | 79.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 31706666 | 31706666 | PRJNA841653_P_NODE_54377_length_245_cov_0.895349_g53703_i0 | PRJNA841653 | 54377 | 245 | 0.895349 | 2.19360505 | Trebouxiaceae | 2507902 | Plants | Plants | 140 | 5.98e-40 | NR | KAK9810116.1 | 41462 | g53703 | i0 | 82.7 | 4.95918367346939 | 81 | 14 | 99.2 | 0 | 2 | 244 | 60 | 140 | KAK9810116.1 hypothetical protein WJX72_005055 [[Myrmecia] bisecta] | diamond | 1215 | 140 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 32362842 | 32362842 | PRJNA841653_P_NODE_56739_length_244_cov_0.900585_g56065_i0 | PRJNA841653 | 56739 | 244 | 0.900585 | 2.1974274 | Symbiochloris irregularis | 706552 | Plants | Plants | 99.8 | 3.44e-22 | NR | KAK9797001.1 | 706552 | g56065 | i0 | 56.6 | 0.934426229508197 | 76 | 33 | 93.4 | 0 | 16 | 243 | 1601 | 1676 | KAK9797001.1 hypothetical protein WJX73_002827 [Symbiochloris irregularis] | diamond | 228 | 99.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 32371224 | 32371224 | PRJNA841653_P_NODE_39919_length_261_cov_1.436170_g39245_i0 | PRJNA841653 | 39919 | 261 | 1.43617 | 3.7484037 | Chlorophyta | 3041 | Plants | Plants | 78.6 | 9.25e-16 | NR | KAK9818416.1 | 41462 | g39245 | i0 | 64.2 | 3.1264367816092 | 67 | 22 | 77 | 2 | 60 | 260 | 2 | 66 | KAK9818416.1 hypothetical protein WJX72_012350 [[Myrmecia] bisecta] | diamond | 816 | 78.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 32709863 | 32709863 | PRJNA841653_P_NODE_56180_length_244_cov_0.900585_g55506_i0 | PRJNA841653 | 56180 | 244 | 0.900585 | 2.1974274 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 74.7 | 9.09e-15 | NR | KAF6256299.1 | 2650976 | g55506 | i0 | 62.5 | 0.688524590163934 | 56 | 21 | 68.9 | 0 | 10 | 177 | 92 | 147 | KAF6256299.1 hypothetical protein COO60DRAFT_1296234 [Scenedesmus sp. NREL 46B-D3] | diamond | 168 | 74.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 |
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);;