contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA436017" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5534333 | 5534333 | PRJNA436017_P_NODE_12365_length_240_cov_3.413793_g12067_i0 | PRJNA436017 | 12365 | 240 | 3.413793 | 8.1931032 | Pantachogon haeckeli | 168769 | Cnidaria | other_Eukaryota | 145 | 3.46e-30 | NTclustered | gi|270271848|gb|GQ120079.1| | 168769 | g12067 | i0 | 82.249 | 68.325 | 169 | 28 | 70 | 2 | 1 | 168 | 535 | 702 | Pantachogon haeckeli cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 16398 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Trachymedusae | Rhopalonematidae | Pantachogon | Pantachogon haeckeli | |
| 10634733 | 10634733 | PRJNA436017_P_NODE_25769_length_160_cov_4.024390_g25471_i0 | PRJNA436017 | 25769 | 160 | 4.02439 | 6.439024 | Stylobates loisetteae | 2601840 | Cnidaria | other_Eukaryota | 169 | 1.26e-37 | NTclustered | gi|1720101249|gb|MN266882.1| | 2601840 | g25471 | i0 | 86.452 | 9.7125 | 155 | 20 | 96 | 1 | 7 | 160 | 2935 | 2781 | Stylobates loisetteae isolate Stylo large subunit ribosomal RNA gene, partial sequence | blastn | 1554 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Stylobates | Stylobates loisetteae | |
| 18940478 | 18940478 | PRJNA436017_P_NODE_15135_length_213_cov_1.943182_g14837_i0 | PRJNA436017 | 15135 | 213 | 1.943182 | 4.13897766 | Rhizostomeae | 37535 | Cnidaria | other_Eukaryota | 132 | 2.34e-26 | NTclustered | gi|2862235116|gb|PQ647263.1| | 880218 | g14837 | i0 | 89.091 | 47.4647887323944 | 110 | 7 | 51 | 5 | 17 | 124 | 6892 | 6786 | Cephea cephea isolate AGC18069 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 | 10110 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Cepheidae | Cephea | Cephea cephea | |
| 22107427 | 22107427 | PRJNA436017_P_NODE_24618_length_164_cov_2.070866_g24320_i0 | PRJNA436017 | 24618 | 164 | 2.070866 | 3.39622024 | Clytia sp. JRH-2014 | 1483203 | Cnidaria | other_Eukaryota | 159 | 7.84e-35 | NTclustered | gi|608606329|gb|KF962101.1| | 1483203 | g24320 | i0 | 86.486 | 90.9939024390244 | 148 | 16 | 89 | 4 | 1 | 146 | 282 | 137 | Clytia sp. JRH-2014 voucher XMCL1 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 14923 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia sp. JRH-2014 |
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);;