contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB81171" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139376 | 139376 | PRJEB81171_P_NODE_4781_length_304_cov_2.870130_g4654_i0 | PRJEB81171 | 4781 | 304 | 2.87013 | 8.7251952 | Volvox carteri | 3067 | Plants | Plants | 148 | 3.5099999999999993e-31 | NTclustered | gi|302843775|ref|XM_002953383.1| | 3068 | g4654 | i0 | 84.932 | 36.1052631578947 | 146 | 22 | 48 | 0 | 11 | 156 | 210 | 65 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_105955), partial mRNA | blastn | 10976 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 2271791 | 2271791 | PRJEB81171_P_NODE_5302_length_290_cov_1.686636_g5175_i0 | PRJEB81171 | 5302 | 290 | 1.686636 | 4.8912444 | Trebouxia | 13786 | Plants | Plants | 531 | 2.83e-146 | NTclustered | gi|49781197|gb|AY648107.1| | 283661 | g5175 | i0 | 99.655 | 100.555172413793 | 290 | 1 | 100 | 0 | 1 | 290 | 1790 | 1501 | Trebouxia sp. Wei 22-c 26S ribosomal RNA gene, partial sequence | blastn | 29161 | 536 | 0.990671641791045 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. Wei 22-c | |
| 5242016 | 5242016 | PRJEB81171_P_NODE_4985_length_298_cov_1.688889_g4858_i0 | PRJEB81171 | 4985 | 298 | 1.688889 | 5.03288922 | Polytomella parva | 51329 | Plants | Plants | 195 | 4.35e-45 | NTclustered | gi|1861356367|gb|MT377411.1| | 51329 | g4858 | i0 | 80.62 | 11.0302013422819 | 258 | 44 | 86 | 6 | 1 | 255 | 297 | 551 | Polytomella parva clone 0016300147 40S ribosomal protein S2 (RPS2) mRNA, complete cds; plastid | blastn | 3287 | 195 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 12892871 | 12892871 | PRJEB81171_P_NODE_3851_length_338_cov_1.052830_g3724_i0 | PRJEB81171 | 3851 | 338 | 1.05283 | 3.5585654 | Chloromonas sp. ANT3 | 55215 | Plants | Plants | 279 | 1.34e-70 | NTclustered | gi|2625153|gb|AF032877.1| | 55215 | g3724 | i0 | 82.282 | 95.0414201183432 | 333 | 49 | 97 | 9 | 1 | 328 | 1837 | 2164 | Chloromonas sp. ANT3 alpha-tubulin (tuba1) gene, complete cds | blastn | 32124 | 279 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chloromonas | Chloromonas sp. ANT3 | |
| 19264951 | 19264951 | PRJEB81171_P_NODE_5316_length_290_cov_1.364055_g5189_i0 | PRJEB81171 | 5316 | 290 | 1.364055 | 3.9557595 | Stichococcus bacillaris | 37433 | Plants | Plants | 300 | 8.69e-77 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g5189 | i0 | 96.667 | 13.3758620689655 | 180 | 6 | 62 | 0 | 1 | 180 | 7003 | 7182 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 3879 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 21816218 | 21816218 | PRJEB81171_P_NODE_7998_length_251_cov_1.606742_g7871_i0 | PRJEB81171 | 7998 | 251 | 1.606742 | 4.03292242 | uncultured Trebouxia photobiont | 285713 | Plants | Plants | 431 | 2.4999999999999996e-116 | NTclustered | gi|94448749|emb|AJ969577.1| | 285713 | g7871 | i0 | 97.61 | 88.9840637450199 | 251 | 6 | 100 | 0 | 1 | 251 | 1465 | 1715 | Uncultured Trebouxia photobiont 18S rRNA gene (partial), ITS1, 5.8S rRNA gene, ITS2 and 26S rRNA gene (partial), isolate L-265-II | blastn | 22335 | 431 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 23091421 | 23091421 | PRJEB81171_P_NODE_7159_length_260_cov_1.941176_g7032_i0 | PRJEB81171 | 7159 | 260 | 1.941176 | 5.0470576 | Trebouxia sp. ex Placidium sp. PJ-2019a | 2571973 | Plants | Plants | 475 | 1.1899999999999999e-129 | NTclustered | gi|1691252205|emb|LR586036.1| | 2571973 | g7032 | i0 | 99.617 | 100.3 | 261 | 0 | 100 | 1 | 1 | 260 | 159 | 419 | Trebouxia sp. ex Placidium sp. PJ-2019a partial 26S rRNA gene, isolate Trebouxia sp. pj16 ex Placidium sp. PJ-2019a | blastn | 26078 | 475 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. ex Placidium sp. PJ-2019a |
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);;