metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA564013" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA564013" 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
27205398	27205398	PRJNA564013_P_NODE_124002_length_378_cov_4.208202_g121156_i0	PRJNA564013	124002	378	4.208202	15.90700356	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	71.6	1.29e-11	NR	XP_065675501.1	6087	g121156	i0	36.4	0.936507936507937	118	73	92.1	1	27	374	188	305	XP_065675501.1 uncharacterized protein LOC136091722 [Hydra vulgaris]	diamond	354	71.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
29826400	29826400	PRJNA564013_P_NODE_181871_length_323_cov_4.122137_g179021_i0	PRJNA564013	181871	323	4.122137	13.31450251	Porites evermanni	104178	Cnidaria	other_Eukaryota	70.5	1.45e-12	NR	CAH3191542.1	104178	g179021	i0	42.3	3.86377708978328	104	54	91	2	317	24	56	159	CAH3191542.1 unnamed protein product, partial [Porites evermanni]	diamond	1248	70.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
30395647	30395647	PRJNA564013_P_NODE_35753_length_643_cov_14.307560_g33090_i0	PRJNA564013	35753	643	14.30756	91.9976108	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	47.4	0.0294	NR	CAB4025375.1	317549	g33090	i0	34.7	0.349922239502333	75	48	35	1	21	245	1012	1085	CAB4025375.1 zinc finger [Paramuricea clavata]	diamond	225	47.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
31027272	31027272	PRJNA564013_P_NODE_206855_length_299_cov_28.542017_g204004_i0	PRJNA564013	206855	299	28.542017	85.34063083	Actinostola sp. cb2	3060491	Cnidaria	other_Eukaryota	56.6	8.52e-7	NR	KAK3739092.1	3060491	g204004	i0	54.5	0.441471571906354	44	20	44.1	0	214	83	111	154	KAK3739092.1 hypothetical protein QZH41_006316 [Actinostola sp. cb2023]	diamond	132	56.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actinostolidae	Actinostola	Actinostola sp. cb2023
31279880	31279880	PRJNA564013_P_NODE_294655_length_229_cov_1.523810_g291803_i0	PRJNA564013	294655	229	1.52381	3.4895249	Actinostola sp. cb2	3060491	Cnidaria	other_Eukaryota	42.4	0.0427	NR	KAK3728551.1	3060491	g291803	i0	36.4	0.720524017467249	55	35	72.1	0	177	13	318	372	KAK3728551.1 hypothetical protein QZH41_011640 [Actinostola sp. cb2023]	diamond	165	42.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actinostolidae	Actinostola	Actinostola sp. cb2023
32021306	32021306	PRJNA564013_P_NODE_36598_length_637_cov_5.390625_g33928_i0	PRJNA564013	36598	637	5.390625	34.33828125	Anthozoa	6101	Cnidaria	other_Eukaryota	61.2	5.1e-7	NR	XP_022788722.1	50429	g33928	i0	35.2	2.47252747252747	105	65	49.5	2	212	526	423	524	XP_022788722.1 uncharacterized protein LOC111328527 [Stylophora pistillata]	diamond	1575	61.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
32070777	32070777	PRJNA564013_P_NODE_56758_length_529_cov_22.237179_g53978_i0	PRJNA564013	56758	529	22.237179	117.63467691	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	63.9	3.05e-8	NR	XP_028405267.1	151771	g53978	i0	49.1	0.958412098298677	57	29	32.3	0	336	506	1306	1362	XP_028405267.1 uncharacterized protein LOC114527777 [Dendronephthya gigantea]	diamond	507	63.9	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);;