contig_metadata
5 rows where bioproject = "PRJNA283169", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 371822 | 371822 | PRJNA283169_P_NODE_961_length_397_cov_1.252874_g899_i0 | PRJNA283169 | 961 | 397 | 1.252874 | 4.97390978 | Nausithoe rubra | 168762 | Cnidaria | other_Eukaryota | 139 | 2.84e-28 | NTclustered | gi|66864835|gb|AY920776.1| | 168762 | g899 | i0 | 91.176 | 1.76574307304786 | 102 | 9 | 26 | 0 | 3 | 104 | 1366 | 1467 | Nausithoe rubra large subunit 28S ribosomal RNA gene, partial sequence | blastn | 701 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Coronatae | Nausithoidae | Nausithoe | Nausithoe rubra | |
| 1646623 | 1646623 | PRJNA283169_S_NODE_3482_length_161_cov_0.857143_g3468_i0 | PRJNA283169 | 3482 | 161 | 0.857143 | 1.38000023 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 78.7 | 2.21e-10 | NTclustered | gi|2782896459|ref|XM_067067483.1| | 252671 | g3468 | i0 | 95.833 | 0.900621118012422 | 48 | 2 | 30 | 0 | 21 | 68 | 483 | 436 | PREDICTED: Clytia hemisphaerica procathepsin L-like (LOC136810899), mRNA | blastn | 145 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 14400820 | 14400820 | PRJNA283169_S_NODE_1932_length_202_cov_1.588235_g1918_i0 | PRJNA283169 | 1932 | 202 | 1.588235 | 3.2082347 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 141 | 3.65e-29 | NTclustered | gi|2729089548|ref|XM_065207423.1| | 499914 | g1918 | i0 | 88.696 | 7.87623762376238 | 115 | 13 | 57 | 0 | 85 | 199 | 138 | 252 | PREDICTED: Rhopilema esculentum tubulin alpha-1 chain (LOC135690017), transcript variant X3, mRNA | blastn | 1591 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 26838863 | 26838863 | PRJNA283169_S_NODE_2321_length_187_cov_1.108696_g2307_i0 | PRJNA283169 | 2321 | 187 | 1.108696 | 2.07326152 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.00275 | NR | PFX21664.1 | 50429 | g2307 | i0 | 42.2 | 1.31550802139037 | 45 | 26 | 72.2 | 0 | 160 | 26 | 230 | 274 | PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata] | diamond | 246 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 31608799 | 31608799 | PRJNA283169_S_NODE_1716_length_212_cov_0.104294_g1702_i0 | PRJNA283169 | 1716 | 212 | 0.104294 | 0.22110328 | Pocilloporidae | 46729 | Cnidaria | other_Eukaryota | 57.4 | 1.71e-7 | NR | RMX41873.1 | 46731 | g1702 | i0 | 42.6 | 5.17924528301887 | 61 | 35 | 86.3 | 0 | 184 | 2 | 899 | 959 | RMX41873.1 hypothetical protein pdam_00019624, partial [Pocillopora damicornis] | diamond | 1098 | 57.8 | 0.993079584775087 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis |
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);;