contig_metadata
21 rows where bioproject = "PRJNA1068513" and tax_phylum = "Chlorophyta"
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 | |
| 14210513 | 14210513 | PRJNA1068513_S_NODE_13672_length_233_cov_2.425000_g13626_i0 | PRJNA1068513 | 13672 | 233 | 2.425 | 5.65025 | Chloropicon primus | 1764295 | Plants | Plants | 91.7 | 1.7e-19 | NR | QDZ18052.1 | 1764295 | g13626 | i0 | 54.5 | 0.991416309012876 | 77 | 31 | 99.1 | 1 | 3 | 233 | 185 | 257 | QDZ18052.1 mitogen-activated protein kinase [Chloropicon primus] | diamond | 231 | 91.7 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon primus | ||
| 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 | |
| 24407750 | 24407750 | PRJNA1068513_S_NODE_3760_length_459_cov_2.357513_g3715_i0 | PRJNA1068513 | 3760 | 459 | 2.357513 | 10.82098467 | Micromonas pusilla CCMP1545 | 564608 | Plants | Plants | 165 | 6.329999999999999e-46 | NR | XP_003061556.1 | 564608 | g3715 | i0 | 66.7 | 6.28758169934641 | 120 | 39 | 77.8 | 1 | 1 | 357 | 329 | 448 | XP_003061556.1 uncharacterized protein MICPUCDRAFT_44735 [Micromonas pusilla CCMP1545] | diamond | 2886 | 165 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 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 | |
| 27193597 | 27193597 | PRJNA1068513_S_NODE_11162_length_265_cov_1.640625_g11116_i0 | PRJNA1068513 | 11162 | 265 | 1.640625 | 4.34765625 | Pycnococcus provasolii | 41880 | Plants | Plants | 69.7 | 1.57e-11 | NR | GHP11949.1 | 41880 | g11116 | i0 | 45.3 | 0.973584905660377 | 86 | 43 | 92.8 | 2 | 246 | 1 | 249 | 334 | GHP11949.1 hypothetical protein PPROV_001067600 [Pycnococcus provasolii] | diamond | 258 | 69.7 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pseudoscourfieldiophyceae | Pseudoscourfieldiales | Pycnococcaceae | Pycnococcus | Pycnococcus provasolii | ||
| 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 | |
| 28204097 | 28204097 | PRJNA1068513_S_NODE_11306_length_263_cov_1.421053_g11260_i0 | PRJNA1068513 | 11306 | 263 | 1.421053 | 3.73736939 | Chloropicon primus | 1764295 | Plants | Plants | 47 | 0.00149 | NR | QDZ21715.1 | 1764295 | g11260 | i0 | 36.4 | 0.627376425855513 | 55 | 35 | 62.7 | 0 | 65 | 229 | 374 | 428 | QDZ21715.1 WD40 repeat domain-containing protein [Chloropicon primus] | diamond | 165 | 47 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon primus | ||
| 28258881 | 28258881 | PRJNA1068513_S_NODE_2066_length_563_cov_4.251020_g2024_i0 | PRJNA1068513 | 2066 | 563 | 4.25102 | 23.9332426 | Opisthokonta | 33154 | Plants | Plants | 82.4 | 1.57e-14 | NR | XP_003062756.1 | 564608 | g2024 | i0 | 38 | 1.59857904085258 | 142 | 68 | 68.2 | 2 | 78 | 461 | 578 | 713 | XP_003062756.1 uncharacterized protein MICPUCDRAFT_22077 [Micromonas pusilla CCMP1545] | diamond | 900 | 83.2 | 0.990384615384615 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 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 | |
| 31132842 | 31132842 | PRJNA1068513_S_NODE_2335_length_542_cov_2.543710_g2293_i0 | PRJNA1068513 | 2335 | 542 | 2.54371 | 13.7869082 | Opisthokonta | 33154 | Plants | Plants | 145 | 1.4899999999999998e-37 | NR | XP_003056182.1 | 564608 | g2293 | i0 | 57 | 1.30073800738007 | 121 | 45 | 63.1 | 1 | 3 | 344 | 377 | 497 | XP_003056182.1 thioredoxin-disufide reductase [Micromonas pusilla CCMP1545] | diamond | 705 | 145 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 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 | |
| 31868867 | 31868867 | PRJNA1068513_S_NODE_6937_length_346_cov_3.032967_g6891_i0 | PRJNA1068513 | 6937 | 346 | 3.032967 | 10.49406582 | Chloropicon roscoffensis | 1461544 | Plants | Plants | 75.1 | 4.96e-13 | NR | WZN65998.1 | 1461544 | g6891 | i0 | 82.1 | 1.39595375722543 | 39 | 7 | 33.8 | 0 | 318 | 202 | 393 | 431 | WZN65998.1 dynein assembly factor with WDR repeat domains [Chloropicon roscoffensis] | diamond | 483 | 75.1 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon roscoffensis | ||
| 32430150 | 32430150 | PRJNA1068513_S_NODE_10899_length_269_cov_2.785714_g10853_i0 | PRJNA1068513 | 10899 | 269 | 2.785714 | 7.49357066 | Ostreococcus | 70447 | Plants | Plants | 104 | 4.13e-26 | NR | XP_003080092.2 | 70448 | g10853 | i0 | 60.7 | 2.97769516728625 | 89 | 33 | 99.3 | 1 | 269 | 3 | 46 | 132 | XP_003080092.2 Acyl-CoA N-acyltransferase [Ostreococcus tauri] | diamond | 801 | 105 | 0.990476190476191 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus tauri | ||
| 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);;