contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA446034" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2988915 | 2988915 | PRJNA446034_S_NODE_51123_length_182_cov_11.241379_g51086_i0 | PRJNA446034 | 51123 | 182 | 11.241379 | 20.45930978 | Pseudochlorella signiensis | 173497 | Plants | Plants | 274 | 3.03e-69 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g51086 | i0 | 93.923 | 113.016483516484 | 181 | 11 | 99 | 0 | 2 | 182 | 150023 | 150203 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 20569 | 274 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 11917101 | 11917101 | PRJNA446034_S_NODE_72550_length_168_cov_2.282443_g72513_i0 | PRJNA446034 | 72550 | 168 | 2.2824430000000002 | 3.83450424 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 248 | 1.68e-61 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g72513 | i0 | 93.413 | 97.3095238095238 | 167 | 11 | 99 | 0 | 2 | 168 | 110 | 276 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 16348 | 248 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 13191712 | 13191712 | PRJNA446034_S_NODE_23911_length_217_cov_2.366667_g23874_i0 | PRJNA446034 | 23911 | 217 | 2.366667 | 5.13566739 | Trebouxia lynnae | 1825957 | Plants | Plants | 374 | 3.6e-99 | NTclustered | gi|1812100161|ref|NC_045839.1| | 1825957 | g23874 | i0 | 97.696 | 84.7188940092166 | 217 | 5 | 100 | 0 | 1 | 217 | 195691 | 195475 | Trebouxia sp. TR9 chloroplast, partial genome | blastn | 18384 | 374 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 18289665 | 18289665 | PRJNA446034_S_NODE_10175_length_261_cov_5.754464_g10138_i0 | PRJNA446034 | 10175 | 261 | 5.754464 | 15.01915104 | Nannochloris normandinae | 926285 | Plants | Plants | 483 | 7.12e-132 | NTclustered | gi|922575245|gb|JQ921007.1| | 926285 | g10138 | i0 | 100 | 97.7892720306513 | 261 | 0 | 100 | 0 | 1 | 261 | 826 | 566 | Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 25523 | 483 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris normandinae | |
| 18289728 | 18289728 | PRJNA446034_S_NODE_13155_length_247_cov_2.923810_g13118_i0 | PRJNA446034 | 13155 | 247 | 2.92381 | 7.2218107 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 158 | 4.6e-34 | NTclustered | gi|545366309|ref|XM_005648003.1| | 574566 | g13118 | i0 | 79.654 | 15.1497975708502 | 231 | 38 | 94 | 7 | 3 | 233 | 2393 | 2614 | Coccomyxa subellipsoidea C-169 V0/A0 complex, 116-kDa subunit of ATPase mRNA | blastn | 3742 | 158 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 19563975 | 19563975 | PRJNA446034_S_NODE_27596_length_210_cov_4.572254_g27559_i0 | PRJNA446034 | 27596 | 210 | 4.572254 | 9.6017334 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 132 | 2.3e-26 | NTclustered | gi|2917929625|emb|OZ234913.1| | 3350044 | g27559 | i0 | 86.614 | 3.97619047619048 | 127 | 8 | 59 | 4 | 30 | 153 | 1311504 | 1311384 | Trebouxia sp. SL0000003 genome assembly, chromosome: 8 | blastn | 835 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 19564209 | 19564209 | PRJNA446034_S_NODE_83816_length_162_cov_2.752000_g83779_i0 | PRJNA446034 | 83816 | 162 | 2.752 | 4.45824 | uncultured Planophila | 1586189 | Plants | Plants | 289 | 9.44e-74 | NTclustered | gi|2515376631|gb|OR101488.1| | 1586189 | g83779 | i0 | 98.765 | 92.2901234567901 | 162 | 2 | 100 | 0 | 1 | 162 | 1143 | 982 | Uncultured Planophila clone SchF170815_mgcl52 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 14951 | 289 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | uncultured Planophila | |||
| 20839610 | 20839610 | PRJNA446034_S_NODE_10097_length_262_cov_1.875556_g10060_i0 | PRJNA446034 | 10097 | 262 | 1.875556 | 4.91395672 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 313 | 9.93e-81 | NTclustered | gi|2917929689|emb|OZ234917.1| | 3350044 | g10060 | i0 | 88.889 | 0.99618320610687 | 261 | 19 | 98 | 9 | 1 | 256 | 1719355 | 1719100 | Trebouxia sp. SL0000003 genome assembly, chromosome: 12 | blastn | 261 | 313 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 22114751 | 22114751 | PRJNA446034_S_NODE_4018_length_323_cov_5.122378_g3981_i0 | PRJNA446034 | 4018 | 323 | 5.122378 | 16.54528094 | Ulva compressa | 63659 | Plants | Plants | 268 | 2.7699999999999998e-67 | NTclustered | gi|2043344467|gb|MW353781.1| | 63659 | g3981 | i0 | 86.345 | 100.743034055728 | 249 | 31 | 77 | 2 | 70 | 318 | 69276 | 69521 | Ulva compressa isolate Uco3 plastid, complete genome | blastn | 32540 | 268 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva compressa |
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);;