contig_metadata
19 rows where bioproject = "PRJNA801875", tax_clade = "core chlorophytes" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12280556 | 12280556 | PRJNA801875_P_NODE_3450_length_177_cov_1.105634_g3347_i0 | PRJNA801875 | 3450 | 177 | 1.105634 | 1.95697218 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 58.2 | 5.51e-8 | NR | KAA6427849.1 | 2608996 | g3347 | i0 | 50.9 | 0.966101694915254 | 57 | 28 | 96.6 | 0 | 173 | 3 | 993 | 1049 | KAA6427849.1 MAG: elongation factor 3 [Trebouxia sp. A1-2] | diamond | 171 | 58.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 12701287 | 12701287 | PRJNA801875_P_NODE_1070_length_393_cov_3.301676_g967_i0 | PRJNA801875 | 1070 | 393 | 3.301676 | 12.97558668 | Chlorophyta | 3041 | Plants | Plants | 176 | 1.19e-48 | NR | QKY14930.1 | 51329 | g967 | i0 | 84.3 | 6.42748091603053 | 102 | 15 | 77.9 | 1 | 390 | 85 | 112 | 212 | QKY14930.1 heat shock protein 90c (HS90) [Polytomella parva] | diamond | 2526 | 177 | 0.994350282485876 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 13554702 | 13554702 | PRJNA801875_P_NODE_3191_length_185_cov_1.513333_g3088_i0 | PRJNA801875 | 3191 | 185 | 1.513333 | 2.79966605 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 337 | 3.89e-88 | NTclustered | gi|570364818|gb|KC843975.1| | 3075 | g3088 | i0 | 100 | 70.2432432432432 | 182 | 0 | 98 | 0 | 1 | 182 | 37211 | 37392 | Auxenochlorella protothecoides chloroplast, complete genome | blastn | 12995 | 337 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 18652567 | 18652567 | PRJNA801875_P_NODE_4535_length_153_cov_52.627119_g4432_i0 | PRJNA801875 | 4535 | 153 | 52.627119 | 80.51949207 | Chlamydomonas sp. TK-1983 | 3056 | Plants | Plants | 219 | 1.1699999999999999e-52 | NTclustered | gi|174203|gb|K02345.1|CRERRA | 3056 | g4432 | i0 | 100 | 1 | 118 | 0 | 100 | 0 | 1 | 118 | 1 | 118 | Chlamydomonas sp. TK-1983 5S ribosomal RNA gene, complete sequence | blastn | 153 | 219 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. TK-1983 | |
| 21203454 | 21203454 | PRJNA801875_P_NODE_2897_length_197_cov_1.413580_g2794_i0 | PRJNA801875 | 2897 | 197 | 1.41358 | 2.7847526 | Eukaryota | 2759 | Plants | Plants | 129 | 1.39e-34 | NR | XP_011395856.1 | 3075 | g2794 | i0 | 89.2 | 117.791878172589 | 65 | 7 | 99 | 0 | 196 | 2 | 74 | 138 | XP_011395856.1 Serine/threonine-protein phosphatase PP2A-2 catalytic subunit [Auxenochlorella protothecoides] | diamond | 23205 | 130 | 0.992307692307692 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 25027580 | 25027580 | PRJNA801875_P_NODE_1640_length_297_cov_1.561069_g1537_i0 | PRJNA801875 | 1640 | 297 | 1.561069 | 4.63637493 | Chaetomorpha valida | 1213231 | Plants | Plants | 180 | 4.16e-51 | NR | AIJ27588.1 | 1213231 | g1537 | i0 | 90.8 | 16.8181818181818 | 98 | 9 | 99 | 0 | 2 | 295 | 454 | 551 | AIJ27588.1 heat shock protein 70 [Chaetomorpha valida] | diamond | 4995 | 180 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Cladophoraceae | Chaetomorpha | Chaetomorpha valida | |
| 25027590 | 25027590 | PRJNA801875_P_NODE_2380_length_226_cov_1.780105_g2277_i0 | PRJNA801875 | 2380 | 226 | 1.780105 | 4.0230373 | Koliella corcontica | 155904 | Plants | Plants | 89.8 | 1.53e-13 | NTclustered | gi|2724824266|gb|PP746555.1| | 155904 | g2277 | i0 | 77.632 | 44.2212389380531 | 152 | 31 | 66 | 3 | 77 | 226 | 3503 | 3653 | Koliella corcontica culture SAG:24.84 mitochondrion, complete genome | blastn | 9994 | 89.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella corcontica | |
| 27843684 | 27843684 | PRJNA801875_P_NODE_3024_length_192_cov_1.235669_g2921_i0 | PRJNA801875 | 3024 | 192 | 1.235669 | 2.37248448 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 83.6 | 1.67e-17 | NR | KAG7670504.1 | 1650286 | g2921 | i0 | 68.9 | 4.734375 | 61 | 18 | 95.3 | 1 | 185 | 3 | 52 | 111 | KAG7670504.1 hypothetical protein KSW81_003066 [Chlorella desiccata (nom. nud.)] | diamond | 909 | 83.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 28294697 | 28294697 | PRJNA801875_P_NODE_1446_length_323_cov_1.364583_g1343_i0 | PRJNA801875 | 1446 | 323 | 1.364583 | 4.40760309 | Eukaryota | 2759 | Plants | Plants | 118 | 3.299999999999999e-29 | NR | KAK9814193.1 | 41462 | g1343 | i0 | 65.1 | 24.4458204334365 | 83 | 28 | 77.1 | 1 | 300 | 52 | 315 | 396 | KAK9814193.1 hypothetical protein WJX72_001995 [[Myrmecia] bisecta] | diamond | 7896 | 119 | 0.991596638655462 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 28443928 | 28443928 | PRJNA801875_P_NODE_3206_length_184_cov_2.503356_g3103_i0 | PRJNA801875 | 3206 | 184 | 2.503356 | 4.60617504 | Ostreobium quekettii | 121088 | Plants | Plants | 67.8 | 2.67e-12 | NR | CAD7697746.1 | 121088 | g3103 | i0 | 60 | 1.72826086956522 | 55 | 22 | 89.7 | 0 | 182 | 18 | 67 | 121 | CAD7697746.1 unnamed protein product [Ostreobium quekettii] | diamond | 318 | 67.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 29201665 | 29201665 | PRJNA801875_P_NODE_1009_length_410_cov_3.965333_g906_i0 | PRJNA801875 | 1009 | 410 | 3.965333 | 16.2578653 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 219 | 6.51e-69 | NR | GAX80767.1 | 1157962 | g906 | i0 | 77.4 | 0.973170731707317 | 133 | 29 | 97.3 | 1 | 399 | 1 | 75 | 206 | GAX80767.1 hypothetical protein CEUSTIGMA_g8202.t1 [Chlamydomonas eustigma] | diamond | 399 | 219 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 29526222 | 29526222 | PRJNA801875_P_NODE_2170_length_241_cov_1.597087_g2067_i0 | PRJNA801875 | 2170 | 241 | 1.597087 | 3.84897967 | Eukaryota | 2759 | Plants | Plants | 74.3 | 1.15e-13 | NR | GAX80767.1 | 1157962 | g2067 | i0 | 67.9 | 2.02904564315353 | 53 | 17 | 66 | 0 | 23 | 181 | 7 | 59 | GAX80767.1 hypothetical protein CEUSTIGMA_g8202.t1 [Chlamydomonas eustigma] | diamond | 489 | 74.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 29526223 | 29526223 | PRJNA801875_P_NODE_330_length_794_cov_13.455863_g241_i1 | PRJNA801875 | 330 | 794 | 13.455863 | 106.83955222 | Eukaryota | 2759 | Plants | Plants | 128 | 1.98e-32 | NR | XP_013899290.1 | 145388 | g241 | i1 | 45.8 | 1.08816120906801 | 155 | 71 | 53.7 | 2 | 471 | 46 | 38 | 192 | XP_013899290.1 hypothetical protein MNEG_7690 [Monoraphidium neglectum] | diamond | 864 | 129 | 0.992248062015504 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 31096689 | 31096689 | PRJNA801875_P_NODE_875_length_447_cov_2.589806_g773_i0 | PRJNA801875 | 875 | 447 | 2.589806 | 11.57643282 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 52 | 1.9e-4 | NR | CAG9465426.1 | 765719 | g773 | i0 | 30.6 | 1.2751677852349 | 108 | 72 | 70.5 | 1 | 46 | 360 | 27 | 134 | CAG9465426.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 570 | 52 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 31349837 | 31349837 | PRJNA801875_P_NODE_4436_length_155_cov_1.600000_g4333_i0 | PRJNA801875 | 4436 | 155 | 1.6 | 2.48 | Haematococcus lacustris | 44745 | Plants | Plants | 44.3 | 0.00325 | NR | KAJ9512917.1 | 44745 | g4333 | i0 | 64.5 | 1.2 | 31 | 11 | 60 | 0 | 102 | 10 | 245 | 275 | KAJ9512917.1 hypothetical protein QJQ45_029067 [Haematococcus lacustris] | diamond | 186 | 44.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 31864475 | 31864475 | PRJNA801875_P_NODE_2357_length_227_cov_2.192708_g2254_i0 | PRJNA801875 | 2357 | 227 | 2.192708 | 4.97744716 | Chlorophyceae | 3166 | Plants | Plants | 135 | 3.27e-38 | NR | WIA33580.1 | 3088 | g2254 | i0 | 86.5 | 3.91189427312775 | 74 | 10 | 97.8 | 0 | 224 | 3 | 58 | 131 | WIA33580.1 hypothetical protein OEZ86_006704 [Tetradesmus obliquus] | diamond | 888 | 135 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 32086164 | 32086164 | PRJNA801875_P_NODE_4498_length_154_cov_1.529412_g4395_i0 | PRJNA801875 | 4498 | 154 | 1.529412 | 2.35529448 | Eukaryota | 2759 | Plants | Plants | 90.9 | 2.82e-20 | NR | KAG2423815.1 | 51695 | g4395 | i0 | 84 | 23.2012987012987 | 50 | 8 | 97.4 | 0 | 152 | 3 | 222 | 271 | KAG2423815.1 hypothetical protein HXX76_014975 [Chlamydomonas incerta] | diamond | 3573 | 91.7 | 0.991275899672846 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 32149540 | 32149540 | PRJNA801875_P_NODE_2878_length_198_cov_1.165644_g2775_i0 | PRJNA801875 | 2878 | 198 | 1.165644 | 2.30797512 | Trebouxiaceae | 2507902 | Plants | Plants | 74.7 | 9.42e-14 | NR | KAK9808868.1 | 41462 | g2775 | i0 | 56.1 | 5.98484848484848 | 66 | 28 | 98.5 | 1 | 195 | 1 | 184 | 249 | KAK9808868.1 hypothetical protein WJX72_005476 [[Myrmecia] bisecta] | diamond | 1185 | 74.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 32497681 | 32497681 | PRJNA801875_P_NODE_2579_length_212_cov_2.214689_g2476_i0 | PRJNA801875 | 2579 | 212 | 2.214689 | 4.69514068 | Eukaryota | 2759 | Plants | Plants | 63.2 | 5.53e-11 | NR | KXZ41826.1 | 33097 | g2476 | i0 | 78.4 | 2.05188679245283 | 37 | 8 | 52.4 | 0 | 3 | 113 | 58 | 94 | KXZ41826.1 hypothetical protein GPECTOR_270g700 [Gonium pectorale] | diamond | 435 | 63.5 | 0.995275590551181 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale |
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);;