contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA557895" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3086978 | 3086978 | PRJNA557895_P_NODE_24323_length_188_cov_1.100719_g23968_i0 | PRJNA557895 | 24323 | 188 | 1.100719 | 2.06935172 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 346 | 6.6e-91 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g23968 | i0 | 100 | 5.58510638297872 | 187 | 0 | 99 | 0 | 1 | 187 | 2145 | 2331 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 1050 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 6913700 | 6913700 | PRJNA557895_P_NODE_11966_length_267_cov_0.935780_g11611_i0 | PRJNA557895 | 11966 | 267 | 0.93578 | 2.4985326 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|2917940737|emb|OZ237566.1| | 6108 | g11611 | i0 | 100 | 0.104868913857678 | 28 | 0 | 10 | 0 | 184 | 211 | 8559406 | 8559379 | Anemonia sulcata genome assembly, chromosome: 12 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 8188841 | 8188841 | PRJNA557895_P_NODE_21687_length_199_cov_2.066667_g21332_i0 | PRJNA557895 | 21687 | 199 | 2.066667 | 4.11266733 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 60.2 | 1.03e-4 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g21332 | i0 | 100 | 0.160804020100503 | 32 | 0 | 16 | 0 | 153 | 184 | 6972426 | 6972457 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 18388193 | 18388193 | PRJNA557895_P_NODE_35055_length_163_cov_1.728070_g34700_i0 | PRJNA557895 | 35055 | 163 | 1.72807 | 2.8167541 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|2751554566|ref|XM_066168567.1| | 203993 | g34700 | i0 | 100 | 0.343558282208589 | 28 | 0 | 17 | 0 | 91 | 118 | 4933 | 4906 | PREDICTED: Pocillopora verrucosa nephrocystin-3-like (LOC131784025), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 19662244 | 19662244 | PRJNA557895_P_NODE_20056_length_207_cov_1.291139_g19701_i0 | PRJNA557895 | 20056 | 207 | 1.291139 | 2.67265773 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2744814801|ref|XM_012710030.3| | 6087 | g19701 | i0 | 100 | 0.280193236714976 | 29 | 0 | 14 | 0 | 171 | 199 | 1121 | 1149 | PREDICTED: Hydra vulgaris uncharacterized LOC100207073 (LOC100207073), transcript variant X1, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 24762222 | 24762222 | PRJNA557895_P_NODE_22680_length_195_cov_1.047945_g22325_i0 | PRJNA557895 | 22680 | 195 | 1.047945 | 2.04349275 | Chloromyxum careni | 941395 | Cnidaria | other_Eukaryota | 122 | 1.2699999999999999e-23 | NTclustered | gi|315666422|gb|HM641795.1| | 941395 | g22325 | i0 | 81.25 | 59.5076923076923 | 160 | 23 | 80 | 5 | 25 | 180 | 182 | 338 | Chloromyxum careni large subunit ribosomal RNA gene, partial sequence | blastn | 11604 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Chloromyxidae | Chloromyxum | Chloromyxum careni |
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);;