metadata: contig_metadata: 6 rows where bioproject = "PRJNA255848", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA255848", tax_kingdom = "Metazoa" 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
29523294	29523294	PRJNA255848_P_NODE_32910_length_173_cov_1.193548_g32592_i0	PRJNA255848	32910	173	1.193548	2.06483804	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	114	4.9e-28	NR	KHN89100.1	6265	g32592	i0	96.5	250.040462427746	57	2	98.8	0	2	172	311	367	KHN89100.1 26S protease regulatory subunit 4 [Toxocara canis]	diamond	43257	115	0.991304347826087	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
29902308	29902308	PRJNA255848_P_NODE_31451_length_177_cov_1.445312_g31133_i0	PRJNA255848	31451	177	1.445312	2.55820224	Opisthokonta	33154	Nematoda	Nematoda	92.4	1.85e-22	NR	VDK43645.1	6269	g31133	i0	100	203.796610169492	36	0	61	0	1	108	82	117	VDK43645.1 unnamed protein product [Anisakis simplex]	diamond	36072	92.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anisakidae	Anisakis	Anisakis simplex
30913394	30913394	PRJNA255848_P_NODE_29034_length_185_cov_0.926471_g28716_i0	PRJNA255848	29034	185	0.926471	1.71397135	Metazoa	33208	Nematoda	Nematoda	133	3.14e-36	NR	NP_001369970.1	6239	g28716	i0	96.7	183.891891891892	60	2	97.3	0	184	5	199	258	NP_001369970.1 Serine/threonine-protein phosphatase 2A catalytic subunit [Caenorhabditis elegans]	diamond	34020	134	0.992537313432836	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
31496326	31496326	PRJNA255848_P_NODE_8696_length_357_cov_2.438312_g8378_i0	PRJNA255848	8696	357	2.438312	8.70477384	Caenorhabditis bovis	2654633	Nematoda	Nematoda	82.4	1.56e-15	NR	CAB3409849.1	2654633	g8378	i0	58.8	0.672268907563025	80	26	65.5	2	3	236	170	244	CAB3409849.1 unnamed protein product [Caenorhabditis bovis]	diamond	240	82.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis bovis
31640316	31640316	PRJNA255848_P_NODE_26156_length_195_cov_0.883562_g25838_i0	PRJNA255848	26156	195	0.883562	1.7229459	Opisthokonta	33154	Nematoda	Nematoda	122	3.36e-31	NR	NP_491672.1	6239	g25838	i0	96.9	322	65	2	100	0	1	195	245	309	NP_491672.1 26S protease regulatory subunit 6A [Caenorhabditis elegans]	diamond	62790	123	0.991869918699187	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
32160637	32160637	PRJNA255848_P_NODE_42138_length_164_cov_0.886957_g41820_i0	PRJNA255848	42138	164	0.886957	1.45460948	Soboliphyme baturini	241478	Nematoda	Nematoda	106	5.08e-26	NR	VDP18247.1	241478	g41820	i0	90.4	0.951219512195122	52	5	95.1	0	159	4	272	323	VDP18247.1 unnamed protein product [Soboliphyme baturini]	diamond	156	106	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Dioctophymatida	Soboliphymatidae	Soboliphyme	Soboliphyme baturini

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