contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2731626 | 2731626 | PRJNA1067370_P_NODE_81863_length_251_cov_0.865169_g81314_i0 | PRJNA1067370 | 81863 | 251 | 0.865169 | 2.17157419 | Micractinium reisseri | 532145 | Plants | Plants | 279 | 9.58e-71 | NTclustered | gi|297501471|dbj|AB506071.1| | 532145 | g81314 | i0 | 86.853 | 5.31872509960159 | 251 | 32 | 100 | 1 | 1 | 251 | 6359 | 6110 | Micractinium reisseri genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, clone: 2 | blastn | 1335 | 279 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium reisseri | |
| 4841336 | 4841336 | PRJNA1067370_P_NODE_67644_length_268_cov_1.579487_g67095_i0 | PRJNA1067370 | 67644 | 268 | 1.579487 | 4.23302516 | Eukaryota | 2759 | Plants | Plants | 224 | 4.909999999999999e-54 | NTclustered | gi|760444278|ref|XM_011400906.1| | 3075 | g67095 | i0 | 82.824 | 93.5522388059701 | 262 | 33 | 98 | 7 | 1 | 262 | 277 | 28 | Auxenochlorella protothecoides Histone H3.1 partial mRNA | blastn | 25072 | 224 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 4841383 | 4841383 | PRJNA1067370_P_NODE_85684_length_249_cov_1.551136_g85135_i0 | PRJNA1067370 | 85684 | 249 | 1.551136 | 3.86232864 | Eukaryota | 2759 | Plants | Plants | 122 | 1.69e-23 | NTclustered | gi|926770371|ref|XM_014038206.1| | 145388 | g85135 | i0 | 88.889 | 18.0401606425703 | 99 | 11 | 40 | 0 | 14 | 112 | 55 | 153 | Monoraphidium neglectum solute carrier family 25 partial mRNA | blastn | 4492 | 122 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 5283651 | 5283651 | PRJNA1067370_P_NODE_36445_length_330_cov_3.105058_g35897_i0 | PRJNA1067370 | 36445 | 330 | 3.105058 | 10.2466914 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 165 | 3.82e-36 | NTclustered | gi|2082260551|ref|XM_001702928.2| | 3055 | g35897 | i0 | 81.5 | 48.8151515151515 | 200 | 37 | 61 | 0 | 11 | 210 | 356 | 157 | Chlamydomonas reinhardtii ribosomal protein S11 (CHLRE_12g514500v5), mRNA | blastn | 16109 | 165 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 5283704 | 5283704 | PRJNA1067370_P_NODE_44985_length_309_cov_2.855932_g44437_i0 | PRJNA1067370 | 44985 | 309 | 2.855932 | 8.82482988 | Chloromonas perforata | 51730 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|953272850|gb|KT625416.1| | 51730 | g44437 | i0 | 100 | 0.0970873786407767 | 30 | 0 | 10 | 0 | 247 | 276 | 219960 | 219931 | Chloromonas perforata culture-collection SAG:11-43 chloroplast, partial genome | blastn | 30 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chloromonas | Chloromonas perforata | |
| 5283721 | 5283721 | PRJNA1067370_P_NODE_47825_length_301_cov_9.732456_g47277_i0 | PRJNA1067370 | 47825 | 301 | 9.7324560000000009 | 29.29469256 | Desmochloris halophila | 138176 | Plants | Plants | 501 | 2.31e-137 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g47277 | i0 | 96.689 | 66.5182724252492 | 302 | 9 | 100 | 1 | 1 | 301 | 3693 | 3994 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 20022 | 501 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 9108644 | 9108644 | PRJNA1067370_P_NODE_76948_length_254_cov_1.701657_g76399_i0 | PRJNA1067370 | 76948 | 254 | 1.701657 | 4.32220878 | Monoraphidium neglectum | 145388 | Plants | Plants | 226 | 1.2799999999999999e-54 | NTclustered | gi|926779487|ref|XM_014042764.1| | 145388 | g76399 | i0 | 86.408 | 23.6968503937008 | 206 | 28 | 81 | 0 | 1 | 206 | 869 | 664 | Monoraphidium neglectum NADH dehydrogenase (ubiquinone) flavoprotein 1 mRNA | blastn | 6019 | 226 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 9108800 | 9108800 | PRJNA1067370_P_NODE_96288_length_246_cov_0.890173_g95739_i0 | PRJNA1067370 | 96288 | 246 | 0.890173 | 2.18982558 | Chlorella variabilis | 554065 | Plants | Plants | 198 | 2.7e-46 | NTclustered | gi|552827548|ref|XM_005847191.1| | 554065 | g95739 | i0 | 81.405 | 41.5894308943089 | 242 | 45 | 98 | 0 | 4 | 245 | 378 | 619 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_134244) mRNA, complete cds | blastn | 10231 | 198 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 11659367 | 11659367 | PRJNA1067370_P_NODE_27670_length_367_cov_1.047619_g27122_i0 | PRJNA1067370 | 27670 | 367 | 1.047619 | 3.84476173 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 303 | 8.71e-78 | NTclustered | gi|2082247947|ref|XM_001698013.2| | 3055 | g27122 | i0 | 81.769 | 58.8801089918256 | 373 | 59 | 100 | 6 | 1 | 367 | 601 | 232 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g278222v5), mRNA | blastn | 21609 | 303 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 13766603 | 13766603 | PRJNA1067370_P_NODE_54011_length_289_cov_1.120370_g53462_i0 | PRJNA1067370 | 54011 | 289 | 1.12037 | 3.2378693 | Chlamydomonas | 3052 | Plants | Plants | 254 | 6.83e-63 | NTclustered | gi|2082247947|ref|XM_001698013.2| | 3055 | g53462 | i0 | 85.425 | 23.757785467128 | 247 | 32 | 85 | 4 | 11 | 255 | 434 | 190 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g278222v5), mRNA | blastn | 6866 | 254 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 14209391 | 14209391 | PRJNA1067370_P_NODE_17172_length_449_cov_2.148936_g16624_i0 | PRJNA1067370 | 17172 | 449 | 2.148936 | 9.64872264 | Gonium pectorale | 33097 | Plants | Plants | 274 | 8.53e-69 | NTclustered | gi|165974599|dbj|AB353888.1| | 33097 | g16624 | i0 | 79.302 | 34.3986636971047 | 401 | 75 | 88 | 8 | 53 | 449 | 84 | 480 | Gonium pectorale EFL1 mRNA for elongation factor-1 alpha-like protein, complete cds | blastn | 15445 | 274 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 15483969 | 15483969 | PRJNA1067370_P_NODE_9413_length_590_cov_2.827853_g8879_i0 | PRJNA1067370 | 9413 | 590 | 2.827853 | 16.6843327 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 309 | 3.1300000000000003e-79 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g8879 | i0 | 77.18 | 70.5372881355932 | 539 | 117 | 91 | 5 | 55 | 590 | 291 | 826 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 41617 | 309 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 15483980 | 15483980 | PRJNA1067370_P_NODE_95973_length_246_cov_1.335260_g95424_i0 | PRJNA1067370 | 95973 | 246 | 1.33526 | 3.2847396 | Chlamydomonas incerta | 51695 | Plants | Plants | 215 | 2.68e-51 | NTclustered | gi|74272606|gb|DQ122868.1| | 51695 | g95424 | i0 | 86.598 | 19.0731707317073 | 194 | 26 | 79 | 0 | 51 | 244 | 34 | 227 | Chlamydomonas incerta 40S ribosomal protein S3 mRNA, complete cds | blastn | 4692 | 215 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 16757629 | 16757629 | PRJNA1067370_P_NODE_21534_length_407_cov_1.395210_g20986_i0 | PRJNA1067370 | 21534 | 407 | 1.39521 | 5.6785047 | Monoraphidium neglectum | 145388 | Plants | Plants | 309 | 2.1e-79 | NTclustered | gi|926773763|ref|XM_014039902.1| | 145388 | g20986 | i0 | 80.723 | 61.1965601965602 | 415 | 64 | 100 | 14 | 1 | 407 | 411 | 5 | Monoraphidium neglectum 60S ribosomal protein L19-2 mRNA | blastn | 24907 | 309 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 20139629 | 20139629 | PRJNA1067370_P_NODE_15616_length_468_cov_2.858228_g15068_i0 | PRJNA1067370 | 15616 | 468 | 2.858228 | 13.37650704 | Eukaryota | 2759 | Plants | Plants | 331 | 5.220000000000001e-86 | NTclustered | gi|926781221|ref|XM_014043631.1| | 145388 | g15068 | i0 | 82.292 | 67.3867521367521 | 384 | 66 | 82 | 2 | 7 | 389 | 383 | 1 | Monoraphidium neglectum large subunit ribosomal protein L40e mRNA | blastn | 31537 | 333 | 0.993993993993994 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 20582153 | 20582153 | PRJNA1067370_P_NODE_69897_length_265_cov_1.104167_g69348_i0 | PRJNA1067370 | 69897 | 265 | 1.104167 | 2.92604255 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 54.7 | 0.007 | NTclustered | gi|2082257431|ref|XM_043067004.1| | 3055 | g69348 | i0 | 100 | 0.109433962264151 | 29 | 0 | 11 | 0 | 16 | 44 | 3514 | 3486 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_10g453500v5), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22690123 | 22690123 | PRJNA1067370_P_NODE_74778_length_257_cov_2.347826_g74229_i0 | PRJNA1067370 | 74778 | 257 | 2.347826 | 6.03391282 | Desmochloris | 138596 | Plants | Plants | 460 | 3.28e-125 | NTclustered | gi|313476263|emb|FM882216.1| | 138176 | g74229 | i0 | 99.216 | 99.2217898832685 | 255 | 2 | 99 | 0 | 1 | 255 | 599 | 853 | Desmochloris halophila partial 18S rRNA gene, ITS1, 5.8S rRNA and ITS2, strain CCAP 6006/1 | blastn | 25500 | 460 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 24406713 | 24406713 | PRJNA1067370_P_NODE_30500_length_353_cov_1.517857_g29952_i0 | PRJNA1067370 | 30500 | 353 | 1.517857 | 5.35803521 | Monoraphidium neglectum | 145388 | Plants | Plants | 267 | 1.09e-66 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g29952 | i0 | 84.058 | 72.2152974504249 | 276 | 44 | 78 | 0 | 65 | 340 | 61 | 336 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 25492 | 267 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum |
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);;