contig_metadata
13 rows where bioproject = "PRJNA1068513" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1456583 | 1456583 | PRJNA1068513_S_NODE_5222_length_397_cov_22.453704_g5177_i0 | PRJNA1068513 | 5222 | 397 | 22.453704 | 89.14120488 | Monoraphidium neglectum | 145388 | Plants | Plants | 54.7 | 0.011 | NTclustered | gi|926786903|ref|XM_014046472.1| | 145388 | g5177 | i0 | 100 | 0.0730478589420655 | 29 | 0 | 7 | 0 | 4 | 32 | 479 | 451 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 15484610 | 15484610 | PRJNA1068513_S_NODE_5873_length_376_cov_2.316832_g5827_i0 | PRJNA1068513 | 5873 | 376 | 2.316832 | 8.71128832 | Tetradesmus dimorphus | 119574 | Plants | Plants | 63.9 | 1.65e-5 | NTclustered | gi|2692951716|ref|NC_086754.1| | 119574 | g5827 | i0 | 100 | 0.0904255319148936 | 34 | 0 | 9 | 0 | 27 | 60 | 71182 | 71215 | Tetradesmus dimorphus strain FBCC-A0330 chloroplast, complete genome | blastn | 34 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus dimorphus | |
| 19307414 | 19307414 | PRJNA1068513_S_NODE_12936_length_245_cov_5.023256_g12890_i0 | PRJNA1068513 | 12936 | 245 | 5.023256 | 12.3069772 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 104 | 6.02e-18 | NTclustered | gi|760447288|ref|XM_011402411.1| | 3075 | g12890 | i0 | 87.64 | 42.1918367346939 | 89 | 11 | 36 | 0 | 156 | 244 | 1652 | 1564 | Auxenochlorella protothecoides Peptidylprolyl isomerase domain and WD repeat-containing protein 1 partial mRNA | blastn | 10337 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 27027213 | 27027213 | PRJNA1068513_S_NODE_4042_length_445_cov_5.215054_g3997_i0 | PRJNA1068513 | 4042 | 445 | 5.215054 | 23.2069903 | Eukaryota | 2759 | Plants | Plants | 104 | 1.27e-25 | NR | KAI3429597.1 | 3077 | g3997 | i0 | 50.4 | 10.0516853932584 | 131 | 64 | 87.6 | 1 | 436 | 47 | 3 | 133 | KAI3429597.1 hypothetical protein D9Q98_005683 [Chlorella vulgaris] | diamond | 4473 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 27659336 | 27659336 | PRJNA1068513_S_NODE_8864_length_304_cov_1.151515_g8818_i0 | PRJNA1068513 | 8864 | 304 | 1.151515 | 3.5006056 | Eukaryota | 2759 | Plants | Plants | 74.7 | 7.83e-14 | NR | XP_011396886.1 | 3075 | g8818 | i0 | 44 | 4.40131578947368 | 75 | 42 | 74 | 0 | 8 | 232 | 124 | 198 | XP_011396886.1 TATA-box-binding protein 2 [Auxenochlorella protothecoides] | diamond | 1338 | 74.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 28993962 | 28993962 | PRJNA1068513_S_NODE_3348_length_479_cov_3.544335_g3303_i0 | PRJNA1068513 | 3348 | 479 | 3.544335 | 16.97736465 | Coccomyxa elongata | 1965095 | Plants | Plants | 65.9 | 6.62e-11 | NR | CAL8468898.1 | 1965095 | g3303 | i0 | 42.3 | 0.488517745302714 | 78 | 41 | 48.9 | 2 | 46 | 279 | 10 | 83 | CAL8468898.1 g8439 [Coccomyxa elongata] | diamond | 234 | 65.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa elongata | ||
| 29301039 | 29301039 | PRJNA1068513_S_NODE_12049_length_253_cov_0.866667_g12003_i0 | PRJNA1068513 | 12049 | 253 | 0.866667 | 2.19266751 | root | 1 | Root_unresolved | Root_unresolved | 46.6 | 0.0019 | NR | XP_005651365.1 | 574566 | g12003 | i0 | 36.2 | 5.26482213438735 | 58 | 37 | 68.8 | 0 | 226 | 53 | 175 | 232 | XP_005651365.1 fibronectin type III [Coccomyxa subellipsoidea C-169] | diamond | 1332 | 46.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 29404163 | 29404163 | PRJNA1068513_S_NODE_9669_length_289_cov_1.379630_g9623_i0 | PRJNA1068513 | 9669 | 289 | 1.37963 | 3.9871307 | Tetradesmus obliquus | 3088 | Plants | Plants | 49.7 | 1.96e-4 | NR | WIA42092.1 | 3088 | g9623 | i0 | 34 | 1.00692041522491 | 97 | 54 | 93.4 | 3 | 285 | 16 | 135 | 228 | WIA42092.1 hypothetical protein OEZ86_009367 [Tetradesmus obliquus] | diamond | 291 | 49.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 29972510 | 29972510 | PRJNA1068513_S_NODE_6851_length_348_cov_4.098182_g6805_i0 | PRJNA1068513 | 6851 | 348 | 4.098182 | 14.26167336 | Polytomella parva | 51329 | Plants | Plants | 148 | 8.62e-41 | NR | QKY14960.1 | 51329 | g6805 | i0 | 71.3 | 11.3879310344828 | 101 | 29 | 87.1 | 0 | 346 | 44 | 257 | 357 | QKY14960.1 pyruvate dehydrogenase E1 component subunit alpha - subunit beta (PDh-E1 BETA) [Polytomella parva] | diamond | 3963 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 31710820 | 31710820 | PRJNA1068513_S_NODE_2117_length_559_cov_24.987654_g2075_i0 | PRJNA1068513 | 2117 | 559 | 24.987654 | 139.68098586 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 102 | 1.71e-24 | NR | CAG9460866.1 | 765719 | g2075 | i0 | 46.1 | 2.20572450805009 | 141 | 57 | 75.7 | 2 | 44 | 466 | 1 | 122 | CAG9460866.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 1233 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 31860362 | 31860362 | PRJNA1068513_S_NODE_13197_length_243_cov_1.529412_g13151_i0 | PRJNA1068513 | 13197 | 243 | 1.529412 | 3.71647116 | Chlamydomonadales | 3042 | Plants | Plants | 50.8 | 3.63e-5 | NR | PNH03195.1 | 47790 | g13151 | i0 | 45 | 1.30864197530864 | 60 | 24 | 63 | 1 | 238 | 86 | 168 | 227 | PNH03195.1 T-complex protein 1 subunit zeta, partial [Tetrabaena socialis] | diamond | 318 | 51.2 | 0.9921875 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Tetrabaenaceae | Tetrabaena | Tetrabaena socialis | |
| 32438751 | 32438751 | PRJNA1068513_S_NODE_7279_length_338_cov_1.430189_g7233_i0 | PRJNA1068513 | 7279 | 338 | 1.430189 | 4.83403882 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 80.5 | 2.46e-15 | NR | CAG9467008.1 | 765719 | g7233 | i0 | 46.5 | 1.2603550295858 | 71 | 38 | 63 | 0 | 323 | 111 | 227 | 297 | CAG9467008.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 426 | 80.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 32848402 | 32848402 | PRJNA1068513_S_NODE_720_length_752_cov_15.499264_g684_i0 | PRJNA1068513 | 720 | 752 | 15.499264 | 116.55446528 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 199 | 1.59e-60 | NR | GAX77325.1 | 1157962 | g684 | i0 | 66.4 | 3 | 149 | 50 | 59.4 | 0 | 182 | 628 | 56 | 204 | GAX77325.1 hypothetical protein CEUSTIGMA_g4771.t1 [Chlamydomonas eustigma] | diamond | 2256 | 199 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma |
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);;