contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA983848" and tax_phylum = "Echinodermata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 969862 | 969862 | PRJNA983848_P_NODE_56601_length_442_cov_2.699187_g50721_i0 | PRJNA983848 | 56601 | 442 | 2.699187 | 11.93040654 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 512 | 1.6299999999999998e-140 | NTclustered | gi|2919521130|ref|XM_071653395.1| | 105358 | g50721 | i0 | 87.699 | 1.05656108597285 | 439 | 54 | 99 | 0 | 3 | 441 | 728 | 1166 | PREDICTED: Diadema antillarum uncharacterized protein (LOC139742884), mRNA | blastn | 467 | 512 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 970042 | 970042 | PRJNA983848_P_NODE_61321_length_415_cov_1.991228_g55439_i0 | PRJNA983848 | 61321 | 415 | 1.991228 | 8.2635962 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 484 | 3.32e-132 | NTclustered | gi|2919511784|ref|XM_071651784.1| | 105358 | g55439 | i0 | 88.395 | 2.06506024096386 | 405 | 44 | 97 | 3 | 1 | 404 | 1477 | 1075 | PREDICTED: Diadema antillarum uncharacterized protein (LOC139741193), mRNA | blastn | 857 | 484 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 2245164 | 2245164 | PRJNA983848_P_NODE_58342_length_431_cov_3.000000_g52461_i0 | PRJNA983848 | 58342 | 431 | 3 | 12.93 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 80.5 | 1.91e-10 | NTclustered | gi|1826652272|ref|XM_033258159.1| | 1529436 | g52461 | i0 | 76.974 | 0.352668213457077 | 152 | 27 | 34 | 8 | 105 | 252 | 190 | 337 | PREDICTED: Anneissia japonica PHD finger protein ALFIN-LIKE 3-like (LOC117114492), mRNA | blastn | 152 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 14998543 | 14998543 | PRJNA983848_P_NODE_75872_length_358_cov_1.922807_g69989_i0 | PRJNA983848 | 75872 | 358 | 1.922807 | 6.88364906 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 289 | 2.37e-73 | NTclustered | gi|2919531170|ref|XM_071655205.1| | 105358 | g69989 | i0 | 87.109 | 2.5586592178771 | 256 | 32 | 71 | 1 | 1 | 255 | 202 | 457 | PREDICTED: Diadema antillarum craniofacial development protein 2-like (LOC139744789), mRNA | blastn | 916 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 21368455 | 21368455 | PRJNA983848_P_NODE_104537_length_295_cov_1.756757_g98654_i0 | PRJNA983848 | 104537 | 295 | 1.756757 | 5.18243315 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 100 | 9.64e-17 | NTclustered | gi|2919390218|ref|XM_071629782.1| | 105358 | g98654 | i0 | 87.5 | 3.3728813559322 | 88 | 9 | 30 | 1 | 184 | 271 | 6924 | 6839 | PREDICTED: Diadema antillarum uncharacterized protein (LOC139718298), mRNA | blastn | 995 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum |
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);;