metadata: contig_metadata: 10 rows where bioproject = "PRJEB12982", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJEB12982", tax_clade = "Opisthokonta" 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
18837507	18837507	PRJEB12982_P_NODE_6695_length_282_cov_1.751073_g6532_i0	PRJEB12982	6695	282	1.751073	4.93802586	Caenorhabditis	6237	Nematoda	Nematoda	294	3.91e-75	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g6532	i0	87.549	92.9397163120567	257	28	90	4	23	277	1307	1053	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	26209	294	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
20421625	20421625	PRJEB12982_P_NODE_18937_length_164_cov_0.886957_g18774_i0	PRJEB12982	18937	164	0.886957	1.45460948	Strongyloides ratti	34506	Nematoda	Nematoda	135	1.32e-27	NTclustered	gi\|1376138189\|ref\|XM_024649290.1\|	34506	g18774	i0	82.317	1	164	21	98	6	1	160	1311	1470	Strongyloides ratti Probable glutamine--tRNA ligase (SRAE_1000223700), partial mRNA	blastn	164	135	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
22662629	22662629	PRJEB12982_P_NODE_19098_length_164_cov_0.886957_g18935_i0	PRJEB12982	19098	164	0.886957	1.45460948	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	67.6	4.89e-7	NTclustered	gi\|946978308\|gb\|KP986799.1\|	1748612	g18935	i0	87.931	1.71341463414634	58	6	35	1	1	57	373	430	Desmoscolecidae sp. 683_5-1500_X 28S ribosomal RNA gene, partial sequence	blastn	281	67.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Desmoscolecida	Desmoscolecidae		Desmoscolecidae sp. 683_5-1500_X
27437793	27437793	PRJEB12982_P_NODE_11123_length_211_cov_1.259259_g10960_i0	PRJEB12982	11123	211	1.259259	2.65703649	Metazoa	33208	Nematoda	Nematoda	67.8	1.02e-12	NR	CDQ07605.1	6279	g10960	i0	63.2	19.478672985782	57	21	81	0	174	4	27	83	CDQ07605.1 Bm11937 [Brugia malayi]	diamond	4110	67.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
27532243	27532243	PRJEB12982_P_NODE_11643_length_206_cov_1.617834_g11480_i0	PRJEB12982	11643	206	1.617834	3.33273804	Rhabditida	6236	Nematoda	Nematoda	65.1	3.78e-11	NR	XP_042931666.1	6279	g11480	i0	55.1	7.82038834951456	49	22	71.4	0	155	9	42	90	XP_042931666.1 60S ribosomal protein L23a, putative [Brugia malayi]	diamond	1611	65.5	0.993893129770992	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
29710475	29710475	PRJEB12982_P_NODE_4870_length_340_cov_1.092784_g4707_i0	PRJEB12982	4870	340	1.092784	3.7154656	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	155	5.689999999999999e-46	NR	VDN82626.1	6280	g4707	i0	77	110.752941176471	100	23	88.2	0	1	300	65	164	VDN82626.1 unnamed protein product [Brugia pahangi]	diamond	37656	156	0.993589743589744	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia pahangi
29811786	29811786	PRJEB12982_P_NODE_19131_length_164_cov_0.886957_g18968_i0	PRJEB12982	19131	164	0.886957	1.45460948	Caenorhabditis angaria	860376	Nematoda	Nematoda	46.2	7.69e-4	NR	CAI5446104.1	860376	g18968	i0	75.9	1.07926829268293	29	7	53	0	3	89	1296	1324	CAI5446104.1 unnamed protein product [Caenorhabditis angaria]	diamond	177	46.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis angaria
30816585	30816585	PRJEB12982_P_NODE_5614_length_314_cov_1.316981_g5451_i0	PRJEB12982	5614	314	1.316981	4.13532034	root	1	Root_unresolved	Root_unresolved	110	1.93e-25	NR	KAI1716765.1	166010	g5451	i0	48.5	7.92993630573248	103	53	98.4	0	5	313	601	703	KAI1716765.1 elongation factor tu GTP binding domain-containing protein [Ditylenchus destructor]	diamond	2490	110	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anguinidae	Ditylenchus	Ditylenchus destructor
31258992	31258992	PRJEB12982_P_NODE_5015_length_335_cov_1.066434_g4852_i0	PRJEB12982	5015	335	1.066434	3.5725539	Metazoa	33208	Nematoda	Nematoda	158	2.6399999999999992e-43	NR	NP_001022078.1	6239	g4852	i0	66.7	8.94626865671642	111	37	99.4	0	2	334	322	432	NP_001022078.1 putative methylmalonate-semialdehyde/malonate-semialdehyde dehydrogenase [acylating], mitochondrial [Caenorhabditis elegans]	diamond	2997	158	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
32492924	32492924	PRJEB12982_P_NODE_20319_length_162_cov_0.902655_g20156_i0	PRJEB12982	20319	162	0.902655	1.4623011	Opisthokonta	33154	Nematoda	Nematoda	79.7	1.12e-15	NR	XP_024506970.1	34506	g20156	i0	71.2	29.962962962963	52	15	96.3	0	161	6	277	328	XP_024506970.1 Glycine--tRNA ligase [Strongyloides ratti]	diamond	4854	79.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti

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