metadata: contig_metadata: 10 rows where bioproject = "PRJEB50332" and tax

10 rows where bioproject = "PRJEB50332" 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
3945541	3945541	PRJEB50332_P_NODE_2604_length_353_cov_1.818493_g2522_i0	PRJEB50332	2604	353	1.818493	6.41928029	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	82.4	4.26e-11	NTclustered	gi\|524845292\|gb\|KC819356.1\|	1355913	g2522	i0	88.571	1.5070821529745	70	5	20	3	12	80	324	391	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds	blastn	532	82.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus
6497711	6497711	PRJEB50332_P_NODE_5266_length_267_cov_1.893204_g5184_i0	PRJEB50332	5266	267	1.893204	5.05485468	Caenorhabditis briggsae	6238	Nematoda	Nematoda	161	3.89e-35	NTclustered	gi\|2158433782\|ref\|XM_045239146.1\|	6238	g5184	i0	78.74	8.59550561797753	254	45	93	6	3	250	758	508	Caenorhabditis briggsae Protein CBR-ACO-1 (Cbr-aco-1), partial mRNA	blastn	2295	161	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
27602415	27602415	PRJEB50332_P_NODE_10684_length_220_cov_2.264151_g10602_i0	PRJEB50332	10684	220	2.264151	4.9811322	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	44.3	0.00769	NR	GMT28504.1	1538716	g10602	i0	48.8	1.67727272727273	41	18	53.2	2	214	98	123	162	GMT28504.1 hypothetical protein PFISCL1PPCAC_19801, partial [Pristionchus fissidentatus]	diamond	369	44.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus
27981177	27981177	PRJEB50332_P_NODE_11065_length_218_cov_2.165605_g10983_i0	PRJEB50332	11065	218	2.165605	4.7210189	Caenorhabditis brenneri	135651	Nematoda	Nematoda	75.5	8.61e-15	NR	EGT33646.1	135651	g10983	i0	47.8	6.39908256880734	67	35	92.2	0	202	2	5	71	EGT33646.1 hypothetical protein CAEBREN_12943 [Caenorhabditis brenneri]	diamond	1395	75.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis brenneri
30507516	30507516	PRJEB50332_P_NODE_253_length_1000_cov_3.288605_g207_i0	PRJEB50332	253	1000	3.288605	32.88605	Meloidogyne graminicola	189291	Nematoda	Nematoda	68.2	6.06e-9	NR	AVZ46778.1	189291	g207	i0	32.4	0.426	142	94	42	1	295	714	105	246	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	426	68.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
30563627	30563627	PRJEB50332_P_NODE_9853_length_225_cov_1.585366_g9771_i0	PRJEB50332	9853	225	1.585366	3.5670735	Metazoa	33208	Nematoda	Nematoda	102	7.18e-25	NR	CAD5212188.1	6326	g9771	i0	66.2	8.81333333333333	74	25	98.7	0	224	3	21	94	CAD5212188.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	1983	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
31076322	31076322	PRJEB50332_P_NODE_575_length_717_cov_2.562500_g505_i0	PRJEB50332	575	717	2.5625	18.373125	Meloidogyne graminicola	189291	Nematoda	Nematoda	78.6	3.52e-13	NR	AVZ46778.1	189291	g505	i0	55.7	0.330543933054393	79	34	32.6	1	1	234	168	246	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	237	78.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
31107641	31107641	PRJEB50332_P_NODE_18595_length_180_cov_7.621849_g18513_i0	PRJEB50332	18595	180	7.621849	13.7193282	Meloidogyne enterolobii	390850	Nematoda	Nematoda	62	2.29e-9	NR	CAD2184554.1	390850	g18513	i0	50.8	5.63333333333333	59	29	98.3	0	180	4	4	62	CAD2184554.1 unnamed protein product [Meloidogyne enterolobii]	diamond	1014	62	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
31297419	31297419	PRJEB50332_P_NODE_1615_length_438_cov_4.522546_g1534_i0	PRJEB50332	1615	438	4.522546	19.80875148	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	92.8	4.2400000000000005e-21	NR	GMT18625.1	1538716	g1534	i0	42	0.897260273972603	131	70	89	3	434	45	1	126	GMT18625.1 hypothetical protein PFISCL1PPCAC_9922 [Pristionchus fissidentatus]	diamond	393	92.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus
32783149	32783149	PRJEB50332_P_NODE_7400_length_239_cov_1.460674_g7318_i0	PRJEB50332	7400	239	1.460674	3.49101086	Meloidogyne graminicola	189291	Nematoda	Nematoda	70.9	2.28e-12	NR	AVZ46778.1	189291	g7318	i0	53.9	0.95397489539749	76	35	95.4	0	237	10	122	197	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	228	70.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola

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