contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA513467" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 486664 | 486664 | PRJNA513467_S_NODE_5921_length_170_cov_1.714286_g5898_i0 | PRJNA513467 | 5921 | 170 | 1.714286 | 2.9142862 | Pleodorina starrii | 330485 | Plants | Plants | 243 | 7.859999999999999e-60 | NTclustered | gi|484759769|ref|NC_021109.1| | 330485 | g5898 | i0 | 92.398 | 123.229411764706 | 171 | 11 | 100 | 2 | 1 | 170 | 123721 | 123890 | Pleodorina starrii plastid, complete genome | blastn | 20949 | 243 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pleodorina | Pleodorina starrii | |
| 3037709 | 3037709 | PRJNA513467_S_NODE_2063_length_250_cov_1.647887_g2040_i0 | PRJNA513467 | 2063 | 250 | 1.647887 | 4.1197175 | Picocystis salinarum | 88271 | Plants | Plants | 95.3 | 3.71e-15 | NTclustered | gi|371782106|emb|HE610138.1| | 88271 | g2040 | i0 | 90.278 | 27.172 | 72 | 7 | 29 | 0 | 1 | 72 | 2563 | 2492 | Picocystis salinarum 5.8S rRNA gene, 28S rRNA gene (partial) and ITS2, strain CCMP1897 | blastn | 6793 | 95.3 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Picocystophyceae | Picocystales | Picocystaceae | Picocystis | Picocystis salinarum | ||
| 5590482 | 5590482 | PRJNA513467_S_NODE_2665_length_226_cov_1.703704_g2642_i0 | PRJNA513467 | 2665 | 226 | 1.703704 | 3.85037104 | Paradoxia multiseta | 249350 | Plants | Plants | 372 | 1.36e-98 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g2642 | i0 | 96.46 | 100.681415929204 | 226 | 7 | 100 | 1 | 1 | 226 | 3579 | 3355 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 22754 | 372 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 8763894 | 8763894 | PRJNA513467_S_NODE_4067_length_194_cov_3.114650_g4044_i0 | PRJNA513467 | 4067 | 194 | 3.11465 | 6.042421 | Desmochloris | 138596 | Plants | Plants | 298 | 1.95e-76 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g4044 | i0 | 94.33 | 101.190721649485 | 194 | 11 | 100 | 0 | 1 | 194 | 985 | 792 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 19631 | 298 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 9414822 | 9414822 | PRJNA513467_S_NODE_2848_length_220_cov_32.595628_g2825_i0 | PRJNA513467 | 2848 | 220 | 32.595628 | 71.7103816 | uncultured Apatococcus | 1229086 | Plants | Plants | 407 | 3.61e-109 | NTclustered | gi|1031961072|gb|KX025113.1| | 1229086 | g2825 | i0 | 100 | 100.568181818182 | 220 | 0 | 100 | 0 | 1 | 220 | 1183 | 964 | Uncultured Apatococcus clone GOGs_K31 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 22125 | 407 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Apatococcus | ||||
| 12589843 | 12589843 | PRJNA513467_S_NODE_4890_length_182_cov_1.951724_g4867_i0 | PRJNA513467 | 4890 | 182 | 1.951724 | 3.55213768 | Chlorophyta | 3041 | Plants | Plants | 215 | 1.87e-51 | NTclustered | gi|725651062|ref|NC_025538.1| | 160069 | g4867 | i0 | 87.912 | 92.4725274725275 | 182 | 22 | 100 | 0 | 1 | 182 | 96810 | 96629 | Gloeotilopsis sterilis culture-collection UTEX:1704 chloroplast, complete genome | blastn | 16830 | 215 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Ulotrichaceae | Gloeotilopsis | Gloeotilopsis sterilis | |
| 13240570 | 13240570 | PRJNA513467_S_NODE_3191_length_212_cov_1.400000_g3168_i0 | PRJNA513467 | 3191 | 212 | 1.4 | 2.968 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 320 | 4.63e-83 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g3168 | i0 | 93.868 | 96.8632075471698 | 212 | 13 | 100 | 0 | 1 | 212 | 77 | 288 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 20535 | 320 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 15138955 | 15138955 | PRJNA513467_S_NODE_3432_length_206_cov_2.443787_g3409_i0 | PRJNA513467 | 3432 | 206 | 2.443787 | 5.03420122 | Chloroidium | 1034479 | Plants | Plants | 348 | 2.05e-91 | NTclustered | gi|694226606|gb|KM116463.1| | 63675 | g3409 | i0 | 97.101 | 99.5436893203884 | 207 | 4 | 100 | 2 | 1 | 206 | 2670 | 2465 | Chloroidium angustoellipsoideum strain SAG 2041 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 20506 | 348 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium angustoellipsoideum | |
| 16413585 | 16413585 | PRJNA513467_S_NODE_933_length_340_cov_3.042904_g910_i0 | PRJNA513467 | 933 | 340 | 3.042904 | 10.3458736 | Heterochlamydomonas | 179865 | Plants | Plants | 401 | 2.769999999999999e-107 | NTclustered | gi|33945399|gb|AY206708.1| | 179866 | g910 | i0 | 88.012 | 100.85 | 342 | 37 | 100 | 4 | 1 | 340 | 1802 | 1463 | Heterochlamydomonas inaequalis UTEX 1705 28S ribosomal RNA gene, partial sequence | blastn | 34289 | 401 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Heterochlamydomonas | Heterochlamydomonas inaequalis | |
| 20888760 | 20888760 | PRJNA513467_S_NODE_3017_length_216_cov_2.379888_g2994_i0 | PRJNA513467 | 3017 | 216 | 2.379888 | 5.14055808 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 339 | 1.3099999999999998e-88 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g2994 | i0 | 94.907 | 100.935185185185 | 216 | 11 | 100 | 0 | 1 | 216 | 3042 | 2827 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 21802 | 339 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 22163461 | 22163461 | PRJNA513467_S_NODE_2778_length_222_cov_2.886486_g2755_i0 | PRJNA513467 | 2778 | 222 | 2.886486 | 6.40799892 | Chloroidium sp. KL-2023a | 3031248 | Plants | Plants | 222 | 1.42e-53 | NTclustered | gi|2450595352|gb|ON986219.1| | 3031248 | g2755 | i0 | 96.992 | 17.7432432432432 | 133 | 3 | 60 | 1 | 1 | 133 | 220025 | 219894 | Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome | blastn | 3939 | 222 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. KL-2023a |
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);;