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

6 rows where analysis = "diamond", bioproject = "PRJNA674048" 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
8296496	8296496	PRJNA674048_P_NODE_3927_length_552_cov_2.019881_g3731_i0	PRJNA674048	3927	552	2.019881	11.14974312	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	289	1.3299999999999993e-87	NR	VBB30983.1	6277	g3731	i0	76.8	21.0760869565217	185	42	100	1	1	552	677	861	VBB30983.1 unnamed protein product [Acanthocheilonema viteae]	diamond	11634	291	0.993127147766323	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Acanthocheilonema	Acanthocheilonema viteae
21045706	21045706	PRJNA674048_P_NODE_30997_length_164_cov_0.904348_g30794_i0	PRJNA674048	30997	164	0.904348	1.48313072	Opisthokonta	33154	Nematoda	Nematoda	86.7	2.92e-19	NR	VDP19351.1	241478	g30794	i0	77.8	1.97560975609756	54	12	98.8	0	162	1	124	177	VDP19351.1 unnamed protein product [Soboliphyme baturini]	diamond	324	87.4	0.991990846681922	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Dioctophymatida	Soboliphymatidae	Soboliphyme	Soboliphyme baturini
27536131	27536131	PRJNA674048_P_NODE_24563_length_177_cov_2.000000_g24360_i0	PRJNA674048	24563	177	2	3.54	Rhabditida	6236	Nematoda	Nematoda	63.9	5.02e-11	NR	KAK6039252.1	27828	g24360	i0	68.2	5.22033898305085	44	14	74.6	0	39	170	18	61	KAK6039252.1 hypothetical protein COOONC_23244 [Cooperia oncophora]	diamond	924	63.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Cooperia	Cooperia oncophora
27694212	27694212	PRJNA674048_P_NODE_27864_length_168_cov_0.873950_g27661_i0	PRJNA674048	27864	168	0.87395	1.468236	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.8	1.81e-5	NR	MCP9257320.1	6287	g27661	i0	51.1	2.60714285714286	47	22	83.9	1	2	142	278	323	MCP9257320.1 Protein phosphatase 1L [Dirofilaria immitis]	diamond	438	50.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Dirofilaria	Dirofilaria immitis
31946527	31946527	PRJNA674048_P_NODE_24437_length_178_cov_1.209302_g24234_i0	PRJNA674048	24437	178	1.209302	2.15255756	Trichinella britovi	45882	Nematoda	Nematoda	53.1	1.79e-6	NR	KRY44720.1	45882	g24234	i0	47.5	1.98876404494382	59	31	99.4	0	177	1	138	196	KRY44720.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Trichinella britovi]	diamond	354	53.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella britovi
32053525	32053525	PRJNA674048_P_NODE_25098_length_175_cov_1.650794_g24895_i0	PRJNA674048	25098	175	1.650794	2.8888895	Rhabditida	6236	Nematoda	Nematoda	45.4	0.00169	NR	KAI1720537.1	166010	g24895	i0	38.2	2.82857142857143	55	32	90.9	1	166	8	139	193	KAI1720537.1 papain family cysteine protease domain-containing protein [Ditylenchus destructor]	diamond	495	45.8	0.991266375545852	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anguinidae	Ditylenchus	Ditylenchus destructor

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