contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA690124" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 669533 | 669533 | PRJNA690124_P_NODE_45041_length_251_cov_2.471910_g44675_i0 | PRJNA690124 | 45041 | 251 | 2.47191 | 6.2044941 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 459 | 1.1499999999999996e-124 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g44675 | i0 | 99.602 | 57.7450199203187 | 251 | 1 | 100 | 0 | 1 | 251 | 1075 | 825 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 14494 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 1945561 | 1945561 | PRJNA690124_P_NODE_44522_length_252_cov_0.871508_g44156_i0 | PRJNA690124 | 44522 | 252 | 0.871508 | 2.19620016 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|1524878282|ref|XM_027190912.1| | 46731 | g44156 | i0 | 100 | 0.111111111111111 | 28 | 0 | 11 | 0 | 53 | 80 | 3227 | 3254 | PREDICTED: Pocillopora damicornis ribosome-binding protein 1-like (LOC113674431), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 14697725 | 14697725 | PRJNA690124_P_NODE_10232_length_502_cov_1.606061_g9867_i0 | PRJNA690124 | 10232 | 502 | 1.606061 | 8.06242622 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 71.3 | 1.35e-7 | NTclustered | gi|2782887107|ref|XM_067065305.1| | 252671 | g9867 | i0 | 82.716 | 0.51593625498008 | 81 | 12 | 16 | 2 | 319 | 398 | 386 | 465 | PREDICTED: Clytia hemisphaerica cathepsin L-like (LOC136808767), mRNA | blastn | 259 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 14697782 | 14697782 | PRJNA690124_P_NODE_12772_length_450_cov_1.663130_g12407_i0 | PRJNA690124 | 12772 | 450 | 1.66313 | 7.484085 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 826 | 0 | NTclustered | gi|681870005|gb|KM001688.1| | 1542451 | g12407 | i0 | 99.778 | 56.2177777777778 | 450 | 1 | 100 | 0 | 1 | 450 | 1265 | 1714 | Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence | blastn | 25298 | 826 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 15971794 | 15971794 | PRJNA690124_P_NODE_25153_length_327_cov_1.830709_g24787_i0 | PRJNA690124 | 25153 | 327 | 1.830709 | 5.98641843 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 58.4 | 6.61e-4 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g24787 | i0 | 94.737 | 0.116207951070336 | 38 | 1 | 12 | 1 | 11 | 48 | 15596129 | 15596165 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 38 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 15972209 | 15972209 | PRJNA690124_P_NODE_44673_length_252_cov_0.871508_g44307_i0 | PRJNA690124 | 44673 | 252 | 0.871508 | 2.19620016 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 134 | 7.93e-27 | NTclustered | gi|2663986575|emb|OY756916.1| | 69463 | g44307 | i0 | 94.253 | 28.3373015873016 | 87 | 5 | 35 | 0 | 1 | 87 | 6560 | 6646 | Henneguya salminicola isolate Hz1 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 7141 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola |
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);;