contig_metadata
8 rows where bioproject = "PRJNA526367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3047151 | 3047151 | PRJNA526367_P_NODE_50083_length_167_cov_3.601695_g49873_i0 | PRJNA526367 | 50083 | 167 | 3.601695 | 6.01483065 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 268 | 1.28e-67 | NTclustered | gi|1360638129|gb|AC277064.1| | 574566 | g49873 | i0 | 97.468 | 81.3473053892216 | 158 | 3 | 94 | 1 | 8 | 164 | 1418 | 1261 | Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence | blastn | 13585 | 268 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 7491874 | 7491874 | PRJNA526367_P_NODE_41226_length_181_cov_1.303030_g41016_i0 | PRJNA526367 | 41226 | 181 | 1.30303 | 2.3584843 | Eukaryota | 2759 | Plants | Plants | 228 | 2.379999999999999e-55 | NTclustered | gi|2568387962|gb|MZ452236.2| | 43260 | g41016 | i0 | 94.558 | 55.7237569060773 | 147 | 8 | 81 | 0 | 8 | 154 | 44 | 190 | Rhexinema paucicellulare isolate MD1 large subunit ribosomal RNA gene, partial sequence | blastn | 10086 | 228 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Helicodictyaceae | Rhexinema | Rhexinema paucicellulare | |
| 15142084 | 15142084 | PRJNA526367_P_NODE_63032_length_154_cov_4.847619_g62822_i0 | PRJNA526367 | 63032 | 154 | 4.847619 | 7.46533326 | Monostromataceae | 153902 | Plants | Plants | 250 | 4.18e-62 | NTclustered | gi|2473930131|ref|NC_072924.1| | 138667 | g62822 | i0 | 97.279 | 140.272727272727 | 147 | 4 | 95 | 0 | 1 | 147 | 176716 | 176570 | Monostroma nitidum chloroplast, complete genome | blastn | 21602 | 250 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Monostromataceae | Monostroma | Monostroma nitidum | |
| 17073362 | 17073362 | PRJNA526367_P_NODE_46654_length_172_cov_2.487805_g46444_i0 | PRJNA526367 | 46654 | 172 | 2.487805 | 4.2790246 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 182 | 1.76e-41 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g46444 | i0 | 86.957 | 1.86627906976744 | 161 | 21 | 94 | 0 | 3 | 163 | 3641 | 3481 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 321 | 182 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 17691939 | 17691939 | PRJNA526367_P_NODE_65974_length_150_cov_8.475248_g65764_i0 | PRJNA526367 | 65974 | 150 | 8.475248 | 12.712872 | Chlorellaceae | 35461 | Plants | Plants | 246 | 5.2199999999999995e-61 | NTclustered | gi|1798226562|gb|MN960174.1| | 3079 | g65764 | i0 | 99.265 | 90.6533333333333 | 136 | 1 | 91 | 0 | 7 | 142 | 580 | 715 | Chlorella sp. strain str193-2.5 small subunit ribosomal RNA gene, partial sequence | blastn | 13598 | 246 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 23448492 | 23448492 | PRJNA526367_P_NODE_4659_length_336_cov_3.153310_g4450_i0 | PRJNA526367 | 4659 | 336 | 3.15331 | 10.5951216 | Blidingia sp. DT1 | 2022611 | Plants | Plants | 226 | 1.76e-54 | NTclustered | gi|1220117795|gb|KY401415.1| | 2022611 | g4450 | i0 | 100 | 45.0982142857143 | 122 | 0 | 65 | 0 | 208 | 329 | 2425 | 2304 | Blidingia sp. DT1 28S ribosomal RNA gene, partial sequence | blastn | 15153 | 226 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Blidingia | Blidingia sp. DT1 | |
| 31166537 | 31166537 | PRJNA526367_P_NODE_14535_length_324_cov_2.956364_g14326_i0 | PRJNA526367 | 14535 | 324 | 2.956364 | 9.57861936 | Chlamydomonadaceae | 3051 | Plants | Plants | 45.1 | 0.0148 | NR | KAG2482428.1 | 47281 | g14326 | i0 | 63.3 | 0.537037037037037 | 30 | 11 | 27.8 | 0 | 8 | 97 | 708 | 737 | KAG2482428.1 hypothetical protein HYH03_018632 [Edaphochlamys debaryana] | diamond | 174 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 31767701 | 31767701 | PRJNA526367_P_NODE_43517_length_177_cov_2.273438_g43307_i0 | PRJNA526367 | 43517 | 177 | 2.273438 | 4.02398526 | Chlorella | 3071 | Plants | Plants | 43.9 | 0.00601 | NR | PRW56290.1 | 3076 | g43307 | i0 | 71.4 | 1.20338983050847 | 35 | 10 | 59.3 | 0 | 118 | 14 | 28 | 62 | PRW56290.1 CHY zinc finger [Chlorella sorokiniana] | diamond | 213 | 44.3 | 0.99097065462754 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana |
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);;