contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1129273" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26817339 | 26817339 | PRJNA1129273_P_NODE_3121_length_421_cov_6.459770_g2842_i0 | PRJNA1129273 | 3121 | 421 | 6.45977 | 27.1956317 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 98.2 | 2.4799999999999994e-23 | NR | CAG9460866.1 | 765719 | g2842 | i0 | 45.7 | 0.997624703087886 | 140 | 57 | 99.8 | 2 | 1 | 420 | 1 | 121 | CAG9460866.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 420 | 98.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 27164976 | 27164976 | PRJNA1129273_P_NODE_2562_length_478_cov_1.133333_g2286_i0 | PRJNA1129273 | 2562 | 478 | 1.133333 | 5.41733174 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 164 | 2.03e-45 | NR | CAG9467443.1 | 765719 | g2286 | i0 | 61.8 | 2.60460251046025 | 136 | 51 | 84.7 | 1 | 405 | 1 | 29 | 164 | CAG9467443.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 1245 | 164 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 28049454 | 28049454 | PRJNA1129273_P_NODE_7165_length_269_cov_8.204082_g6885_i0 | PRJNA1129273 | 7165 | 269 | 8.204082 | 22.06898058 | Trebouxia sp. C | 2796353 | Plants | Plants | 53.5 | 2.57e-6 | NR | KAL3146794.1 | 3373144 | g6885 | i0 | 47.5 | 0.680297397769517 | 61 | 32 | 68 | 0 | 82 | 264 | 82 | 142 | KAL3146794.1 hypothetical protein ABBQ38_014774 [Trebouxia sp. C0009 RCD-2024] | diamond | 183 | 53.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0009 RCD-2024 | |
| 29407064 | 29407064 | PRJNA1129273_P_NODE_10249_length_243_cov_1.758824_g9969_i0 | PRJNA1129273 | 10249 | 243 | 1.758824 | 4.27394232 | Prototheca wickerhamii | 3111 | Plants | Plants | 55.5 | 1.86e-7 | NR | KAK2076752.1 | 3111 | g9969 | i0 | 43.1 | 1.44444444444444 | 58 | 33 | 71.6 | 0 | 238 | 65 | 71 | 128 | KAK2076752.1 hypothetical protein QBZ16_005512 [Prototheca wickerhamii] | diamond | 351 | 55.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 29901572 | 29901572 | PRJNA1129273_P_NODE_10991_length_231_cov_2.943038_g10711_i0 | PRJNA1129273 | 10991 | 231 | 2.943038 | 6.79841778 | Eukaryota | 2759 | Plants | Plants | 88.2 | 3.12e-18 | NR | WIA21353.1 | 3088 | g10711 | i0 | 59.2 | 16.6233766233766 | 76 | 28 | 98.7 | 1 | 2 | 229 | 24 | 96 | WIA21353.1 hypothetical protein OEZ85_000576 [Tetradesmus obliquus] | diamond | 3840 | 88.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 30481117 | 30481117 | PRJNA1129273_P_NODE_9553_length_247_cov_0.879310_g9273_i0 | PRJNA1129273 | 9553 | 247 | 0.87931 | 2.1718957 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 43.1 | 0.028 | NR | XP_005642590.1 | 574566 | g9273 | i0 | 35.9 | 0.777327935222672 | 64 | 40 | 77.7 | 1 | 208 | 17 | 178 | 240 | XP_005642590.1 hypothetical protein COCSUDRAFT_45675 [Coccomyxa subellipsoidea C-169] | diamond | 192 | 43.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 30849272 | 30849272 | PRJNA1129273_P_NODE_6914_length_274_cov_1.129353_g6634_i0 | PRJNA1129273 | 6914 | 274 | 1.129353 | 3.09442722 | Chlorophyceae | 3166 | Plants | Plants | 45.1 | 0.00844 | NR | KAF5842967.1 | 3046 | g6634 | i0 | 48.1 | 1.31386861313869 | 52 | 15 | 56.9 | 2 | 271 | 116 | 447 | 486 | KAF5842967.1 NUC091 domain-containing protein [Dunaliella salina] | diamond | 360 | 45.4 | 0.993392070484582 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 30955227 | 30955227 | PRJNA1129273_P_NODE_10694_length_241_cov_2.053571_g10414_i0 | PRJNA1129273 | 10694 | 241 | 2.053571 | 4.94910611 | Pleodorina starrii | 330485 | Plants | Plants | 121 | 6.48e-30 | NR | GLC34488.1 | 330485 | g10414 | i0 | 64.1 | 2.93775933609959 | 78 | 28 | 97.1 | 0 | 240 | 7 | 458 | 535 | GLC34488.1 hypothetical protein PLESTM_000204200 [Pleodorina starrii] | diamond | 708 | 121 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pleodorina | Pleodorina starrii | |
| 31050102 | 31050102 | PRJNA1129273_P_NODE_8375_length_253_cov_2.472222_g8095_i0 | PRJNA1129273 | 8375 | 253 | 2.472222 | 6.25472166 | Apatococcus lobatus | 904363 | Plants | Plants | 52.4 | 1.59e-5 | NR | KAK9818710.1 | 904363 | g8095 | i0 | 54 | 0.592885375494071 | 50 | 19 | 59.3 | 2 | 104 | 253 | 23 | 68 | KAK9818710.1 hypothetical protein WJX74_000678 [Apatococcus lobatus] | diamond | 150 | 52.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Apatococcus | Apatococcus lobatus | |
| 31618918 | 31618918 | PRJNA1129273_P_NODE_4236_length_350_cov_0.841155_g3956_i0 | PRJNA1129273 | 4236 | 350 | 0.841155 | 2.9440425 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 149 | 4.06e-39 | NR | KAG7672042.1 | 1650286 | g3956 | i0 | 59.5 | 5.94 | 116 | 47 | 99.4 | 0 | 2 | 349 | 205 | 320 | KAG7672042.1 hypothetical protein KSW81_004927 [Chlorella desiccata (nom. nud.)] | diamond | 2079 | 149 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 31808738 | 31808738 | PRJNA1129273_P_NODE_10337_length_243_cov_0.911765_g10057_i0 | PRJNA1129273 | 10337 | 243 | 0.911765 | 2.21558895 | Trebouxia sp. C | 2796353 | Plants | Plants | 132 | 7.67e-34 | NR | KAL3149191.1 | 3373145 | g10057 | i0 | 81.3 | 0.987654320987654 | 80 | 15 | 98.8 | 0 | 1 | 240 | 34 | 113 | KAL3149191.1 hypothetical protein ABBQ32_002019 [Trebouxia sp. C0010 RCD-2024] | diamond | 240 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0010 RCD-2024 |
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);;