contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7226293 | 7226293 | PRJNA867519_P_NODE_19406_length_278_cov_1.502439_g19252_i0 | PRJNA867519 | 19406 | 278 | 1.502439 | 4.17678042 | Chlorella sorokiniana | 3076 | Plants | Plants | 215 | 3.08e-51 | NTclustered | gi|81157942|dbj|AB240142.1| | 3076 | g19252 | i0 | 81.071 | 27.0647482014388 | 280 | 43 | 99 | 10 | 3 | 277 | 2090 | 1816 | Chlorella sorokiniana EF-2 mRNA for elongation factor 2, partial cds | blastn | 7524 | 215 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 8500934 | 8500934 | PRJNA867519_P_NODE_15107_length_303_cov_2.008696_g14953_i0 | PRJNA867519 | 15107 | 303 | 2.008696 | 6.08634888 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 152 | 2.7e-32 | NTclustered | gi|2082260551|ref|XM_001702928.2| | 3055 | g14953 | i0 | 82.123 | 16.976897689769 | 179 | 30 | 59 | 2 | 1 | 178 | 336 | 159 | Chlamydomonas reinhardtii ribosomal protein S11 (CHLRE_12g514500v5), mRNA | blastn | 5144 | 152 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 8500998 | 8500998 | PRJNA867519_P_NODE_24027_length_257_cov_2.092391_g23873_i0 | PRJNA867519 | 24027 | 257 | 2.092391 | 5.37744487 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 211 | 3.64e-50 | NTclustered | gi|18243|emb|X60826.1| | 3055 | g23873 | i0 | 86.224 | 76.6926070038911 | 196 | 25 | 76 | 2 | 63 | 257 | 384 | 190 | C.reinhardtii UBI3 mRNA for ubiquitin-fusion protein (UbCEP52) | blastn | 19710 | 211 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 12327183 | 12327183 | PRJNA867519_P_NODE_15210_length_302_cov_2.580786_g15056_i0 | PRJNA867519 | 15210 | 302 | 2.580786 | 7.79397372 | Monoraphidium neglectum | 145388 | Plants | Plants | 122 | 2.1099999999999998e-23 | NTclustered | gi|926789524|ref|XM_014047782.1| | 145388 | g15056 | i0 | 78.947 | 5.39735099337748 | 190 | 32 | 62 | 6 | 105 | 290 | 186 | 1 | Monoraphidium neglectum 60S ribosomal protein L38 mRNA | blastn | 1630 | 122 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 13601695 | 13601695 | PRJNA867519_P_NODE_11351_length_341_cov_2.686567_g11197_i0 | PRJNA867519 | 11351 | 341 | 2.686567 | 9.16119347 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 235 | 2.98e-57 | NTclustered | gi|28193497|emb|AJ439528.1| | 37502 | g11197 | i0 | 82.772 | 75.3607038123167 | 267 | 43 | 78 | 3 | 73 | 337 | 595 | 330 | Polytomella sp. 'Pringsheim 198.80' mRNA for 40S ribosomal protein s5 (rs5 gene) | blastn | 25698 | 235 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 13601924 | 13601924 | PRJNA867519_P_NODE_8831_length_376_cov_2.481848_g8677_i0 | PRJNA867519 | 8831 | 376 | 2.481848 | 9.33174848 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 193 | 2.02e-44 | NTclustered | gi|2082263148|ref|XM_001693658.2| | 3055 | g8677 | i0 | 76.55 | 23.9813829787234 | 371 | 75 | 96 | 10 | 7 | 368 | 35 | 402 | Chlamydomonas reinhardtii ribosomal protein S3a (CHLRE_13g568650v5), mRNA | blastn | 9017 | 193 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 14876112 | 14876112 | PRJNA867519_P_NODE_25412_length_251_cov_0.865169_g25258_i0 | PRJNA867519 | 25412 | 251 | 0.865169 | 2.17157419 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 237 | 5.85e-58 | NTclustered | gi|760437954|ref|XM_011397744.1| | 3075 | g25258 | i0 | 83.871 | 22.4701195219124 | 248 | 40 | 99 | 0 | 2 | 249 | 16 | 263 | Auxenochlorella protothecoides Cell division cycle 5-like protein partial mRNA | blastn | 5640 | 237 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 14876125 | 14876125 | PRJNA867519_P_NODE_27172_length_249_cov_0.875000_g27018_i0 | PRJNA867519 | 27172 | 249 | 0.875 | 2.17875 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 161 | 3.59e-35 | NTclustered | gi|760445036|ref|XM_011401285.1| | 3075 | g27018 | i0 | 79.73 | 14.1164658634538 | 222 | 45 | 89 | 0 | 11 | 232 | 2521 | 2742 | Auxenochlorella protothecoides DNA-directed RNA polymerase III subunit rpc1 partial mRNA | blastn | 3515 | 161 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 17426422 | 17426422 | PRJNA867519_P_NODE_6334_length_433_cov_7.158333_g6180_i0 | PRJNA867519 | 6334 | 433 | 7.158333 | 30.99558189 | Pedinomonas sp. UTEX 'LB 1027' | 1108795 | Plants | Plants | 252 | 3.84e-62 | NTclustered | gi|371782101|emb|HE610133.1| | 1108795 | g6180 | i0 | 79.841 | 42.7090069284065 | 377 | 51 | 84 | 18 | 70 | 433 | 5092 | 4728 | Pedinomonas sp. UTEX 1027 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 1027 | blastn | 18493 | 252 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinomonadales | Pedinomonadaceae | Pedinomonas | Pedinomonas sp. UTEX 'LB 1027' | |
| 18699522 | 18699522 | PRJNA867519_P_NODE_33295_length_241_cov_1.476190_g33141_i0 | PRJNA867519 | 33295 | 241 | 1.47619 | 3.5576179 | Monoraphidium neglectum | 145388 | Plants | Plants | 233 | 7.22e-57 | NTclustered | gi|926782191|ref|XM_014044116.1| | 145388 | g33141 | i0 | 86.667 | 70.8174273858921 | 210 | 28 | 87 | 0 | 1 | 210 | 282 | 491 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 17067 | 233 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 19088465 | 19088465 | PRJNA867519_P_NODE_12235_length_331_cov_2.124031_g12081_i0 | PRJNA867519 | 12235 | 331 | 2.124031 | 7.03054261 | Eukaryota | 2759 | Plants | Plants | 270 | 7.91e-68 | NTclustered | gi|18243|emb|X60826.1| | 3055 | g12081 | i0 | 85.385 | 84.3504531722054 | 260 | 38 | 79 | 0 | 71 | 330 | 392 | 133 | C.reinhardtii UBI3 mRNA for ubiquitin-fusion protein (UbCEP52) | blastn | 27920 | 270 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 21639017 | 21639017 | PRJNA867519_P_NODE_25957_length_251_cov_0.865169_g25803_i0 | PRJNA867519 | 25957 | 251 | 0.865169 | 2.17157419 | Chlamydomonas | 3052 | Plants | Plants | 219 | 2.1199999999999998e-52 | NTclustered | gi|2089720333|gb|MZ444836.1| | 51694 | g25803 | i0 | 82.609 | 33.0398406374502 | 253 | 38 | 99 | 6 | 2 | 251 | 1407 | 1158 | Chlamydomonas globosa strain SAG 81.72 hypothetical protein mRNA, partial cds | blastn | 8293 | 219 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas globosa | |
| 22524920 | 22524920 | PRJNA867519_P_NODE_6018_length_442_cov_15.292683_g5864_i0 | PRJNA867519 | 6018 | 442 | 15.292683 | 67.59365886 | Chlorella variabilis | 554065 | Plants | Plants | 255 | 3.04e-63 | NTclustered | gi|552813385|ref|XM_005843877.1| | 554065 | g5864 | i0 | 81.731 | 17.4072398190045 | 312 | 52 | 70 | 5 | 71 | 380 | 1061 | 1369 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_59785) mRNA, complete cds | blastn | 7694 | 255 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 23800362 | 23800362 | PRJNA867519_P_NODE_30399_length_245_cov_0.895349_g30245_i0 | PRJNA867519 | 30399 | 245 | 0.895349 | 2.19360505 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 52.8 | 0.022 | NTclustered | gi|2082239839|ref|XM_043059842.1| | 3055 | g30245 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 88 | 115 | 3918 | 3945 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g108800v5), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 23800364 | 23800364 | PRJNA867519_P_NODE_30439_length_245_cov_0.895349_g30285_i0 | PRJNA867519 | 30439 | 245 | 0.895349 | 2.19360505 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|2917929806|emb|OZ234924.1| | 3350044 | g30285 | i0 | 100 | 0.118367346938776 | 29 | 0 | 12 | 0 | 126 | 154 | 1579569 | 1579541 | Trebouxia sp. SL0000003 genome assembly, chromosome: 19 | blastn | 29 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 |
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);;