metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1120771" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1120771" 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
2827226	2827226	PRJNA1120771_S_NODE_16283_length_282_cov_3.958159_g15883_i0	PRJNA1120771	16283	282	3.958159	11.16200838	Pristionchus pacificus	54126	Nematoda	Nematoda	65.9	9.97e-11	NR	KAF8358470.1	54126	g15883	i0	50.7	1.69148936170213	67	33	71.3	0	74	274	70	136	KAF8358470.1 hypothetical protein PRIPAC_93465, partial [Pristionchus pacificus]	diamond	477	65.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
25254912	25254912	PRJNA1120771_S_NODE_9380_length_343_cov_7.383333_g8980_i0	PRJNA1120771	9380	343	7.383333	25.32483219	Dracunculus medinensis	318479	Nematoda	Nematoda	105	6.04e-24	NR	VDN53311.1	318479	g8980	i0	67.1	1.21574344023324	70	23	61.2	0	3	212	350	419	VDN53311.1 unnamed protein product [Dracunculus medinensis]	diamond	417	105	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Dracunculidae	Dracunculus	Dracunculus medinensis
28701661	28701661	PRJNA1120771_S_NODE_26607_length_233_cov_1.373684_g26207_i0	PRJNA1120771	26607	233	1.373684	3.20068372	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	102	4.27e-23	NR	CAD5234545.1	6326	g26207	i0	56.6	3.95278969957082	76	33	97.9	0	232	5	122	197	CAD5234545.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	921	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
28733223	28733223	PRJNA1120771_S_NODE_29967_length_222_cov_1.452514_g29567_i0	PRJNA1120771	29967	222	1.452514	3.22458108	Nematoda	6231	Nematoda	Nematoda	51.2	2.67e-5	NR	KFD51108.1	68888	g29567	i0	53.3	1.21621621621622	45	21	60.8	0	5	139	222	266	KFD51108.1 hypothetical protein M513_08008 [Trichuris suis]	diamond	270	51.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
30975770	30975770	PRJNA1120771_S_NODE_9654_length_340_cov_1.737374_g9254_i0	PRJNA1120771	9654	340	1.737374	5.9070716	Rhabditida	6236	Nematoda	Nematoda	94	1.26e-19	NR	VDM47119.1	6265	g9254	i0	47.6	9.06176470588235	103	52	89.1	1	1	303	631	733	VDM47119.1 unnamed protein product [Toxocara canis]	diamond	3081	94.7	0.992608236536431	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
31007230	31007230	PRJNA1120771_S_NODE_6594_length_389_cov_2.485549_g6194_i0	PRJNA1120771	6594	389	2.485549	9.66878561	Metazoa	33208	Nematoda	Nematoda	155	8.96e-41	NR	NP_001033553.1	6239	g6194	i0	62.8	13.0102827763496	113	42	87.1	0	340	2	1414	1526	NP_001033553.1 Multidrug resistance-associated protein 1 [Caenorhabditis elegans]	diamond	5061	156	0.993589743589744	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
31260100	31260100	PRJNA1120771_S_NODE_19235_length_265_cov_1.761261_g18835_i0	PRJNA1120771	19235	265	1.761261	4.66734165	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	74.3	3.71e-13	NR	NP_001293174.1	6239	g18835	i0	55.6	7.65283018867925	72	31	81.5	1	1	216	478	548	NP_001293174.1 ATP-dependent DNA helicase PIF1 [Caenorhabditis elegans]	diamond	2028	74.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
31702844	31702844	PRJNA1120771_S_NODE_12697_length_309_cov_1.605263_g12297_i0	PRJNA1120771	12697	309	1.605263	4.96026267	Metazoa	33208	Nematoda	Nematoda	54.3	7.19e-6	NR	CAD5208834.1	6326	g12297	i0	42.9	2.27184466019417	63	33	61.2	1	3	191	1151	1210	CAD5208834.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	702	54.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
32030054	32030054	PRJNA1120771_S_NODE_12698_length_309_cov_1.597744_g12298_i0	PRJNA1120771	12698	309	1.597744	4.93702896	Meloidogyne enterolobii	390850	Nematoda	Nematoda	57.4	5.44e-7	NR	CAD2186823.1	390850	g12298	i0	47.9	2.71844660194175	71	30	68.9	2	307	95	342	405	CAD2186823.1 unnamed protein product [Meloidogyne enterolobii]	diamond	840	57.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
32557392	32557392	PRJNA1120771_S_NODE_8219_length_360_cov_4.116719_g7819_i0	PRJNA1120771	8219	360	4.116719	14.8201884	Opisthokonta	33154	Nematoda	Nematoda	72	5.38e-12	NR	VDD93497.1	51028	g7819	i0	49.4	1.675	81	35	67.5	2	22	264	212	286	VDD93497.1 unnamed protein product [Enterobius vermicularis]	diamond	603	72	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Oxyuridae	Enterobius	Enterobius vermicularis

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