contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA407886" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4244873 | 4244873 | PRJNA407886_P_NODE_61384_length_270_cov_4.781726_g59690_i0 | PRJNA407886 | 61384 | 270 | 4.781726 | 12.9106602 | Chlamydomonas incerta | 51695 | Plants | Plants | 115 | 3.11e-21 | NTclustered | gi|74272608|gb|DQ122869.1| | 51695 | g59690 | i0 | 82.946 | 0.477777777777778 | 129 | 20 | 47 | 2 | 87 | 214 | 502 | 629 | Chlamydomonas incerta 40S ribosomal protein S8 mRNA, complete cds | blastn | 129 | 115 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 5521644 | 5521644 | PRJNA407886_P_NODE_63765_length_264_cov_2.968586_g62071_i0 | PRJNA407886 | 63765 | 264 | 2.968586 | 7.83706704 | Dunaliella sp. KU22 | 1545437 | Plants | Plants | 291 | 4.69e-74 | NTclustered | gi|685431495|gb|KM033846.1| | 1545437 | g62071 | i0 | 86.641 | 95.9393939393939 | 262 | 35 | 99 | 0 | 1 | 262 | 92 | 353 | Dunaliella sp. KU22 alpha-tubulin protein (ATUB) mRNA, partial cds | blastn | 25328 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella sp. KU22 | |
| 6794573 | 6794573 | PRJNA407886_P_NODE_16926_length_652_cov_3.412781_g15269_i0 | PRJNA407886 | 16926 | 652 | 3.412781 | 22.25133212 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 335 | 5.749999999999999e-87 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g15269 | i0 | 77.526 | 74.6503067484663 | 574 | 117 | 87 | 11 | 67 | 634 | 857 | 290 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 48672 | 335 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 8734615 | 8734615 | PRJNA407886_P_NODE_11567_length_883_cov_2.020988_g10177_i0 | PRJNA407886 | 11567 | 883 | 2.020988 | 17.84532404 | Chlamydomonas | 3052 | Plants | Plants | 403 | 2.1299999999999992e-107 | NTclustered | gi|2082247947|ref|XM_001698013.2| | 3055 | g10177 | i0 | 77.131 | 30.1868629671574 | 739 | 142 | 82 | 22 | 123 | 846 | 924 | 198 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g278222v5), mRNA | blastn | 26655 | 403 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 9344947 | 9344947 | PRJNA407886_P_NODE_13088_length_802_cov_3.463649_g11595_i0 | PRJNA407886 | 13088 | 802 | 3.463649 | 27.77846498 | Chlamydomonas incerta | 51695 | Plants | Plants | 315 | 9.3e-81 | NTclustered | gi|74272614|gb|DQ122872.1| | 51695 | g11595 | i0 | 78.113 | 7.56359102244389 | 530 | 92 | 64 | 19 | 291 | 802 | 956 | 433 | Chlamydomonas incerta mitochondrial ADP/ATP translocator (ANT) mRNA, complete cds; nuclear gene for mitochondrial product | blastn | 6066 | 315 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 9344999 | 9344999 | PRJNA407886_P_NODE_15268_length_709_cov_3.820755_g13656_i0 | PRJNA407886 | 15268 | 709 | 3.820755 | 27.08915295 | Scherffelia dubia | 3190 | Plants | Plants | 75 | 1.51e-8 | NTclustered | gi|1783497212|ref|NC_045363.1| | 3190 | g13656 | i0 | 77.536 | 7.72637517630465 | 138 | 21 | 19 | 9 | 121 | 250 | 31508 | 31373 | Scherffelia dubia culture SAG:17.86 mitochondrion, complete genome | blastn | 5478 | 75 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Scherffelia | Scherffelia dubia | |
| 11896766 | 11896766 | PRJNA407886_P_NODE_66250_length_258_cov_4.362162_g64556_i0 | PRJNA407886 | 66250 | 258 | 4.362162 | 11.25437796 | Monoraphidium neglectum | 145388 | Plants | Plants | 63.9 | 1.08e-5 | NTclustered | gi|926791790|ref|XM_014048915.1| | 145388 | g64556 | i0 | 82.667 | 1.5 | 75 | 10 | 28 | 2 | 81 | 152 | 1112 | 1186 | Monoraphidium neglectum WD repeat, SAM and U-box domain-containing protein 1 mRNA | blastn | 387 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 16994868 | 16994868 | PRJNA407886_P_NODE_40614_length_343_cov_2.607407_g38920_i0 | PRJNA407886 | 40614 | 343 | 2.607407 | 8.94340601 | Chlorella variabilis | 554065 | Plants | Plants | 89.8 | 2.47e-13 | NTclustered | gi|552839615|ref|XM_005849780.1| | 554065 | g38920 | i0 | 78.322 | 2.35860058309038 | 143 | 27 | 41 | 4 | 44 | 184 | 121 | 261 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_143002) mRNA, complete cds | blastn | 809 | 89.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 18268963 | 18268963 | PRJNA407886_P_NODE_40515_length_344_cov_1.321033_g38821_i0 | PRJNA407886 | 40515 | 344 | 1.321033 | 4.54435352 | Chlamydomonas sp. ICE-L | 309537 | Plants | Plants | 195 | 5.11e-45 | NTclustered | gi|1433048021|gb|MF780877.1| | 309537 | g38821 | i0 | 77.581 | 94.0872093023256 | 339 | 65 | 97 | 9 | 1 | 333 | 1336 | 1003 | Chlamydomonas sp. ICE-L heat shock protein 70A (HSP70A) mRNA, partial cds | blastn | 32366 | 195 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. ICE-L | |
| 20818733 | 20818733 | PRJNA407886_P_NODE_26417_length_458_cov_3.420779_g24725_i0 | PRJNA407886 | 26417 | 458 | 3.420779 | 15.66716782 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 553 | 9.989999999999996e-153 | NTclustered | gi|167449|gb|M11448.1|CRETBA2A | 3055 | g24725 | i0 | 88.428 | 99.8449781659389 | 458 | 53 | 100 | 0 | 1 | 458 | 1365 | 908 | Chlamydomonas reinhardtii alpha-2 tubulin gene, complete cds | blastn | 45729 | 553 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22093952 | 22093952 | PRJNA407886_P_NODE_47278_length_314_cov_1.825726_g45584_i0 | PRJNA407886 | 47278 | 314 | 1.825726 | 5.73277964 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 58.4 | 6.31e-4 | NTclustered | gi|2082238366|ref|XM_043059241.1| | 3055 | g45584 | i0 | 89.13 | 0.146496815286624 | 46 | 5 | 15 | 0 | 137 | 182 | 1556 | 1511 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g081250v5), mRNA | blastn | 46 | 58.4 | 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);;