contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB11523" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2257746 | 2257746 | PRJEB11523_P_NODE_4482_length_224_cov_1.051429_g4404_i0 | PRJEB11523 | 4482 | 224 | 1.051429 | 2.35520096 | Coccomyxa | 41891 | Plants | Plants | 337 | 4.909999999999999e-88 | NTclustered | gi|1601875646|gb|MK694759.1| | 2315456 | g4404 | i0 | 93.75 | 100.133928571429 | 224 | 14 | 100 | 0 | 1 | 224 | 4299 | 4076 | Coccomyxa sp. Obi 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 | 22430 | 337 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 11491741 | 11491741 | PRJEB11523_P_NODE_6450_length_181_cov_2.840909_g6372_i0 | PRJEB11523 | 6450 | 181 | 2.840909 | 5.14204529 | Chlorogonium euchlorum | 52028 | Plants | Plants | 281 | 1.8e-71 | NTclustered | gi|2324954163|gb|OP597711.1| | 52028 | g6372 | i0 | 97.576 | 3.19337016574586 | 165 | 2 | 91 | 2 | 18 | 181 | 3675 | 3838 | Chlorogonium euchlorum chloroplast, partial genome | blastn | 578 | 281 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Chlorogonium | Chlorogonium euchlorum | |
| 15315964 | 15315964 | PRJEB11523_P_NODE_3153_length_281_cov_16.797414_g3075_i0 | PRJEB11523 | 3153 | 281 | 16.797414 | 47.20073334 | Pithophora roettleri | 926344 | Plants | Plants | 111 | 4.21e-20 | NTclustered | gi|1678088264|gb|MN017042.1| | 926344 | g3075 | i0 | 85.714 | 10.2491103202847 | 105 | 15 | 37 | 0 | 23 | 127 | 3922 | 4026 | Pithophora roettleri isolate Ogeechee 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 | 2880 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Pithophoraceae | Pithophora | Pithophora roettleri | |
| 19139233 | 19139233 | PRJEB11523_P_NODE_2116_length_371_cov_34.149068_g2038_i0 | PRJEB11523 | 2116 | 371 | 34.149068 | 126.69304228 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 569 | 7.88e-158 | NTclustered | gi|2917929623|emb|OZ234911.1| | 3350044 | g2038 | i0 | 100 | 0.830188679245283 | 308 | 0 | 83 | 0 | 41 | 348 | 1745611 | 1745918 | Trebouxia sp. SL0000003 genome assembly, chromosome: 6 | blastn | 308 | 569 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 24239651 | 24239651 | PRJEB11523_P_NODE_4140_length_235_cov_2.010753_g4062_i0 | PRJEB11523 | 4140 | 235 | 2.010753 | 4.72526955 | uncultured Apatococcus | 1229086 | Plants | Plants | 429 | 8.33e-116 | NTclustered | gi|1031961068|gb|KX025109.1| | 1229086 | g4062 | i0 | 99.574 | 99.9574468085106 | 235 | 1 | 100 | 0 | 1 | 235 | 1485 | 1251 | Uncultured Apatococcus clone GOGs_K08 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 | 23490 | 429 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Apatococcus | ||||
| 24239656 | 24239656 | PRJEB11523_P_NODE_4820_length_214_cov_14.521212_g4742_i0 | PRJEB11523 | 4820 | 214 | 14.521212 | 31.07539368 | Hazenia capsulata | 2202518 | Plants | Plants | 213 | 8.17e-51 | NTclustered | gi|17028245|gb|L42837.1|CMKCPRGOL | 2202518 | g4742 | i0 | 92.568 | 129.981308411215 | 148 | 11 | 69 | 0 | 24 | 171 | 1337 | 1484 | Hazenia capsulata large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 27816 | 213 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Hazeniaceae | Hazenia | Hazenia capsulata | |
| 25208594 | 25208594 | PRJEB11523_P_NODE_8340_length_162_cov_4.530973_g8262_i0 | PRJEB11523 | 8340 | 162 | 4.530973 | 7.34017626 | Selenastraceae | 35466 | Plants | Plants | 272 | 9.51e-69 | NTclustered | gi|523583551|gb|KC145448.1| | 52960 | g8262 | i0 | 98.693 | 94.6172839506173 | 153 | 2 | 94 | 0 | 10 | 162 | 138 | 290 | Ankistrodesmus falcatus strain UTEX 101 28S ribosomal RNA gene, partial sequence | blastn | 15328 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Ankistrodesmus | Ankistrodesmus falcatus |
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);;