metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Xenacoelomorpha"

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_order	tax_family	tax_genus	tax_species
26754611	26754611	PRJNA1148190_P_NODE_548461_length_257_cov_1.619565_g537288_i0	PRJNA1148190	548461	257	1.619565	4.16228205	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	46.2	0.00251	NR	XP_063725174.1	84072	g537288	i0	62.1	0.33852140077821	29	10	32.7	1	172	255	24	52	XP_063725174.1 uncharacterized protein LOC134853149 [Symsagittifera roscoffensis]	diamond	87	46.2	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
29049160	29049160	PRJNA1148190_P_NODE_265188_length_336_cov_0.840304_g254017_i0	PRJNA1148190	265188	336	0.840304	2.82342144	root	1	Root_unresolved	Root_unresolved	53.1	2.55e-5	NR	XP_063727469.1	84072	g254017	i0	48.2	2.41964285714286	56	29	50	0	174	7	77	132	XP_063727469.1 sodium/potassium-transporting ATPase subunit alpha-3-like [Symsagittifera roscoffensis]	diamond	813	53.1	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
30407442	30407442	PRJNA1148190_P_NODE_223933_length_359_cov_1.111888_g212763_i0	PRJNA1148190	223933	359	1.111888	3.99167792	Cryptophyceae	3027	Xenacoelomorpha	other_Eukaryota	57	1.22e-6	NR	XP_063710194.1	84072	g212763	i0	55.8	3.92757660167131	43	19	35.9	0	277	149	16	58	XP_063710194.1 casein kinase I-like isoform X2 [Symsagittifera roscoffensis]	diamond	1410	57.4	0.993031358885017	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
31924357	31924357	PRJNA1148190_P_NODE_124477_length_473_cov_1.135000_g113314_i0	PRJNA1148190	124477	473	1.135	5.36855	root	1	Root_unresolved	Root_unresolved	114	1.12e-26	NR	XP_063722914.1	84072	g113314	i0	74.7	3.32980972515856	75	19	47.6	0	380	156	135	209	XP_063722914.1 indoleacetamide hydrolase-like [Symsagittifera roscoffensis]	diamond	1575	115	0.991304347826087	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
32725895	32725895	PRJNA1148190_P_NODE_142280_length_441_cov_1.173913_g131115_i0	PRJNA1148190	142280	441	1.173913	5.17695633	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	55.1	1.29e-6	NR	XP_063721813.1	84072	g131115	i0	36.1	0.489795918367347	72	46	49	0	130	345	1	72	XP_063721813.1 large ribosomal subunit protein P2-like [Symsagittifera roscoffensis]	diamond	216	55.1	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis

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