contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA789095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2489974 | 2489974 | PRJNA789095_P_NODE_60582_length_262_cov_1.629630_g59248_i0 | PRJNA789095 | 60582 | 262 | 1.62963 | 4.2696306 | Acropora | 6127 | Cnidaria | other_Eukaryota | 93.5 | 1.41e-14 | NTclustered | gi|2113996306|ref|XM_029346466.2| | 45264 | g59248 | i0 | 80.833 | 17.1603053435114 | 120 | 21 | 45 | 2 | 141 | 259 | 264 | 146 | PREDICTED: Acropora millepora 26S proteasome complex subunit SEM1-like (LOC114966557), mRNA | blastn | 4496 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 4598667 | 4598667 | PRJNA789095_P_NODE_34404_length_350_cov_7.014440_g33070_i0 | PRJNA789095 | 34404 | 350 | 7.01444 | 24.55054 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2918369539|emb|OZ237721.1| | 317547 | g33070 | i0 | 96.97 | 0.0942857142857143 | 33 | 1 | 9 | 0 | 82 | 114 | 11972730 | 11972698 | Eunicella cavolini genome assembly, chromosome: 5 | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 4598914 | 4598914 | PRJNA789095_P_NODE_42184_length_310_cov_2.945148_g40850_i0 | PRJNA789095 | 42184 | 310 | 2.945148 | 9.1299588 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 126 | 1.68e-24 | NTclustered | gi|2202604414|ref|XM_047006313.1| | 2897299 | g40850 | i0 | 82.759 | 26.6129032258065 | 145 | 21 | 46 | 4 | 3 | 145 | 2612 | 2754 | PREDICTED: Xenia sp. Carnegie-2017 pumilio homolog 2-like (LOC124455658), transcript variant X3, mRNA | blastn | 8250 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 22448630 | 22448630 | PRJNA789095_P_NODE_63338_length_256_cov_1.677596_g62004_i0 | PRJNA789095 | 63338 | 256 | 1.677596 | 4.29464576 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 165 | 2.87e-36 | NTclustered | gi|1603776320|ref|XM_028535371.1| | 151771 | g62004 | i0 | 78.74 | 22.390625 | 254 | 48 | 98 | 6 | 1 | 251 | 526 | 776 | PREDICTED: Dendronephthya gigantea succinate--CoA ligase [ADP/GDP-forming] subunit alpha, mitochondrial-like (LOC114516023), mRNA | blastn | 5732 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea |
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);;