metadata: contig_metadata: 10 rows where bioproject = "PRJNA760976", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA760976", 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
10946498	10946498	PRJNA760976_P_NODE_49769_length_248_cov_0.880000_g49448_i0	PRJNA760976	49769	248	0.88	2.1824	Opisthokonta	33154	Nematoda	Nematoda	110	2.78e-27	NR	TKR76333.1	34508	g49448	i0	63.3	51.4112903225806	79	27	93.1	1	248	18	93	171	TKR76333.1 hypothetical protein L596_017486 [Steinernema carpocapsae]	diamond	12750	111	0.990990990990991	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae
14771323	14771323	PRJNA760976_P_NODE_50372_length_247_cov_0.885057_g50051_i0	PRJNA760976	50372	247	0.885057	2.18609079	Micoletzkya palliati	1250334	Nematoda	Nematoda	165	2.75e-36	NTclustered	gi\|410992319\|gb\|JX163988.1\|	1250334	g50051	i0	84.118	4.4412955465587	170	27	69	0	32	201	170	1	Micoletzkya palliati large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds	blastn	1097	165	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Micoletzkya	Micoletzkya palliati
21144932	21144932	PRJNA760976_P_NODE_34797_length_286_cov_1.953052_g34476_i0	PRJNA760976	34797	286	1.953052	5.58572872	root	1	Root_unresolved	Root_unresolved	154	1.34e-45	NR	XP_053590740.1	31234	g34476	i0	83.7	47.958041958042	86	14	90.2	0	28	285	3	88	XP_053590740.1 hypothetical protein GCK72_007936 [Caenorhabditis remanei]	diamond	13716	154	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
21607191	21607191	PRJNA760976_P_NODE_40537_length_270_cov_1.360406_g40216_i0	PRJNA760976	40537	270	1.360406	3.6730962	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	135	9.51e-36	NR	VDK43813.1	6269	g40216	i0	71.6	49.3444444444444	88	25	97.8	0	268	5	54	141	VDK43813.1 unnamed protein product [Anisakis simplex]	diamond	13323	135	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anisakidae	Anisakis	Anisakis simplex
23695248	23695248	PRJNA760976_P_NODE_12339_length_415_cov_1.081871_g12019_i0	PRJNA760976	12339	415	1.081871	4.48976465	Caenorhabditis briggsae	6238	Nematoda	Nematoda	254	1.02e-62	NTclustered	gi\|268580870\|ref\|XM_002645372.1\|	6238	g12019	i0	82.807	17.7084337349398	285	48	68	1	75	358	938	654	Caenorhabditis briggsae Protein CBR-SAMS-1 (Cbr-sams-1), partial mRNA	blastn	7349	254	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
28253209	28253209	PRJNA760976_P_NODE_40706_length_269_cov_2.290816_g40385_i0	PRJNA760976	40706	269	2.290816	6.16229504	Koerneria luziae	912562	Nematoda	Nematoda	75.1	1.93e-14	NR	AIL48340.1	912562	g40385	i0	54.9	1.58364312267658	71	31	79.2	1	214	2	1	70	AIL48340.1 large subunit ribosomal protein 9, partial [Koerneria luziae]	diamond	426	75.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Koerneria	Koerneria luziae
28452580	28452580	PRJNA760976_P_NODE_40286_length_271_cov_0.939394_g39965_i0	PRJNA760976	40286	271	0.939394	2.54575774	Nematoda	6231	Nematoda	Nematoda	121	1.4e-32	NR	VDD86189.1	51028	g39965	i0	58.9	13.8819188191882	90	37	99.6	0	1	270	34	123	VDD86189.1 unnamed protein product [Enterobius vermicularis]	diamond	3762	121	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Oxyuridae	Enterobius	Enterobius vermicularis
28547373	28547373	PRJNA760976_P_NODE_16307_length_375_cov_1.016556_g15986_i0	PRJNA760976	16307	375	1.016556	3.812085	Metazoa	33208	Nematoda	Nematoda	158	7.209999999999998e-47	NR	KHN76788.1	6265	g15986	i0	68.8	14.264	112	34	89.6	1	39	374	14	124	KHN76788.1 40S ribosomal protein S15 [Toxocara canis]	diamond	5349	158	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
30663110	30663110	PRJNA760976_P_NODE_40333_length_270_cov_2.284264_g40012_i0	PRJNA760976	40333	270	2.284264	6.1675128	Rhabditida	6236	Nematoda	Nematoda	79.7	2.81e-15	NR	RCN45279.1	29170	g40012	i0	44.9	4.94444444444444	89	47	97.8	2	4	267	234	321	RCN45279.1 NAD dependent epimerase/dehydratase family protein [Ancylostoma caninum]	diamond	1335	79.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma caninum
30821142	30821142	PRJNA760976_P_NODE_2174_length_862_cov_2.359949_g1904_i0	PRJNA760976	2174	862	2.359949	20.34276038	root	1	Root_unresolved	Root_unresolved	75.9	3.22e-12	NR	ACD12696.1	135651	g1904	i0	48.6	0.730858468677494	70	35	24.4	1	613	404	39	107	ACD12696.1 initiation factor, partial [Caenorhabditis brenneri]	diamond	630	76.6	0.990861618798956	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis brenneri

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