metadata: contig_metadata: 5 rows where bioproject = "PRJNA615175", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA615175", 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
15897985	15897985	PRJNA615175_P_NODE_3233_length_864_cov_96.266751_g3091_i0	PRJNA615175	3233	864	96.266751	831.74472864	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	250	4.26e-79	NR	EPB74870.1	53326	g3091	i0	48	35.7430555555556	248	128	85.8	1	85	825	5	252	EPB74870.1 ribosomal protein L30p/L7e [Ancylostoma ceylanicum]	diamond	30882	251	0.99601593625498	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma ceylanicum
20997254	20997254	PRJNA615175_P_NODE_26437_length_260_cov_2.470588_g26269_i0	PRJNA615175	26437	260	2.470588	6.4235288	Caenorhabditis briggsae	6238	Nematoda	Nematoda	178	3.749999999999999e-40	NTclustered	gi\|268553132\|ref\|XM_002634504.1\|	6238	g26269	i0	79.07	88.0307692307692	258	54	99	0	1	258	381	124	Caenorhabditis briggsae Protein CBR-RPS-14 (Cbr-rps-14), partial mRNA	blastn	22888	178	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
23547302	23547302	PRJNA615175_P_NODE_14879_length_366_cov_4.324232_g14711_i0	PRJNA615175	14879	366	4.324232	15.82668912	Caenorhabditis remanei	31234	Nematoda	Nematoda	235	3.2099999999999996e-57	NTclustered	gi\|2445393344\|ref\|XM_003117517.2\|	31234	g14711	i0	78.495	50.2568306010929	372	71	100	9	1	366	980	612	Caenorhabditis remanei uncharacterized protein (GCK72_024033), partial mRNA	blastn	18394	235	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
28893210	28893210	PRJNA615175_P_NODE_12248_length_410_cov_1.569733_g12080_i0	PRJNA615175	12248	410	1.569733	6.4359053	Rhabditida	6236	Nematoda	Nematoda	106	7.379999999999999e-24	NR	VDD87253.1	51028	g12080	i0	43	3.99512195121951	135	74	96.6	1	404	9	105	239	VDD87253.1 unnamed protein product [Enterobius vermicularis]	diamond	1638	106	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Oxyuridae	Enterobius	Enterobius vermicularis
32198410	32198410	PRJNA615175_P_NODE_1358_length_1269_cov_4.387960_g1265_i0	PRJNA615175	1358	1269	4.38796	55.6832124	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	84.7	2.39e-13	NR	GMT30636.1	1538716	g1265	i0	32.4	0.867612293144208	182	108	42.1	5	694	161	60	230	GMT30636.1 hypothetical protein PFISCL1PPCAC_21933 [Pristionchus fissidentatus]	diamond	1101	84.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus

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