contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA335774" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6767694 | 6767694 | PRJNA335774_P_NODE_15586_length_379_cov_3.931373_g15434_i0 | PRJNA335774 | 15586 | 379 | 3.931373 | 14.89990367 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 329 | 1.49e-85 | NTclustered | gi|1778059731|ref|XM_031711301.1| | 6105 | g15434 | i0 | 83.768 | 83.1899736147757 | 345 | 56 | 91 | 0 | 24 | 368 | 449 | 105 | PREDICTED: Actinia tenebrosa ubiquitin-40S ribosomal protein S27a (LOC116302103), mRNA | blastn | 31529 | 329 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 13143559 | 13143559 | PRJNA335774_P_NODE_13391_length_405_cov_1.138554_g13239_i0 | PRJNA335774 | 13391 | 405 | 1.138554 | 4.6111437 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 743 | 0 | NTclustered | gi|2518984096|ref|XM_057441433.1| | 13093 | g13239 | i0 | 99.753 | 78.0716049382716 | 405 | 1 | 100 | 0 | 1 | 405 | 940 | 1344 | PREDICTED: Hydractinia symbiolongicarpus cytochrome b-like (LOC130628217), mRNA | blastn | 31619 | 743 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 13144203 | 13144203 | PRJNA335774_P_NODE_41411_length_248_cov_1.611429_g41259_i0 | PRJNA335774 | 41411 | 248 | 1.611429 | 3.99634392 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 459 | 1.13e-124 | NTclustered | gi|2518983886|ref|XM_057441323.1| | 13093 | g41259 | i0 | 100 | 13.5927419354839 | 248 | 0 | 100 | 0 | 1 | 248 | 255 | 8 | PREDICTED: Hydractinia symbiolongicarpus NADH-ubiquinone oxidoreductase chain 2-like (LOC130626408), mRNA | blastn | 3371 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 15693212 | 15693212 | PRJNA335774_P_NODE_35333_length_265_cov_1.203125_g35181_i0 | PRJNA335774 | 35333 | 265 | 1.203125 | 3.18828125 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 235 | 2.24e-57 | NTclustered | gi|1176113485|ref|XM_020772146.1| | 48498 | g35181 | i0 | 84.681 | 90.2792452830189 | 235 | 36 | 89 | 0 | 27 | 261 | 1261 | 1027 | PREDICTED: Orbicella faveolata eukaryotic initiation factor 4A-III (LOC110065039), mRNA | blastn | 23924 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 20791929 | 20791929 | PRJNA335774_P_NODE_34077_length_270_cov_1.350254_g33925_i0 | PRJNA335774 | 34077 | 270 | 1.350254 | 3.6456858 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 278 | 3.7500000000000005e-70 | NTclustered | gi|2367574861|gb|OM201532.1| | 203993 | g33925 | i0 | 87.5 | 89.0444444444445 | 240 | 30 | 89 | 0 | 1 | 240 | 583 | 344 | Pocillopora verrucosa isolate PS0103-46 beta-tubulin (TUB) gene, partial cds | blastn | 24042 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 22067332 | 22067332 | PRJNA335774_P_NODE_6658_length_546_cov_2.968288_g6507_i0 | PRJNA335774 | 6658 | 546 | 2.968288 | 16.20685248 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 54.7 | 0.015 | NTclustered | gi|1191051559|ref|XM_021047964.1| | 2652724 | g6507 | i0 | 100 | 0.0531135531135531 | 29 | 0 | 5 | 0 | 157 | 185 | 3846 | 3818 | PREDICTED: Exaiptasia diaphana monocarboxylate transporter 10 (LOC110242031), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana |
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);;