metadata: contig_metadata: 6 rows where bioproject = "PRJNA825466", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA825466", tax_kingdom = "Metazoa" 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
12299674	12299674	PRJNA825466_P_NODE_730_length_783_cov_2.277465_g646_i0	PRJNA825466	730	783	2.277465	17.83255095	root	1	Root_unresolved	Root_unresolved	243	1.25e-75	NR	XP_066923674.1	252671	g646	i0	48.3	14.4329501915709	263	128	97.7	5	17	781	33	295	XP_066923674.1 procathepsin L-like [Clytia hemisphaerica]	diamond	11301	243	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
16530797	16530797	PRJNA825466_P_NODE_20993_length_247_cov_1.005747_g20892_i0	PRJNA825466	20993	247	1.005747	2.48419509	Acropora	6127	Cnidaria	other_Eukaryota	52.8	0.022	NTclustered	gi\|2113940618\|ref\|XM_029357460.2\|	45264	g20892	i0	100	0.226720647773279	28	0	11	0	39	66	426	453	PREDICTED: Acropora millepora cysteine protease ATG4D-like (LOC114976914), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
18671715	18671715	PRJNA825466_P_NODE_10515_length_284_cov_2.189573_g10414_i0	PRJNA825466	10515	284	2.189573	6.21838732	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	160	1.26e-47	NR	XP_022790207.1	50429	g10414	i0	77.7	1.98591549295775	94	21	99.3	0	2	283	24	117	XP_022790207.1 60S ribosomal protein L10-like [Stylophora pistillata]	diamond	564	160	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
31231987	31231987	PRJNA825466_P_NODE_9775_length_290_cov_1.299539_g9674_i0	PRJNA825466	9775	290	1.299539	3.7686631	Scleractinia	6125	Cnidaria	other_Eukaryota	53.5	1.08e-5	NR	XP_020620192.1	48498	g9674	i0	38.2	7.28275862068966	89	47	83.8	3	41	283	21	109	XP_020620192.1 PC3-like endoprotease variant A [Orbicella faveolata]	diamond	2112	53.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
31950953	31950953	PRJNA825466_P_NODE_22037_length_246_cov_1.780347_g21936_i0	PRJNA825466	22037	246	1.780347	4.37965362	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	52.4	1.42e-5	NR	XP_065668298.1	6087	g21936	i0	50	1.36585365853659	56	24	68.3	1	6	173	280	331	XP_065668298.1 arginase [Hydra vulgaris]	diamond	336	52.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
32267601	32267601	PRJNA825466_P_NODE_23278_length_245_cov_1.697674_g23177_i0	PRJNA825466	23278	245	1.697674	4.1593013	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	45.1	0.00576	NR	KXJ10894.1	2652724	g23177	i0	36.4	2.58367346938775	77	45	94.3	2	5	235	393	465	KXJ10894.1 EH domain-binding protein 1 [Exaiptasia diaphana]	diamond	633	45.1	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);;