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

8 rows where analysis = "diamond", bioproject = "PRJNA814235" 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
16528640	16528640	PRJNA814235_P_NODE_145053_length_179_cov_1.922535_g143658_i0	PRJNA814235	145053	179	1.922535	3.44133765	Dictyocaulus viviparus	29172	Nematoda	Nematoda	127	2.19e-32	NR	KJH40125.1	29172	g143658	i0	98.3	0.988826815642458	59	1	98.9	0	179	3	130	188	KJH40125.1 homeobox domain protein [Dictyocaulus viviparus]	diamond	177	127	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Dictyocaulus	Dictyocaulus viviparus
29706543	29706543	PRJNA814235_P_NODE_196750_length_150_cov_4.486726_g195355_i0	PRJNA814235	196750	150	4.486726	6.730089	Trichinella spiralis	6334	Nematoda	Nematoda	43.9	0.00337	NR	XP_003375610.1	6334	g195355	i0	59.3	1.1	27	11	54	0	148	68	17	43	XP_003375610.1 zinc finger protein [Trichinella spiralis]	diamond	165	43.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
29801637	29801637	PRJNA814235_P_NODE_97351_length_203_cov_2.590361_g95956_i0	PRJNA814235	97351	203	2.590361	5.25843283	Necator americanus	51031	Nematoda	Nematoda	50.8	2.57e-5	NR	ETN71555.1	51031	g95956	i0	95.8	0.354679802955665	24	1	35.5	0	74	3	61	84	ETN71555.1 Replication protein [Necator americanus]	diamond	72	50.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
30622928	30622928	PRJNA814235_P_NODE_125913_length_200_cov_1.815951_g124518_i0	PRJNA814235	125913	200	1.815951	3.631902	Necator americanus	51031	Nematoda	Nematoda	122	1.1e-32	NR	ETN79591.1	51031	g124518	i0	87.9	2.97	66	8	99	0	200	3	56	121	ETN79591.1 Replication protein [Necator americanus]	diamond	594	122	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
31002394	31002394	PRJNA814235_P_NODE_92534_length_203_cov_3.000000_g91139_i0	PRJNA814235	92534	203	3	6.09	Aphelenchoides avenae	70226	Nematoda	Nematoda	46.6	9.4e-4	NR	KAH7717977.1	70226	g91139	i0	70.8	1.064039408867	24	7	35.5	0	203	132	135	158	KAH7717977.1 Protein OAC-37 [Aphelenchoides avenae]	diamond	216	46.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides avenae
31928010	31928010	PRJNA814235_P_NODE_29697_length_351_cov_2.732484_g28314_i0	PRJNA814235	29697	351	2.732484	9.59101884	root	1	Root_unresolved	Root_unresolved	154	2.85e-44	NR	VDO17378.1	42155	g28314	i0	97.5	1.38461538461538	81	2	69.2	0	109	351	1	81	VDO17378.1 unnamed protein product, partial [Brugia timori]	diamond	486	154	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia timori
32077522	32077522	PRJNA814235_P_NODE_187198_length_151_cov_3.438596_g185803_i0	PRJNA814235	187198	151	3.438596	5.19227996	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	59.7	1.11e-8	NR	KAE9556064.1	2598192	g185803	i0	52.4	1.25165562913907	63	9	83.4	1	26	151	190	252	KAE9556064.1 hypothetical protein FO519_000698 [Halicephalobus sp. NKZ332]	diamond	189	59.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332
32212883	32212883	PRJNA814235_P_NODE_153778_length_171_cov_2.477612_g152383_i0	PRJNA814235	153778	171	2.477612	4.23671652	Metazoa	33208	Nematoda	Nematoda	45.4	0.00156	NR	KAK6018137.1	6317	g152383	i0	56.7	1.07017543859649	30	13	52.6	0	3	92	396	425	KAK6018137.1 hypothetical protein OSTOST_16290 [Ostertagia ostertagi]	diamond	183	45.8	0.991266375545852	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Ostertagia	Ostertagia ostertagi

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