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

5 rows where analysis = "diamond", bioproject = "PRJEB12296" and tax_kingdom = "Metazoa"

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
32908012	32908012	PRJEB12296_S_NODE_10425_length_171_cov_4.036765_g10393_i0	PRJEB12296	10425	171	4.036765	6.90286815	Nephila pilipes	299642	Arthropoda	Arthropoda	55.5	7.8e-8	NR	GFT29937.1	299642	g10393	i0	81.8	2.52631578947368	33	6	57.9	0	5	103	101	133	GFT29937.1 60S ribosomal protein L35a [Nephila pilipes]	diamond	432	55.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Nephila	Nephila pilipes
32990892	32990892	PRJEB12296_S_NODE_3779_length_234_cov_7.422111_g3747_i0	PRJEB12296	3779	234	7.422111	17.36773974	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.1	3.87e-4	NR	Q4KTE2.1	55567	g3747	i0	45.8	1.24358974358974	48	26	61.5	0	6	149	190	237	Q4KTE2.1 RecName: Full=Small ribosomal subunit protein uS2; AltName: Full=40S ribosomal protein SA [Suberites domuncula]	diamond	291	48.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula
33044764	33044764	PRJEB12296_S_NODE_6525_length_194_cov_2.012579_g6493_i0	PRJEB12296	6525	194	2.012579	3.90440326	Idotea baltica	82763	Arthropoda	Arthropoda	93.6	1.41e-21	NR	MCL4112850.1	82763	g6493	i0	79.2	1.59278350515464	53	11	82	0	1	159	184	236	MCL4112850.1 hypothetical protein [Idotea baltica]	diamond	309	93.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
33130095	33130095	PRJEB12296_S_NODE_3655_length_237_cov_3.292079_g3623_i0	PRJEB12296	3655	237	3.292079	7.80222723	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	60.8	1.96e-9	NR	CAF0775232.1	104777	g3623	i0	53.7	0.683544303797468	54	25	68.4	0	237	76	90	143	CAF0775232.1 unnamed protein product [Brachionus calyciflorus]	diamond	162	60.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
33144214	33144214	PRJEB12296_S_NODE_15127_length_158_cov_0.975610_g15095_i0	PRJEB12296	15127	158	0.97561	1.5414638	Opisthokonta	33154	Chordata	Chordata	43.5	0.00258	NR	XP_019639315.1	7741	g15095	i0	48.8	2.33544303797468	41	17	77.8	1	4	126	94	130	XP_019639315.1 PREDICTED: profilin-1A-like [Branchiostoma belcheri]	diamond	369	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri

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