metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1044115" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1044115" 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
6549447	6549447	PRJNA1044115_P_NODE_26726_length_282_cov_4.382775_g26542_i0	PRJNA1044115	26726	282	4.382775	12.3594255	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	168	1.74e-50	NR	KXJ10547.1	2652724	g26542	i0	97.6	31.3191489361702	85	2	90.4	0	26	280	12	96	KXJ10547.1 Ras-related protein Rab-7a [Exaiptasia diaphana]	diamond	8832	168	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
27817101	27817101	PRJNA1044115_P_NODE_33464_length_254_cov_3.060773_g33280_i0	PRJNA1044115	33464	254	3.060773	7.77436342	Metazoa	33208	Cnidaria	other_Eukaryota	178	4.3e-50	NR	KAK2567313.1	6130	g33280	i0	98.8	1503.07086614173	84	1	99.2	0	1	252	216	299	KAK2567313.1 MAP/microtubule affinity-regulating kinase 3 [Acropora cervicornis]	diamond	381780	179	0.994413407821229	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
27825080	27825080	PRJNA1044115_P_NODE_224_length_2319_cov_8.273820_g201_i0	PRJNA1044115	224	2319	8.27382	191.8698858	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	292	3.6299999999999985e-87	NR	XP_047135224.2	6087	g201	i0	39.8	1.57050452781371	405	227	52	6	1071	2276	38	428	XP_047135224.2 uncharacterized protein LOC124812489 [Hydra vulgaris]	diamond	3642	292	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
27887973	27887973	PRJNA1044115_P_NODE_10105_length_476_cov_3.114144_g9921_i0	PRJNA1044115	10105	476	3.114144	14.82332544	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	75.1	6.07e-13	NR	CAB4044946.1	317549	g9921	i0	36.1	1.34243697478992	108	68	68.1	1	324	1	7	113	CAB4044946.1 Hypothetical predicted protein, partial [Paramuricea clavata]	diamond	639	75.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
31868350	31868350	PRJNA1044115_P_NODE_26797_length_282_cov_2.038278_g26613_i0	PRJNA1044115	26797	282	2.038278	5.74794396	Actinostola sp. cb2	3060491	Cnidaria	other_Eukaryota	67.8	3.65e-12	NR	KAK3739936.1	3060491	g26613	i0	60.5	2.65957446808511	43	17	45.7	0	1	129	72	114	KAK3739936.1 hypothetical protein QZH41_015977, partial [Actinostola sp. cb2023]	diamond	750	67.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actinostolidae	Actinostola	Actinostola sp. cb2023
31868354	31868354	PRJNA1044115_P_NODE_517_length_1861_cov_8.151566_g488_i0	PRJNA1044115	517	1861	8.151566	151.70064326	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	490	5.809999999999999e-159	NR	XP_065683387.1	6087	g488	i0	47.4	4.39441160666308	546	273	86.7	6	34	1647	386	925	XP_065683387.1 uncharacterized protein LOC105848384 [Hydra vulgaris]	diamond	8178	490	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris

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);;