metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA235310" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA235310" 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
14396426	14396426	PRJNA235310_P_NODE_452_length_551_cov_7.432271_g428_i0	PRJNA235310	452	551	7.432271	40.95181321	Opisthokonta	33154	Nematoda	Nematoda	216	3.4499999999999993e-68	NR	KFD50978.1	68888	g428	i0	71.6	17.1778584392015	148	42	80.6	0	546	103	51	198	KFD50978.1 hypothetical protein M513_08161, partial [Trichuris suis]	diamond	9465	216	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
18219079	18219079	PRJNA235310_P_NODE_575_length_503_cov_2.781938_g550_i0	PRJNA235310	575	503	2.781938	13.99314814	Metazoa	33208	Nematoda	Nematoda	139	2.68e-35	NR	KAH7732279.1	70226	g550	i0	57.5	3.73359840954274	120	44	67.4	1	112	450	26	145	KAH7732279.1 procollagen-proline dioxygenase beta subunit [Aphelenchoides avenae]	diamond	1878	140	0.992857142857143	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides avenae
28653061	28653061	PRJNA235310_P_NODE_1287_length_355_cov_1.833333_g1261_i0	PRJNA235310	1287	355	1.833333	6.50833215	Enterobius vermicularis	51028	Nematoda	Nematoda	153	1.03e-42	NR	VDD94634.1	51028	g1261	i0	83.5	14.4169014084507	85	14	71.8	0	353	99	260	344	VDD94634.1 unnamed protein product [Enterobius vermicularis]	diamond	5118	153	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Oxyuridae	Enterobius	Enterobius vermicularis
31116406	31116406	PRJNA235310_P_NODE_4915_length_169_cov_0.866667_g4889_i0	PRJNA235310	4915	169	0.866667	1.46466723	Pristionchus entomophagus	358040	Nematoda	Nematoda	52.8	4.04e-6	NR	GMS80544.1	358040	g4889	i0	44.1	1.04733727810651	59	23	87	2	5	151	395	453	GMS80544.1 hypothetical protein PENTCL1PPCAC_2719, partial [Pristionchus entomophagus]	diamond	177	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus entomophagus
31116408	31116408	PRJNA235310_P_NODE_6295_length_162_cov_0.920354_g6269_i0	PRJNA235310	6295	162	0.920354	1.49097348	Aphelenchoides besseyi	269767	Nematoda	Nematoda	95.5	3.1600000000000003e-21	NR	KAI6214930.1	269767	g6269	i0	77.4	16.6851851851852	53	12	98.1	0	161	3	942	994	KAI6214930.1 Dihydropyrimidine dehydrogenase [NADP(+)] [Aphelenchoides besseyi]	diamond	2703	96.3	0.991692627206646	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
31274654	31274654	PRJNA235310_P_NODE_4155_length_184_cov_1.925926_g4129_i0	PRJNA235310	4155	184	1.925926	3.54370384	Caenorhabditis angaria	860376	Nematoda	Nematoda	78.6	3.86e-15	NR	CAI5454464.1	860376	g4129	i0	61.7	1.95652173913043	60	23	97.8	0	182	3	281	340	CAI5454464.1 unnamed protein product [Caenorhabditis angaria]	diamond	360	78.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis angaria
31355856	31355856	PRJNA235310_P_NODE_4116_length_185_cov_1.911765_g4090_i0	PRJNA235310	4116	185	1.911765	3.53676525	Rhabditida	6236	Nematoda	Nematoda	43.1	0.00875	NR	KAL3998645.1	6277	g4090	i0	50	5.83783783783784	40	19	64.9	1	6	125	131	169	KAL3998645.1 ETC complex I subunit conserved region family protein [Acanthocheilonema viteae]	diamond	1080	43.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Acanthocheilonema	Acanthocheilonema viteae
32160607	32160607	PRJNA235310_P_NODE_3458_length_203_cov_1.181818_g3432_i0	PRJNA235310	3458	203	1.181818	2.39909054	Trichuris suis	68888	Nematoda	Nematoda	50.4	4.3e-5	NR	KHJ48732.1	68888	g3432	i0	36.9	2.83743842364532	65	41	96.1	0	1	195	1644	1708	KHJ48732.1 hypothetical protein D918_01036 [Trichuris suis]	diamond	576	50.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis

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