contig_metadata
9 rows where bioproject = "PRJNA188516" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10569858 | 10569858 | PRJNA188516_P_NODE_2769_length_206_cov_0.993631_g2719_i0 | PRJNA188516 | 2769 | 206 | 0.993631 | 2.04687986 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 97.1 | 8.2e-16 | NTclustered | gi|2082260409|ref|XM_001702296.2| | 3055 | g2719 | i0 | 95.082 | 21.2087378640777 | 61 | 3 | 30 | 0 | 2 | 62 | 252 | 312 | Chlamydomonas reinhardtii ribosomal protein S17 (CHLRE_12g498250v5), mRNA | blastn | 4369 | 97.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20767303 | 20767303 | PRJNA188516_P_NODE_1697_length_272_cov_1.632287_g1647_i0 | PRJNA188516 | 1697 | 272 | 1.632287 | 4.43982064 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 132 | 5.74e-36 | NR | XP_005643653.1 | 574566 | g1647 | i0 | 69.7 | 4.90808823529412 | 89 | 27 | 98.2 | 0 | 5 | 271 | 106 | 194 | XP_005643653.1 60S ribosomal protein L7 [Coccomyxa subellipsoidea C-169] | diamond | 1335 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 28197013 | 28197013 | PRJNA188516_P_NODE_3506_length_181_cov_1.181818_g3456_i0 | PRJNA188516 | 3506 | 181 | 1.181818 | 2.13909058 | Eukaryota | 2759 | Plants | Plants | 51.6 | 7.49e-6 | NR | WIA28302.1 | 3088 | g3456 | i0 | 66.7 | 8.13812154696133 | 36 | 12 | 59.7 | 0 | 3 | 110 | 86 | 121 | WIA28302.1 hypothetical protein OEZ86_010854 [Tetradesmus obliquus] | diamond | 1473 | 52 | 0.992307692307692 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 28747692 | 28747692 | PRJNA188516_P_NODE_4007_length_169_cov_1.300000_g3957_i0 | PRJNA188516 | 4007 | 169 | 1.3 | 2.197 | Prototheca wickerhamii | 3111 | Plants | Plants | 49.3 | 4.76e-5 | NR | KAK2079365.1 | 3111 | g3957 | i0 | 37 | 0.958579881656805 | 54 | 34 | 95.9 | 0 | 167 | 6 | 156 | 209 | KAK2079365.1 hypothetical protein QBZ16_003056 [Prototheca wickerhamii] | diamond | 162 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 28905307 | 28905307 | PRJNA188516_P_NODE_3748_length_174_cov_2.080000_g3698_i0 | PRJNA188516 | 3748 | 174 | 2.08 | 3.6192 | Trebouxia sp. C | 2796353 | Plants | Plants | 64.3 | 1.78e-11 | NR | KAL0042167.1 | 2905653 | g3698 | i0 | 61.4 | 3.25862068965517 | 44 | 17 | 75.9 | 0 | 33 | 164 | 5 | 48 | KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004] | diamond | 567 | 64.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 29631478 | 29631478 | PRJNA188516_P_NODE_2790_length_205_cov_1.493590_g2740_i0 | PRJNA188516 | 2790 | 205 | 1.49359 | 3.0618595 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 82.4 | 2.41e-16 | NR | CAG9467028.1 | 765719 | g2740 | i0 | 55.2 | 6.81951219512195 | 67 | 30 | 98 | 0 | 1 | 201 | 617 | 683 | CAG9467028.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 1398 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 29757934 | 29757934 | PRJNA188516_P_NODE_5451_length_164_cov_0.904348_g5401_i0 | PRJNA188516 | 5451 | 164 | 0.904348 | 1.48313072 | Chlorella vulgaris | 3077 | Plants | Plants | 63.2 | 2.91e-10 | NR | KAI3430572.1 | 3077 | g5401 | i0 | 49.1 | 2.50609756097561 | 53 | 27 | 97 | 0 | 1 | 159 | 28 | 80 | KAI3430572.1 hypothetical protein D9Q98_005165 [Chlorella vulgaris] | diamond | 411 | 63.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 31337807 | 31337807 | PRJNA188516_P_NODE_5216_length_165_cov_0.896552_g5166_i0 | PRJNA188516 | 5216 | 165 | 0.896552 | 1.4793108 | Astrephomene gubernaculifera | 47775 | Plants | Plants | 89.7 | 3.51e-19 | NR | GFR43178.1 | 47775 | g5166 | i0 | 79.2 | 1.94545454545455 | 53 | 11 | 96.4 | 0 | 163 | 5 | 425 | 477 | GFR43178.1 hypothetical protein Agub_g4228 [Astrephomene gubernaculifera] | diamond | 321 | 89.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 31875442 | 31875442 | PRJNA188516_P_NODE_4457_length_168_cov_0.873950_g4407_i0 | PRJNA188516 | 4457 | 168 | 0.87395 | 1.468236 | Monoraphidium minutum | 39955 | Plants | Plants | 82.8 | 2.76e-17 | NR | KAI8470704.1 | 39955 | g4407 | i0 | 72.2 | 4.82142857142857 | 54 | 15 | 96.4 | 0 | 166 | 5 | 76 | 129 | KAI8470704.1 MAG: ribosomal protein S2, flavodoxin-like domain-containing protein [Monoraphidium minutum] | diamond | 810 | 82.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum |
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);;