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

5 rows where analysis = "diamond", bioproject = "PRJNA358049" 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
26979879	26979879	PRJNA358049_S_NODE_7582_length_227_cov_1.696629_g7534_i0	PRJNA358049	7582	227	1.696629	3.85134783	Ostertagia ostertagi	6317	Nematoda	Nematoda	52.4	7.15e-6	NR	KAK6009987.1	6317	g7534	i0	51.9	0.687224669603524	52	17	58.1	1	136	5	41	92	KAK6009987.1 hypothetical protein OSTOST_25051 [Ostertagia ostertagi]	diamond	156	52.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Ostertagia	Ostertagia ostertagi
27738584	27738584	PRJNA358049_S_NODE_5964_length_252_cov_1.315271_g5916_i0	PRJNA358049	5964	252	1.315271	3.31448292	Polypterus senegalus	55291	Chordata	Chordata	61.2	6.7e-9	NR	XP_039600642.1	55291	g5916	i0	68.3	1	41	13	48.8	0	45	167	192	232	XP_039600642.1 E3 SUMO-protein ligase ZBED1-like [Polypterus senegalus]	diamond	252	61.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
31528708	31528708	PRJNA358049_S_NODE_15716_length_169_cov_2.216667_g15668_i0	PRJNA358049	15716	169	2.216667	3.74616723	Galendromus occidentalis	34638	Arthropoda	Arthropoda	105	1.41e-24	NR	XP_003747941.1	34638	g15668	i0	100	0.869822485207101	49	0	87	0	159	13	18	66	XP_003747941.1 membralin [Galendromus occidentalis]	diamond	147	105	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Mesostigmata	Phytoseiidae	Galendromus	Galendromus occidentalis
31749833	31749833	PRJNA358049_S_NODE_2557_length_370_cov_2.236760_g2509_i0	PRJNA358049	2557	370	2.23676	8.276012	Diadema antillarum	105358	Echinodermata	other_Eukaryota	44.3	0.0456	NR	XP_071506122.1	105358	g2509	i0	37.9	0.535135135135135	66	38	53.5	1	204	7	290	352	XP_071506122.1 uncharacterized protein [Diadema antillarum]	diamond	198	44.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
31908152	31908152	PRJNA358049_S_NODE_4217_length_293_cov_1.754098_g4169_i0	PRJNA358049	4217	293	1.754098	5.13950714	Chironomus riparius	315576	Arthropoda	Arthropoda	90.1	6.92e-20	NR	CAG9809115.1	315576	g4169	i0	59.8	1.60750853242321	87	30	84	1	16	261	125	211	CAG9809115.1 unnamed protein product [Chironomus riparius]	diamond	471	90.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus riparius

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