contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1242190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4178111 | 4178111 | PRJNA1242190_S_NODE_3684_length_414_cov_6.932551_g3677_i0 | PRJNA1242190 | 3684 | 414 | 6.932551 | 28.70076114 | Trebouxia sp. C | 2796353 | Plants | Plants | 73.6 | 7.52e-14 | NR | KAL0042167.1 | 2905653 | g3677 | i0 | 55.7 | 1.42753623188406 | 61 | 26 | 43.5 | 1 | 45 | 224 | 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 | |
| 4879128 | 4879128 | PRJNA1242190_S_NODE_1904_length_513_cov_3.086364_g1897_i0 | PRJNA1242190 | 1904 | 513 | 3.086364 | 15.83304732 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 158 | 1.47e-45 | NR | GAX77325.1 | 1157962 | g1897 | i0 | 70.6 | 0.637426900584795 | 109 | 32 | 63.7 | 0 | 61 | 387 | 96 | 204 | GAX77325.1 hypothetical protein CEUSTIGMA_g4771.t1 [Chlamydomonas eustigma] | diamond | 327 | 158 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 27515949 | 27515949 | PRJNA1242190_S_NODE_3043_length_444_cov_4.846361_g3036_i0 | PRJNA1242190 | 3043 | 444 | 4.846361 | 21.51784284 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 85.5 | 1.21e-17 | NR | KAH7617709.1 | 1650286 | g3036 | i0 | 42.1 | 1.5472972972973 | 114 | 63 | 77 | 2 | 436 | 95 | 66 | 176 | KAH7617709.1 putative 60S ribosomal protein L18a-2 [Chlorella desiccata (nom. nud.)] | diamond | 687 | 85.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 29491564 | 29491564 | PRJNA1242190_S_NODE_6870_length_321_cov_3.145161_g6863_i0 | PRJNA1242190 | 6870 | 321 | 3.145161 | 10.09596681 | Chlamydomonadales | 3042 | Plants | Plants | 153 | 1.6e-44 | NR | KXZ41300.1 | 33097 | g6863 | i0 | 69.5 | 5.88785046728972 | 105 | 32 | 98.1 | 0 | 316 | 2 | 96 | 200 | KXZ41300.1 hypothetical protein GPECTOR_569g606 [Gonium pectorale] | diamond | 1890 | 154 | 0.993506493506494 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 29712267 | 29712267 | PRJNA1242190_S_NODE_1110_length_584_cov_4.289628_g1103_i0 | PRJNA1242190 | 1110 | 584 | 4.289628 | 25.05142752 | Eukaryota | 2759 | Plants | Plants | 132 | 1.7299999999999998e-35 | NR | XP_011396880.1 | 3075 | g1103 | i0 | 45.4 | 10.2585616438356 | 152 | 67 | 77.1 | 2 | 27 | 476 | 14 | 151 | XP_011396880.1 40S ribosomal protein S19-1 [Auxenochlorella protothecoides] | diamond | 5991 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 31134031 | 31134031 | PRJNA1242190_S_NODE_4975_length_366_cov_4.945392_g4968_i0 | PRJNA1242190 | 4975 | 366 | 4.945392 | 18.10013472 | Eukaryota | 2759 | Plants | Plants | 118 | 8.729999999999998e-31 | NR | ADB77798.1 | 34128 | g4968 | i0 | 55.4 | 30.2459016393443 | 101 | 45 | 82.8 | 0 | 366 | 64 | 77 | 177 | ADB77798.1 40S ribosomal protein S9, partial [Cladophora coelothrix] | diamond | 11070 | 118 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Cladophoraceae | Cladophora | Cladophora coelothrix | |
| 31653648 | 31653648 | PRJNA1242190_S_NODE_2877_length_452_cov_5.910290_g2870_i0 | PRJNA1242190 | 2877 | 452 | 5.91029 | 26.7145108 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 110 | 5.07e-28 | NR | CAG9460866.1 | 765719 | g2870 | i0 | 52.6 | 0.882743362831858 | 133 | 47 | 88.3 | 2 | 430 | 32 | 6 | 122 | CAG9460866.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 399 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 |
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);;