metadata: contig_metadata: 6 rows where bioproject = "PRJNA482207", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJNA482207", tax_clade = "Opisthokonta" and tax_phylum = "Cnidaria"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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
4275183	4275183	PRJNA482207_P_NODE_64_length_3230_cov_16.748179_g14_i2	PRJNA482207	64	3230	16.748179	540.9661817	root	1	Root_unresolved	Root_unresolved	174	1.22e-43	NR	CAB3995163.1	317549	g14	i2	48.9	2.28761609907121	182	81	16.9	3	2462	1917	190	359	CAB3995163.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	7389	175	0.994285714285714	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
8101036	8101036	PRJNA482207_P_NODE_19987_length_251_cov_0.865169_g19877_i0	PRJNA482207	19987	251	0.865169	2.17157419	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	54.7	0.006	NTclustered	gi\|2918369537\|emb\|OZ237719.1\|	317547	g19877	i0	100	0.115537848605578	29	0	12	0	32	60	22276935	22276963	Eunicella cavolini genome assembly, chromosome: 3	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
28687148	28687148	PRJNA482207_P_NODE_15447_length_280_cov_1.275362_g15337_i0	PRJNA482207	15447	280	1.275362	3.5710136	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	110	8.18e-26	NR	CAB3983150.1	317549	g15337	i0	53.7	5.11071428571429	95	42	99.6	1	1	279	487	581	CAB3983150.1 Retrovirus-related Pol poly from transposon, partial [Paramuricea clavata]	diamond	1431	110	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
29475944	29475944	PRJNA482207_P_NODE_20090_length_251_cov_0.865169_g19980_i0	PRJNA482207	20090	251	0.865169	2.17157419	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	43.1	0.0289	NR	XP_065662865.1	6087	g19980	i0	29.7	1.08764940239044	91	55	98	3	3	248	3	93	XP_065662865.1 uncharacterized protein LOC136085482 [Hydra vulgaris]	diamond	273	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
32067682	32067682	PRJNA482207_P_NODE_8698_length_346_cov_0.985348_g8588_i0	PRJNA482207	8698	346	0.985348	3.40930408	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	75.9	1.39e-13	NR	CAB3987385.1	317549	g8588	i0	34.2	6.59826589595376	114	75	98.8	0	3	344	185	298	CAB3987385.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	2283	75.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
32352832	32352832	PRJNA482207_P_NODE_22679_length_248_cov_0.880000_g22569_i0	PRJNA482207	22679	248	0.88	2.1824	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	73.6	5.56e-13	NR	KXJ15649.1	2652724	g22569	i0	47.6	2.93951612903226	82	42	99.2	1	3	248	104	184	KXJ15649.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Exaiptasia diaphana]	diamond	729	73.6	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);;