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

6 rows where analysis = "diamond", bioproject = "PRJNA1150539" 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
26596805	26596805	PRJNA1150539_S_NODE_105241_length_236_cov_2.361963_g104645_i0	PRJNA1150539	105241	236	2.361963	5.57423268	Montipora foliosa	591990	Cnidaria	other_Eukaryota	44.7	0.0066	NR	XP_068680545.1	591990	g104645	i0	52.3	2.23728813559322	44	21	55.9	0	230	99	240	283	XP_068680545.1 uncharacterized protein [Montipora foliosa]	diamond	528	45.1	0.991130820399113	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora foliosa
29597793	29597793	PRJNA1150539_S_NODE_76310_length_271_cov_1.166667_g75714_i0	PRJNA1150539	76310	271	1.166667	3.16166757	Porites lobata	104759	Cnidaria	other_Eukaryota	57.8	2.35e-7	NR	CAH3161428.1	104759	g75714	i0	49.1	0.6309963099631	57	27	60.9	1	178	14	30	86	CAH3161428.1 unnamed protein product, partial [Porites lobata]	diamond	171	57.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
29660877	29660877	PRJNA1150539_S_NODE_73610_length_274_cov_3.164179_g73014_i0	PRJNA1150539	73610	274	3.164179	8.66985046	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	44.3	0.0153	NR	PFX15504.1	50429	g73014	i0	35.4	3.94160583941606	65	39	71.2	1	212	18	636	697	PFX15504.1 putative RNA-directed DNA polymerase from transposon BS [Stylophora pistillata]	diamond	1080	44.7	0.991051454138702	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
30451273	30451273	PRJNA1150539_S_NODE_63333_length_289_cov_3.134259_g62737_i0	PRJNA1150539	63333	289	3.134259	9.05800851	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	45.8	0.00505	NR	PFX34701.1	50429	g62737	i0	47.9	2.2318339100346	48	22	49.8	1	2	145	246	290	PFX34701.1 RNA-directed DNA polymerase from mobile element jockey [Stylophora pistillata]	diamond	645	45.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
30545797	30545797	PRJNA1150539_S_NODE_102413_length_241_cov_2.291667_g101817_i0	PRJNA1150539	102413	241	2.291667	5.52291747	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	58.2	1.29e-7	NR	XP_028519371.1	2652724	g101817	i0	55.1	2.43983402489627	49	19	57.3	2	230	93	345	393	XP_028519371.1 uncharacterized protein K02A2.6 [Exaiptasia diaphana]	diamond	588	58.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
32019557	32019557	PRJNA1150539_S_NODE_18118_length_389_cov_5.623418_g17522_i0	PRJNA1150539	18118	389	5.623418	21.87509602	Metazoa	33208	Cnidaria	other_Eukaryota	75.1	9.39e-13	NR	PFX16388.1	50429	g17522	i0	42.7	4.3573264781491	89	50	67.9	1	363	100	56	144	PFX16388.1 Retrovirus-related Pol polyprotein [Stylophora pistillata]	diamond	1695	75.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata

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