contig_metadata
8 rows where bioproject = "PRJNA637328" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11358558 | 11358558 | PRJNA637328_S_NODE_2789_length_191_cov_4.844156_g2712_i0 | PRJNA637328 | 2789 | 191 | 4.844156 | 9.25233796 | Choricystis | 41299 | Plants | Plants | 69.4 | 1.63e-7 | NTclustered | gi|1467029762|gb|MH818560.1| | 41300 | g2712 | i0 | 89.091 | 1.43979057591623 | 55 | 6 | 29 | 0 | 1 | 55 | 339 | 393 | Choricystis parasitica isolate BUCH09 large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 275 | 69.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Choricystis | Choricystis parasitica | |||
| 12088614 | 12088614 | PRJNA637328_S_NODE_4090_length_154_cov_0.991453_g4013_i0 | PRJNA637328 | 4090 | 154 | 0.991453 | 1.52683762 | Trebouxia lynnae | 1825957 | Plants | Plants | 263 | 5.36e-66 | NTclustered | gi|1016111943|gb|KU716051.1| | 1825957 | g4013 | i0 | 97.419 | 2.01298701298701 | 155 | 3 | 100 | 1 | 1 | 154 | 6992 | 6838 | Trebouxia lynnae 26S-18S intergenic spacer region, partial sequence; 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence; and 26S-18S rRNA intergenic spacer region, partial sequence | blastn | 310 | 263 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 18461283 | 18461283 | PRJNA637328_S_NODE_1515_length_291_cov_1.519685_g1438_i0 | PRJNA637328 | 1515 | 291 | 1.519685 | 4.42228335 | Stichococcus bacillaris | 37433 | Plants | Plants | 291 | 5.25e-74 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g1438 | i0 | 98.193 | 12.0343642611684 | 166 | 3 | 57 | 0 | 3 | 168 | 7017 | 7182 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 3502 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 19735664 | 19735664 | PRJNA637328_P_NODE_12536_length_272_cov_6.439462_g12060_i0 | PRJNA637328 | 12536 | 272 | 6.439462 | 17.51533664 | Desmochloris mollenhaueri | 578869 | Plants | Plants | 503 | 5.729999999999998e-138 | NTclustered | gi|313476264|emb|FM882217.1| | 578869 | g12060 | i0 | 100 | 99.9411764705882 | 272 | 0 | 100 | 0 | 1 | 272 | 680 | 951 | Desmochloris sp. TP-2008 partial 18S rRNA gene, ITS1, 5.8S rRNA and ITS2, strain CCAP 6006/2 | blastn | 27184 | 503 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris mollenhaueri | |
| 22832551 | 22832551 | PRJNA637328_S_NODE_3418_length_169_cov_2.136364_g3341_i0 | PRJNA637328 | 3418 | 169 | 2.136364 | 3.61045516 | Chlamydomonas | 3052 | Plants | Plants | 268 | 1.29e-67 | NTclustered | gi|288662|emb|Z15151.1| | 3059 | g3341 | i0 | 95.783 | 121.059171597633 | 166 | 7 | 98 | 0 | 4 | 169 | 2297 | 2132 | Chloroplast Chlamydomonas gelatinosa rrnL gene | blastn | 20459 | 268 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas gelatinosa | |
| 24835507 | 24835507 | PRJNA637328_S_NODE_2880_length_188_cov_1.192053_g2803_i0 | PRJNA637328 | 2880 | 188 | 1.192053 | 2.24105964 | Desmodesmus sp. DJ-2023b | 3074319 | Plants | Plants | 331 | 1.85e-86 | NTclustered | gi|2575202439|gb|OR533329.1| | 3074319 | g2803 | i0 | 98.404 | 100.010638297872 | 188 | 3 | 100 | 0 | 1 | 188 | 4216 | 4403 | Desmodesmus sp. DJ-2023b culture FBCC:A0719 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 18802 | 331 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Desmodesmus | Desmodesmus sp. DJ-2023b | |
| 27238977 | 27238977 | PRJNA637328_P_NODE_5723_length_367_cov_5.198113_g5248_i0 | PRJNA637328 | 5723 | 367 | 5.198113 | 19.07707471 | Monoraphidium minutum | 39955 | Plants | Plants | 44.7 | 0.0195 | NR | KAI8473342.1 | 39955 | g5248 | i0 | 37.5 | 0.653950953678474 | 80 | 46 | 64.6 | 3 | 65 | 301 | 13 | 89 | KAI8473342.1 MAG: hypothetical protein J3K34DRAFT_411070 [Monoraphidium minutum] | diamond | 240 | 44.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 27776146 | 27776146 | PRJNA637328_P_NODE_6264_length_352_cov_7.059406_g5789_i0 | PRJNA637328 | 6264 | 352 | 7.059406 | 24.84910912 | Monoraphidium minutum | 39955 | Plants | Plants | 44.7 | 0.0171 | NR | KAI8473342.1 | 39955 | g5789 | i0 | 37.5 | 0.681818181818182 | 80 | 46 | 67.3 | 3 | 65 | 301 | 13 | 89 | KAI8473342.1 MAG: hypothetical protein J3K34DRAFT_411070 [Monoraphidium minutum] | diamond | 240 | 44.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum |
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);;