contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA489308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 450446 | 450446 | PRJNA489308_P_NODE_8721_length_374_cov_1.588040_g8645_i0 | PRJNA489308 | 8721 | 374 | 1.58804 | 5.9392696 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 76.8 | 2.11e-9 | NTclustered | gi|2751567169|ref|XM_059095442.2| | 203993 | g8645 | i0 | 84.81 | 12.2112299465241 | 79 | 9 | 21 | 2 | 120 | 198 | 646 | 571 | PREDICTED: Pocillopora verrucosa uncharacterized protein (LOC131778950), transcript variant X7, mRNA | blastn | 4567 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 1725055 | 1725055 | PRJNA489308_P_NODE_6922_length_409_cov_2.940476_g6846_i0 | PRJNA489308 | 6922 | 409 | 2.940476 | 12.02654684 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g6846 | i0 | 100 | 0.735941320293399 | 30 | 0 | 7 | 0 | 261 | 290 | 11609381 | 11609410 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 301 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 7476120 | 7476120 | PRJNA489308_P_NODE_9126_length_368_cov_1.525424_g9050_i0 | PRJNA489308 | 9126 | 368 | 1.525424 | 5.61356032 | Pocilloporidae | 46729 | Cnidaria | other_Eukaryota | 104 | 9.52e-18 | NTclustered | gi|157144281|ref|NC_009797.1| | 46731 | g9050 | i0 | 92.958 | 9.22282608695652 | 71 | 5 | 19 | 0 | 270 | 340 | 619 | 549 | Pocillopora damicornis mitochondrion, complete genome | blastn | 3394 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 13203756 | 13203756 | PRJNA489308_P_NODE_1631_length_733_cov_6.156061_g1559_i0 | PRJNA489308 | 1631 | 733 | 6.156061 | 45.12392713 | Parvicapsula minibicornis | 109801 | Cnidaria | other_Eukaryota | 141 | 1.52e-28 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g1559 | i0 | 87.2 | 17.6712141882674 | 125 | 14 | 17 | 2 | 1 | 125 | 355 | 233 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 12953 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis | |
| 13851754 | 13851754 | PRJNA489308_P_NODE_35151_length_245_cov_1.790698_g35075_i0 | PRJNA489308 | 35151 | 245 | 1.790698 | 4.3872101 | Montipora | 46703 | Cnidaria | other_Eukaryota | 204 | 5.77e-48 | NTclustered | gi|2812121004|ref|XM_068873443.1| | 246305 | g35075 | i0 | 81.893 | 46.065306122449 | 243 | 42 | 99 | 2 | 2 | 243 | 504 | 263 | PREDICTED: Montipora capricornis ras-related protein Rab-1A (LOC138026211), mRNA | blastn | 11286 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 14478836 | 14478836 | PRJNA489308_P_NODE_36552_length_244_cov_0.900585_g36476_i0 | PRJNA489308 | 36552 | 244 | 0.900585 | 2.1974274 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940703|emb|OZ237559.1| | 6108 | g36476 | i0 | 96.97 | 6.85245901639344 | 33 | 1 | 14 | 0 | 208 | 240 | 11119641 | 11119609 | Anemonia sulcata genome assembly, chromosome: 5 | blastn | 1672 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 14478915 | 14478915 | PRJNA489308_P_NODE_6832_length_411_cov_1.810651_g6756_i0 | PRJNA489308 | 6832 | 411 | 1.810651 | 7.44177561 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 60.2 | 2.36e-4 | NTclustered | gi|2729086879|ref|XM_065206019.1| | 499914 | g6756 | i0 | 94.872 | 0.326034063260341 | 39 | 0 | 9 | 1 | 187 | 223 | 682 | 720 | PREDICTED: Rhopilema esculentum uncharacterized LOC135688949 (LOC135688949), transcript variant X1, mRNA | blastn | 134 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 18301928 | 18301928 | PRJNA489308_P_NODE_6035_length_433_cov_3.077778_g5959_i0 | PRJNA489308 | 6035 | 433 | 3.077778 | 13.32677874 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 281 | 4.900000000000001e-71 | NTclustered | gi|2518991437|ref|XM_057446583.1| | 13093 | g5959 | i0 | 82.006 | 77.9145496535797 | 339 | 53 | 77 | 7 | 2 | 336 | 177 | 511 | PREDICTED: Hydractinia symbiolongicarpus ubiquitin-60S ribosomal protein L40 (LOC130636750), mRNA | blastn | 33737 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 19575947 | 19575947 | PRJNA489308_P_NODE_2336_length_635_cov_2.893238_g2261_i0 | PRJNA489308 | 2336 | 635 | 2.893238 | 18.3720613 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 187 | 1.66e-42 | NTclustered | gi|2782929037|ref|XM_067073665.1| | 252671 | g2261 | i0 | 79.412 | 3.96220472440945 | 272 | 50 | 42 | 5 | 1 | 269 | 895 | 1163 | PREDICTED: Clytia hemisphaerica calreticulin-like (LOC136817322), mRNA | blastn | 2516 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 23402345 | 23402345 | PRJNA489308_P_NODE_10899_length_346_cov_1.842491_g10823_i0 | PRJNA489308 | 10899 | 346 | 1.842491 | 6.37501886 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2918369553|emb|OZ237725.1| | 317547 | g10823 | i0 | 96.97 | 0.179190751445087 | 33 | 1 | 10 | 0 | 25 | 57 | 15227518 | 15227486 | Eunicella cavolini genome assembly, chromosome: 9 | blastn | 62 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 24676324 | 24676324 | PRJNA489308_P_NODE_4560_length_485_cov_2.633495_g4484_i0 | PRJNA489308 | 4560 | 485 | 2.633495 | 12.77245075 | Galaxea fascicularis | 46745 | Cnidaria | other_Eukaryota | 315 | 5.459999999999999e-81 | NTclustered | gi|26522783|dbj|AB086826.1| | 46745 | g4484 | i0 | 78.615 | 101.358762886598 | 491 | 93 | 100 | 11 | 1 | 485 | 1164 | 680 | Galaxea fascicularis LGfact mRNA for actin, complete cds | blastn | 49159 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Euphylliidae | Galaxea | Galaxea fascicularis |
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);;