contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1086823" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14222349 | 14222349 | PRJNA1086823_P_NODE_1152_length_705_cov_3.550633_g1042_i0 | PRJNA1086823 | 1152 | 705 | 3.550633 | 25.03196265 | root | 1 | Root_unresolved | Root_unresolved | 229 | 6.259999999999999e-72 | NR | XP_011396691.1 | 3075 | g1042 | i0 | 53.8 | 14.3914893617021 | 225 | 104 | 95.7 | 0 | 24 | 698 | 5 | 229 | XP_011396691.1 60S ribosomal protein L7-2 [Auxenochlorella protothecoides] | diamond | 10146 | 231 | 0.991341991341991 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 15496393 | 15496393 | PRJNA1086823_P_NODE_15933_length_247_cov_0.896552_g15816_i0 | PRJNA1086823 | 15933 | 247 | 0.896552 | 2.21448344 | Chlorella sorokiniana | 3076 | Plants | Plants | 149 | 1.21e-44 | NR | PRW57670.1 | 3076 | g15816 | i0 | 90 | 1.94331983805668 | 80 | 8 | 97.2 | 0 | 240 | 1 | 1 | 80 | PRW57670.1 Cytochrome c [Chlorella sorokiniana] | diamond | 480 | 149 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 15496449 | 15496449 | PRJNA1086823_P_NODE_19013_length_242_cov_0.923077_g18896_i0 | PRJNA1086823 | 19013 | 242 | 0.923077 | 2.23384634 | root | 1 | Root_unresolved | Root_unresolved | 124 | 3.969999999999999e-31 | NR | YP_008816117.1 | 163317 | g18896 | i0 | 78.2 | 7.8099173553719 | 78 | 17 | 96.7 | 0 | 242 | 9 | 118 | 195 | YP_008816117.1 ATP synthase F1 subunit alpha [Microspora stagnorum] | diamond | 1890 | 125 | 0.992 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Microsporaceae | Microspora | Microspora stagnorum | ||
| 24419707 | 24419707 | PRJNA1086823_P_NODE_4300_length_377_cov_5.559211_g4183_i0 | PRJNA1086823 | 4300 | 377 | 5.559211 | 20.95822547 | Trebouxia sp. C | 2796353 | Plants | Plants | 73.6 | 5.14e-14 | NR | KAL0042167.1 | 2905653 | g4183 | i0 | 55.7 | 1.56763925729443 | 61 | 26 | 47.7 | 1 | 331 | 152 | 5 | 65 | KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004] | diamond | 591 | 73.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 27794197 | 27794197 | PRJNA1086823_P_NODE_2824_length_454_cov_4.065617_g2707_i0 | PRJNA1086823 | 2824 | 454 | 4.065617 | 18.45790118 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 102 | 1.11e-24 | NR | CAG9460866.1 | 765719 | g2707 | i0 | 46.8 | 0.931718061674009 | 141 | 56 | 93.2 | 2 | 453 | 31 | 1 | 122 | CAG9460866.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 423 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 27943454 | 27943454 | PRJNA1086823_P_NODE_15505_length_248_cov_0.891429_g15388_i0 | PRJNA1086823 | 15505 | 248 | 0.891429 | 2.21074392 | Viridiplantae | 33090 | Plants | Plants | 96.3 | 1.2499999999999999e-23 | NR | KAK2076791.1 | 3111 | g15388 | i0 | 66.7 | 3.25403225806452 | 63 | 21 | 76.2 | 0 | 193 | 5 | 8 | 70 | KAK2076791.1 iso-1-cytochrome c [Prototheca wickerhamii] | diamond | 807 | 97.1 | 0.991761071060762 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 30352411 | 30352411 | PRJNA1086823_P_NODE_11872_length_254_cov_1.707182_g11755_i0 | PRJNA1086823 | 11872 | 254 | 1.707182 | 4.33624228 | Chlamydomonas schloesseri | 2026947 | Plants | Plants | 129 | 1.09e-32 | NR | KAG2427717.1 | 2026947 | g11755 | i0 | 72.6 | 2.97637795275591 | 84 | 23 | 99.2 | 0 | 252 | 1 | 418 | 501 | KAG2427717.1 hypothetical protein HYH02_014548 [Chlamydomonas schloesseri] | diamond | 756 | 129 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas schloesseri | |
| 30415421 | 30415421 | PRJNA1086823_P_NODE_6813_length_314_cov_0.970954_g6696_i0 | PRJNA1086823 | 6813 | 314 | 0.970954 | 3.04879556 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 48.9 | 1.22e-4 | NR | 7AR9_T | 37502 | g6696 | i0 | 41.8 | 1.67197452229299 | 67 | 34 | 64 | 2 | 112 | 312 | 32 | 93 | 7AR9_T Chain T, SDAP1 [Polytomella sp. Pringsheim 198.80] | diamond | 525 | 48.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 31015368 | 31015368 | PRJNA1086823_P_NODE_16855_length_245_cov_1.802326_g16738_i0 | PRJNA1086823 | 16855 | 245 | 1.802326 | 4.4156987 | Trebouxia sp. C | 2796353 | Plants | Plants | 111 | 6.14e-28 | NR | KAL3159256.1 | 3373145 | g16738 | i0 | 66.3 | 0.979591836734694 | 80 | 27 | 98 | 0 | 2 | 241 | 168 | 247 | KAL3159256.1 hypothetical protein ABBQ32_011222 [Trebouxia sp. C0010 RCD-2024] | diamond | 240 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0010 RCD-2024 | |
| 31101455 | 31101455 | PRJNA1086823_P_NODE_9555_length_277_cov_1.210784_g9438_i0 | PRJNA1086823 | 9555 | 277 | 1.210784 | 3.35387168 | Chlamydomonas | 3052 | Plants | Plants | 72.8 | 1.54e-12 | NR | GAX82928.1 | 1157962 | g9438 | i0 | 48.9 | 4.4187725631769 | 92 | 31 | 99.6 | 4 | 277 | 2 | 17 | 92 | GAX82928.1 hypothetical protein CEUSTIGMA_g10355.t1 [Chlamydomonas eustigma] | diamond | 1224 | 72.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 31670762 | 31670762 | PRJNA1086823_P_NODE_15917_length_247_cov_0.896552_g15800_i0 | PRJNA1086823 | 15917 | 247 | 0.896552 | 2.21448344 | Chlorophyta | 3041 | Plants | Plants | 55.1 | 1.78e-6 | NR | PSC69832.1 | 554055 | g15800 | i0 | 35.5 | 5.61133603238866 | 76 | 49 | 92.3 | 0 | 241 | 14 | 1 | 76 | PSC69832.1 proteasome maturation factor UMP1 family [Micractinium conductrix] | diamond | 1386 | 55.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix |
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);;