contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1087264" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1468650 | 1468650 | PRJNA1087264_P_NODE_16622_length_165_cov_0.913793_g16540_i0 | PRJNA1087264 | 16622 | 165 | 0.913793 | 1.50775845 | Chlamydomonas sp. TK-1983 | 3056 | Plants | Plants | 58.4 | 2.97e-4 | NTclustered | gi|174203|gb|K02345.1|CRERRA | 3056 | g16540 | i0 | 100 | 0.187878787878788 | 31 | 0 | 19 | 0 | 1 | 31 | 88 | 118 | Chlamydomonas sp. TK-1983 5S ribosomal RNA gene, complete sequence | blastn | 31 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. TK-1983 | |
| 1468677 | 1468677 | PRJNA1087264_P_NODE_2842_length_393_cov_1.095930_g2761_i0 | PRJNA1087264 | 2842 | 393 | 1.09593 | 4.3070049 | Chlorella variabilis | 554065 | Plants | Plants | 165 | 4.63e-36 | NTclustered | gi|552825916|ref|XM_005846855.1| | 554065 | g2761 | i0 | 85.535 | 18.1221374045802 | 159 | 21 | 40 | 2 | 159 | 316 | 234 | 77 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_134811) mRNA, complete cds | blastn | 7122 | 165 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 4020618 | 4020618 | PRJNA1087264_P_NODE_15004_length_167_cov_0.864407_g14922_i0 | PRJNA1087264 | 15004 | 167 | 0.864407 | 1.44355969 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 100 | 4.93e-17 | NTclustered | gi|760444206|ref|XM_011400870.1| | 3075 | g14922 | i0 | 80 | 4.08383233532934 | 135 | 27 | 81 | 0 | 1 | 135 | 774 | 908 | Auxenochlorella protothecoides Lysine-tRNA ligase partial mRNA | blastn | 682 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 4020650 | 4020650 | PRJNA1087264_P_NODE_20764_length_162_cov_0.902655_g20682_i0 | PRJNA1087264 | 20764 | 162 | 0.902655 | 1.4623011 | Ulva intestinalis | 3116 | Plants | Plants | 111 | 2.19e-20 | NTclustered | gi|148524158|gb|EF551324.1| | 3116 | g20682 | i0 | 81.818 | 2.47530864197531 | 132 | 24 | 81 | 0 | 27 | 158 | 1155 | 1024 | Ulva intestinalis elongation factor-1 alpha-like protein mRNA, partial cds | blastn | 401 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva intestinalis | |
| 4845522 | 4845522 | PRJNA1087264_P_NODE_13264_length_173_cov_1.233871_g13182_i0 | PRJNA1087264 | 13264 | 173 | 1.233871 | 2.13459683 | Eukaryota | 2759 | Plants | Plants | 154 | 3.87e-33 | NTclustered | gi|926791444|ref|XM_014048742.1| | 145388 | g13182 | i0 | 87.5 | 11.4450867052023 | 136 | 14 | 78 | 3 | 39 | 173 | 2308 | 2441 | Monoraphidium neglectum adenosylhomocysteinase mRNA | blastn | 1980 | 154 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 5296855 | 5296855 | PRJNA1087264_P_NODE_4205_length_317_cov_2.085821_g4123_i0 | PRJNA1087264 | 4205 | 317 | 2.085821 | 6.61205257 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 117 | 1.04e-21 | NTclustered | gi|2082253493|ref|XM_043066154.1| | 3055 | g4123 | i0 | 86.667 | 1.40378548895899 | 105 | 14 | 33 | 0 | 29 | 133 | 652 | 756 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g405106v5), mRNA | blastn | 445 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 5296900 | 5296900 | PRJNA1087264_P_NODE_7745_length_226_cov_1.248588_g7663_i0 | PRJNA1087264 | 7745 | 226 | 1.248588 | 2.82180888 | Monoraphidium neglectum | 145388 | Plants | Plants | 111 | 3.27e-20 | NTclustered | gi|926770371|ref|XM_014038206.1| | 145388 | g7663 | i0 | 86.275 | 4.80530973451327 | 102 | 14 | 45 | 0 | 1 | 102 | 147 | 46 | Monoraphidium neglectum solute carrier family 25 partial mRNA | blastn | 1086 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 10397322 | 10397322 | PRJNA1087264_P_NODE_11909_length_183_cov_1.074627_g11827_i0 | PRJNA1087264 | 11909 | 183 | 1.074627 | 1.96656741 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 150 | 5.37e-32 | NTclustered | gi|2082260397|ref|XM_043068042.1| | 3055 | g11827 | i0 | 90.351 | 21.568306010929 | 114 | 11 | 62 | 0 | 65 | 178 | 525 | 412 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g498600v5), mRNA | blastn | 3947 | 150 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 14222824 | 14222824 | PRJNA1087264_P_NODE_8132_length_221_cov_1.313953_g8050_i0 | PRJNA1087264 | 8132 | 221 | 1.313953 | 2.90383613 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 254 | 5e-63 | NTclustered | gi|167449|gb|M11448.1|CRETBA2A | 3055 | g8050 | i0 | 87.33 | 97.3665158371041 | 221 | 28 | 100 | 0 | 1 | 221 | 1159 | 1379 | Chlamydomonas reinhardtii alpha-2 tubulin gene, complete cds | blastn | 21518 | 254 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 15496680 | 15496680 | PRJNA1087264_P_NODE_15913_length_166_cov_0.871795_g15831_i0 | PRJNA1087264 | 15913 | 166 | 0.871795 | 1.4471797 | Monoraphidium neglectum | 145388 | Plants | Plants | 130 | 6.240000000000001e-26 | NTclustered | gi|926789746|ref|XM_014047893.1| | 145388 | g15831 | i0 | 80.838 | 78.1265060240964 | 167 | 30 | 100 | 2 | 1 | 166 | 1011 | 846 | Monoraphidium neglectum lysyl-tRNA synthetase, class II partial mRNA | blastn | 12969 | 130 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 20595131 | 20595131 | PRJNA1087264_P_NODE_2437_length_429_cov_1.855263_g2356_i0 | PRJNA1087264 | 2437 | 429 | 1.855263 | 7.95907827 | Volvox carteri | 3067 | Plants | Plants | 331 | 4.750000000000001e-86 | NTclustered | gi|302849325|ref|XM_002956147.1| | 3068 | g2356 | i0 | 81.01 | 57.3659673659674 | 416 | 79 | 97 | 0 | 12 | 427 | 1404 | 989 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_110003), mRNA | blastn | 24610 | 331 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 21419461 | 21419461 | PRJNA1087264_P_NODE_1597_length_531_cov_2.331950_g1518_i0 | PRJNA1087264 | 1597 | 531 | 2.33195 | 12.3826545 | Eukaryota | 2759 | Plants | Plants | 350 | 1.65e-91 | NTclustered | gi|2082260161|ref|XM_001690941.2| | 3055 | g1518 | i0 | 82.353 | 58.3389830508475 | 408 | 66 | 76 | 6 | 14 | 418 | 145 | 549 | Chlamydomonas reinhardtii ribosomal protein S23 (CHLRE_12g504200v5), mRNA | blastn | 30978 | 350 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii |
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);;