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

6 rows where analysis = "diamond", bioproject = "PRJNA473641" and tax_phylum = "Nematoda"

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
28229106	28229106	PRJNA473641_P_NODE_17366_length_251_cov_0.865169_g17283_i0	PRJNA473641	17366	251	0.865169	2.17157419	Metazoa	33208	Nematoda	Nematoda	86.7	1.27e-17	NR	KRY42074.1	6334	g17283	i0	54.2	6.88446215139442	83	34	99.2	2	1	249	351	429	KRY42074.1 Carbonyl reductase [NADPH] 1, partial [Trichinella spiralis]	diamond	1728	86.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
28829137	28829137	PRJNA473641_P_NODE_15728_length_261_cov_2.239362_g15645_i0	PRJNA473641	15728	261	2.239362	5.84473482	Trichinella	6333	Nematoda	Nematoda	96.3	7.04e-21	NR	KRY41319.1	6334	g15645	i0	64.9	6.81609195402299	74	26	85.1	0	246	25	101	174	KRY41319.1 High mobility group protein 1.2, partial [Trichinella spiralis]	diamond	1779	96.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
29981415	29981415	PRJNA473641_P_NODE_17251_length_251_cov_0.865169_g17168_i0	PRJNA473641	17251	251	0.865169	2.17157419	Diploscapter pachys	2018661	Nematoda	Nematoda	47.4	9.62e-4	NR	PAV77013.1	2018661	g17168	i0	42.9	0.585657370517928	49	25	55	1	112	249	8	56	PAV77013.1 hypothetical protein WR25_00130 [Diploscapter pachys]	diamond	147	47.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Diploscapter	Diploscapter pachys
30060576	30060576	PRJNA473641_P_NODE_25091_length_242_cov_0.911243_g25008_i0	PRJNA473641	25091	242	0.911243	2.20520806	Opisthokonta	33154	Nematoda	Nematoda	119	1.36e-31	NR	PIO59950.1	45464	g25008	i0	83.1	9.60743801652893	65	11	80.6	0	242	48	9	73	PIO59950.1 WD domain, G-beta repeat protein [Teladorsagia circumcincta]	diamond	2325	120	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Teladorsagia	Teladorsagia circumcincta
31466820	31466820	PRJNA473641_P_NODE_23136_length_244_cov_0.900585_g23053_i0	PRJNA473641	23136	244	0.900585	2.1974274	Haemonchus placei	6290	Nematoda	Nematoda	63.5	9.91e-10	NR	VDO67525.1	6290	g23053	i0	36.7	3.86065573770492	79	40	97.1	2	239	3	75	143	VDO67525.1 unnamed protein product [Haemonchus placei]	diamond	942	63.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Haemonchus	Haemonchus placei
31514716	31514716	PRJNA473641_P_NODE_17596_length_251_cov_0.865169_g17513_i0	PRJNA473641	17596	251	0.865169	2.17157419	Caenorhabditis	6237	Nematoda	Nematoda	127	5.11e-32	NR	CAI5456095.1	860376	g17513	i0	67.1	5.8804780876494	82	27	98	0	246	1	353	434	CAI5456095.1 unnamed protein product [Caenorhabditis angaria]	diamond	1476	127	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis angaria

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