contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA285816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1646761 | 1646761 | PRJNA285816_S_NODE_18862_length_184_cov_1.540741_g18760_i0 | PRJNA285816 | 18862 | 184 | 1.540741 | 2.83496344 | Chlorella variabilis | 554065 | Plants | Plants | 122 | 1.1799999999999999e-23 | NTclustered | gi|552840787|ref|XM_005850079.1| | 554065 | g18760 | i0 | 91.111 | 1 | 90 | 8 | 49 | 0 | 12 | 101 | 146 | 57 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_59606) mRNA, complete cds | blastn | 184 | 122 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 11262346 | 11262346 | PRJNA285816_S_NODE_409_length_922_cov_23.387171_g359_i0 | PRJNA285816 | 409 | 922 | 23.387171 | 215.62971662 | Eukaryota | 2759 | Plants | Plants | 351 | 8.2e-92 | NTclustered | gi|1861356367|gb|MT377411.1| | 51329 | g359 | i0 | 77.467 | 51.6041214750542 | 608 | 124 | 65 | 12 | 173 | 773 | 97 | 698 | Polytomella parva clone 0016300147 40S ribosomal protein S2 (RPS2) mRNA, complete cds; plastid | blastn | 47579 | 351 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 11850802 | 11850802 | PRJNA285816_S_NODE_7910_length_253_cov_2.014706_g7808_i0 | PRJNA285816 | 7910 | 253 | 2.014706 | 5.09720618 | Volvox carteri | 3067 | Plants | Plants | 86.1 | 2.26e-12 | NTclustered | gi|302831072|ref|XM_002947056.1| | 3068 | g7808 | i0 | 90.625 | 0.25296442687747 | 64 | 6 | 25 | 0 | 2 | 65 | 87 | 150 | Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl39), partial mRNA | blastn | 64 | 86.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 14401140 | 14401140 | PRJNA285816_S_NODE_7752_length_255_cov_2.257282_g7650_i0 | PRJNA285816 | 7752 | 255 | 2.257282 | 5.7560691 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 215 | 2.79e-51 | NTclustered | gi|1102971032|gb|FJ196315.2| | 3075 | g7650 | i0 | 81.89 | 82.0470588235294 | 254 | 46 | 99 | 0 | 1 | 254 | 612 | 359 | Auxenochlorella protothecoides ribosomal protein S5 (RPS5) mRNA, partial cds | blastn | 20922 | 215 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 19497808 | 19497808 | PRJNA285816_S_NODE_10996_length_223_cov_1.494253_g10894_i0 | PRJNA285816 | 10996 | 223 | 1.494253 | 3.33218419 | Tetraselmis sp. CCMP 881 | 1812852 | Plants | Plants | 180 | 8.7e-41 | NTclustered | gi|1778428824|gb|MN642087.1| | 1812852 | g10894 | i0 | 81.333 | 70.8206278026906 | 225 | 38 | 100 | 3 | 1 | 223 | 41690 | 41912 | Tetraselmis sp. CCMP 881 mitochondrion, complete genome | blastn | 15793 | 180 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Tetraselmis | Tetraselmis sp. CCMP 881 | |
| 22048605 | 22048605 | PRJNA285816_S_NODE_6638_length_272_cov_1.098655_g6536_i0 | PRJNA285816 | 6638 | 272 | 1.098655 | 2.9883416 | Haematococcus lacustris | 44745 | Plants | Plants | 329 | 1.0299999999999998e-85 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g6536 | i0 | 89.961 | 396.055147058824 | 259 | 20 | 94 | 6 | 3 | 258 | 2928 | 2673 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 107727 | 329 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 22048610 | 22048610 | PRJNA285816_S_NODE_7018_length_266_cov_1.350230_g6916_i0 | PRJNA285816 | 7018 | 266 | 1.35023 | 3.5916118 | Chlamydomonas incerta | 51695 | Plants | Plants | 163 | 1.08e-35 | NTclustered | gi|74272608|gb|DQ122869.1| | 51695 | g6916 | i0 | 80 | 3.84210526315789 | 225 | 41 | 84 | 3 | 15 | 237 | 157 | 379 | Chlamydomonas incerta 40S ribosomal protein S8 mRNA, complete cds | blastn | 1022 | 163 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta |
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);;