metadata: contig_metadata: 6 rows where bioproject = "PRJEB12366" and tax

6 rows where bioproject = "PRJEB12366" 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
19146289	19146289	PRJEB12366_P_NODE_4216_length_409_cov_1.815508_g4026_i0	PRJEB12366	4216	409	1.815508	7.42542772	Loa loa	7209	Nematoda	Nematoda	235	3.63e-57	NTclustered	gi\|1158591300\|ref\|XM_003136814.2\|	7209	g4026	i0	84.146	9.08557457212714	246	35	59	3	2	243	683	928	Loa loa CK1/CK1/CK1-A protein kinase mRNA	blastn	3716	235	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Loa	Loa loa
22972779	22972779	PRJEB12366_P_NODE_6939_length_303_cov_2.082090_g6749_i0	PRJEB12366	6939	303	2.08209	6.3087327	Strongyloides ratti	34506	Nematoda	Nematoda	246	1.21e-60	NTclustered	gi\|1376157149\|ref\|XM_024646005.1\|	34506	g6749	i0	85.654	15.6204620462046	237	30	78	3	59	293	1078	844	Strongyloides ratti 26S protease regulatory subunit 4 (SRAE_0000015400), partial mRNA	blastn	4733	246	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
25211726	25211726	PRJEB12366_P_NODE_6320_length_322_cov_1.780488_g6130_i0	PRJEB12366	6320	322	1.780488	5.73317136	Metazoa	33208	Nematoda	Nematoda	342	1.6e-89	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g6130	i0	86.207	97.5527950310559	319	40	98	4	3	319	1307	991	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	31412	342	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
27096161	27096161	PRJEB12366_P_NODE_14482_length_188_cov_1.568627_g14292_i0	PRJEB12366	14482	188	1.568627	2.94901876	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	62.8	2.25e-10	NR	KAE9551459.1	2598192	g14292	i0	73.2	1.32446808510638	41	11	65.4	0	66	188	40	80	KAE9551459.1 hypothetical protein FO519_005332 [Halicephalobus sp. NKZ332]	diamond	249	62.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332
27127424	27127424	PRJEB12366_P_NODE_17062_length_168_cov_2.105263_g16872_i0	PRJEB12366	17062	168	2.105263	3.53684184	Trichostrongylus colubriformis	6319	Nematoda	Nematoda	67.4	2.67e-11	NR	KAK5972438.1	6319	g16872	i0	69.1	5.125	55	17	98.2	0	166	2	1608	1662	KAK5972438.1 MYOsin heavy chain structural protein, partial [Trichostrongylus colubriformis]	diamond	861	67.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Trichostrongylus	Trichostrongylus colubriformis
31929516	31929516	PRJEB12366_P_NODE_8397_length_269_cov_1.337607_g8207_i0	PRJEB12366	8397	269	1.337607	3.59816283	Enterobius vermicularis	51028	Nematoda	Nematoda	133	8.45e-34	NR	VDD92819.1	51028	g8207	i0	67.4	0.992565055762082	89	29	99.3	0	267	1	43	131	VDD92819.1 unnamed protein product [Enterobius vermicularis]	diamond	267	133	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Oxyuridae	Enterobius	Enterobius vermicularis

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