contig_metadata
6 rows where bioproject = "PRJEB11523", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10216510 | 10216510 | PRJEB11523_P_NODE_3669_length_253_cov_20.377451_g3591_i0 | PRJEB11523 | 3669 | 253 | 20.377451 | 51.55495103 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 62.1 | 3.81e-5 | NTclustered | gi|2729078193|ref|XM_065201444.1| | 499914 | g3591 | i0 | 100 | 0.130434782608696 | 33 | 0 | 13 | 0 | 78 | 110 | 1792 | 1760 | PREDICTED: Rhopilema esculentum serine/threonine-protein kinase 40-like (LOC135685480), mRNA | blastn | 33 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 20109040 | 20109040 | PRJEB11523_P_NODE_6436_length_181_cov_5.393939_g6358_i0 | PRJEB11523 | 6436 | 181 | 5.393939 | 9.76302959 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 122 | 1.16e-23 | NTclustered | gi|1347759488|gb|MG979306.1| | 340365 | g6358 | i0 | 89.32 | 53.0773480662983 | 103 | 4 | 55 | 5 | 1 | 100 | 195 | 97 | Scolionema suvaense isolate AGC0509 large subunit ribosomal RNA gene, partial sequence | blastn | 9607 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Limnomedusae | Olindiidae | Scolionema | Scolionema suvaense | |
| 27759651 | 27759651 | PRJEB11523_P_NODE_3344_length_270_cov_2.190045_g3266_i0 | PRJEB11523 | 3344 | 270 | 2.190045 | 5.9131215 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 48.1 | 6.3e-4 | NR | KAK3718960.1 | 3060491 | g3266 | i0 | 39.3 | 0.988888888888889 | 89 | 43 | 92.2 | 3 | 250 | 2 | 412 | 495 | KAK3718960.1 hypothetical protein QZH41_017573, partial [Actinostola sp. cb2023] | diamond | 267 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 29117189 | 29117189 | PRJEB11523_P_NODE_3229_length_277_cov_1.679825_g3151_i0 | PRJEB11523 | 3229 | 277 | 1.679825 | 4.65311525 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 50.4 | 8.47e-5 | NR | CAB4041414.1 | 317549 | g3151 | i0 | 54.8 | 0.454873646209386 | 42 | 17 | 45.5 | 1 | 152 | 277 | 37 | 76 | CAB4041414.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 126 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30121274 | 30121274 | PRJEB11523_P_NODE_4392_length_226_cov_9.649718_g4314_i0 | PRJEB11523 | 4392 | 226 | 9.649718 | 21.80836268 | root | 1 | Root_unresolved | Root_unresolved | 56.2 | 5.22e-7 | NR | XP_065665725.1 | 6087 | g4314 | i0 | 41.5 | 1.7787610619469 | 65 | 38 | 86.3 | 0 | 204 | 10 | 361 | 425 | XP_065665725.1 uncharacterized protein LOC136087146 [Hydra vulgaris] | diamond | 402 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31423162 | 31423162 | PRJEB11523_P_NODE_4176_length_234_cov_1.627027_g4098_i0 | PRJEB11523 | 4176 | 234 | 1.627027 | 3.80724318 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 42 | 0.0424 | NR | PFX12617.1 | 50429 | g4098 | i0 | 35.8 | 0.67948717948718 | 53 | 32 | 67.9 | 1 | 40 | 198 | 27 | 77 | PFX12617.1 hypothetical protein AWC38_SpisGene23392 [Stylophora pistillata] | diamond | 159 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata |
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);;