contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJEB14803" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21487 | 21487 | PRJEB14803_P_NODE_29401_length_200_cov_1.939394_g28935_i0 | PRJEB14803 | 29401 | 200 | 1.939394 | 3.878788 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 93.5 | 1.02e-14 | NTclustered | gi|2082239806|ref|XM_001699906.2| | 3055 | g28935 | i0 | 77.64 | 0.805 | 161 | 30 | 79 | 5 | 6 | 163 | 754 | 597 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g107850v5), mRNA | blastn | 161 | 93.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 1295795 | 1295795 | PRJEB14803_P_NODE_8842_length_442_cov_1.476658_g8380_i0 | PRJEB14803 | 8842 | 442 | 1.476658 | 6.52682836 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 244 | 6.57e-60 | NTclustered | gi|760445070|ref|XM_011401302.1| | 3075 | g8380 | i0 | 94.872 | 35.9773755656109 | 156 | 8 | 35 | 0 | 287 | 442 | 7821 | 7976 | Auxenochlorella protothecoides Pre-mRNA-processing-splicing factor 8 partial mRNA | blastn | 15902 | 244 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 2571302 | 2571302 | PRJEB14803_P_NODE_25123_length_222_cov_1.689840_g24657_i0 | PRJEB14803 | 25123 | 222 | 1.68984 | 3.7514448 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 141 | 4.09e-29 | NTclustered | gi|2082259434|ref|XM_001700488.2| | 3055 | g24657 | i0 | 85.106 | 7.42342342342342 | 141 | 17 | 63 | 4 | 3 | 141 | 2526 | 2388 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g492950v5), mRNA | blastn | 1648 | 141 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 5123916 | 5123916 | PRJEB14803_P_NODE_40405_length_164_cov_1.961240_g39939_i0 | PRJEB14803 | 40405 | 164 | 1.96124 | 3.2164336 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 163 | 6.06e-36 | NTclustered | gi|545363001|ref|XM_005646641.1| | 574566 | g39939 | i0 | 84.663 | 84.2012195121951 | 163 | 25 | 99 | 0 | 1 | 163 | 5875 | 5713 | Coccomyxa subellipsoidea C-169 Not1-domain-containing protein partial mRNA | blastn | 13809 | 163 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 5123950 | 5123950 | PRJEB14803_P_NODE_47025_length_151_cov_1.051724_g46559_i0 | PRJEB14803 | 47025 | 151 | 1.051724 | 1.58810324 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 111 | 2e-20 | NTclustered | gi|635557420|emb|FN984965.1| | 37502 | g46559 | i0 | 80.986 | 1.2317880794702 | 142 | 25 | 93 | 2 | 1 | 141 | 1314 | 1454 | Polytomella sp. Pringsheim 198.80 mRNA for S-Adenosyl homocysteine hydrolase (sah1 gene) | blastn | 186 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 6399577 | 6399577 | PRJEB14803_P_NODE_24446_length_226_cov_1.879581_g23980_i0 | PRJEB14803 | 24446 | 226 | 1.879581 | 4.24785306 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 113 | 9.1e-21 | NTclustered | gi|402244316|emb|FR686759.1| | 37502 | g23980 | i0 | 93.421 | 0.336283185840708 | 76 | 5 | 34 | 0 | 29 | 104 | 1084 | 1159 | Polytomella sp. Pringsheim 198.80 mRNA for 40S ribosomal protein L3 (rpl3 gene) | blastn | 76 | 113 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 6399689 | 6399689 | PRJEB14803_P_NODE_5386_length_596_cov_7.119430_g4980_i0 | PRJEB14803 | 5386 | 596 | 7.11943 | 42.4318028 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 339 | 4.04e-88 | NTclustered | gi|760443288|ref|XM_011400411.1| | 3075 | g4980 | i0 | 81.05 | 65.1979865771812 | 438 | 71 | 72 | 11 | 72 | 503 | 441 | 10 | Auxenochlorella protothecoides Ubiquitin-conjugating enzyme E2 28 partial mRNA | blastn | 38858 | 339 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 7673848 | 7673848 | PRJEB14803_P_NODE_9607_length_419_cov_2.044271_g9143_i0 | PRJEB14803 | 9607 | 419 | 2.044271 | 8.56549549 | Monoraphidium neglectum | 145388 | Plants | Plants | 211 | 6.29e-50 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g9143 | i0 | 79.73 | 20.4773269689737 | 296 | 56 | 70 | 3 | 19 | 312 | 363 | 70 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 8580 | 211 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 11499601 | 11499601 | PRJEB14803_P_NODE_7350_length_493_cov_1.914847_g6896_i0 | PRJEB14803 | 7350 | 493 | 1.914847 | 9.44019571 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 196 | 2.1e-45 | NTclustered | gi|2082236188|ref|XM_043058392.1| | 3055 | g6896 | i0 | 80.37 | 20.4807302231237 | 270 | 43 | 55 | 1 | 1 | 270 | 5385 | 5644 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g016050v5), mRNA | blastn | 10097 | 196 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 11499607 | 11499607 | PRJEB14803_P_NODE_7570_length_485_cov_2.346667_g7114_i0 | PRJEB14803 | 7570 | 485 | 2.346667 | 11.38133495 | Monoraphidium neglectum | 145388 | Plants | Plants | 56.5 | 0.004 | NTclustered | gi|926797582|ref|XM_014050761.1| | 145388 | g7114 | i0 | 100 | 0.0618556701030928 | 30 | 0 | 6 | 0 | 426 | 455 | 914 | 943 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 14049619 | 14049619 | PRJEB14803_P_NODE_37432_length_172_cov_2.094891_g36966_i0 | PRJEB14803 | 37432 | 172 | 2.094891 | 3.60321252 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 99 | 1.83e-16 | NTclustered | gi|1214357917|gb|KY555127.1| | 3055 | g36966 | i0 | 84.158 | 1.17441860465116 | 101 | 16 | 59 | 0 | 58 | 158 | 481 | 381 | Chlamydomonas reinhardtii strain CC-503 cw92 mt+ heat shock protein 90B (HSP90B) mRNA, complete cds | blastn | 202 | 99 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 16288482 | 16288482 | PRJEB14803_P_NODE_2133_length_984_cov_2.935722_g1872_i0 | PRJEB14803 | 2133 | 984 | 2.935722 | 28.88750448 | Eukaryota | 2759 | Plants | Plants | 970 | 0 | NTclustered | gi|2082244282|ref|XM_001703058.2| | 3055 | g1872 | i0 | 85.56 | 89.6727642276423 | 928 | 132 | 94 | 2 | 58 | 984 | 555 | 1481 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_04g216850v5), mRNA | blastn | 88238 | 970 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 21698183 | 21698183 | PRJEB14803_P_NODE_33018_length_186_cov_1.966887_g32552_i0 | PRJEB14803 | 33018 | 186 | 1.966887 | 3.65840982 | Chlorella variabilis | 554065 | Plants | Plants | 139 | 1.19e-28 | NTclustered | gi|552825446|ref|XM_005846766.1| | 554065 | g32552 | i0 | 84.892 | 6.2741935483871 | 139 | 19 | 74 | 2 | 29 | 166 | 1207 | 1344 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_24676) mRNA, complete cds | blastn | 1167 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 21698202 | 21698202 | PRJEB14803_P_NODE_37598_length_172_cov_1.306569_g37132_i0 | PRJEB14803 | 37598 | 172 | 1.306569 | 2.24729868 | Chlorella variabilis | 554065 | Plants | Plants | 52.8 | 0.014 | NTclustered | gi|552827897|ref|XM_005847271.1| | 554065 | g37132 | i0 | 96.875 | 0.186046511627907 | 32 | 0 | 19 | 1 | 113 | 144 | 916 | 946 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_134505) mRNA, complete cds | blastn | 32 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 21698272 | 21698272 | PRJEB14803_P_NODE_6078_length_555_cov_1.759615_g5645_i0 | PRJEB14803 | 6078 | 555 | 1.759615 | 9.76586325 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 54.7 | 0.015 | NTclustered | gi|2082241375|ref|XM_043060475.1| | 3055 | g5645 | i0 | 94.444 | 0.0648648648648649 | 36 | 1 | 6 | 1 | 134 | 168 | 3765 | 3800 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g148050v5), mRNA | blastn | 36 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22973441 | 22973441 | PRJEB14803_P_NODE_32459_length_188_cov_2.091503_g31993_i0 | PRJEB14803 | 32459 | 188 | 2.091503 | 3.93202564 | Chlorella variabilis | 554065 | Plants | Plants | 110 | 9.43e-20 | NTclustered | gi|552826563|ref|XM_005846994.1| | 554065 | g31993 | i0 | 83.471 | 1.32978723404255 | 121 | 16 | 63 | 3 | 1 | 119 | 2557 | 2439 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_56190) mRNA, complete cds | blastn | 250 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis |
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);;