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

5 rows where bioproject = "PRJNA400391", 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
1688913	1688913	PRJNA400391_S_NODE_4322_length_193_cov_3.145570_g4261_i0	PRJNA400391	4322	193	3.14557	6.0709501	Nematoda environmental sample	554024	Nematoda	Nematoda	333	5.309999999999999e-87	NTclustered	gi\|57833964\|emb\|AJ875122.1\|	554024	g4261	i0	100	81.6269430051813	180	0	93	0	14	193	1089	910	Uncultured nematode partial 18S rRNA gene, clone SType 5	blastn	15754	333	1	Eukaryota	Opisthokonta	Metazoa	Nematoda					Nematoda environmental sample
1688933	1688933	PRJNA400391_S_NODE_5162_length_174_cov_1.539568_g5101_i0	PRJNA400391	5162	174	1.539568	2.67884832	Protozoophaga obesa	435737	Nematoda	Nematoda	69.4	1.45e-7	NTclustered	gi\|1360814132\|gb\|KY857890.1\|	435737	g5101	i0	83.117	0.71264367816092	77	11	43	1	16	90	632	708	Protozoophaga obesa isolate SAN-8284 28S ribosomal RNA gene, partial sequence	blastn	124	69.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Oxyuridae	Protozoophaga	Protozoophaga obesa
8733871	8733871	PRJNA400391_S_NODE_4607_length_186_cov_2.139073_g4546_i0	PRJNA400391	4607	186	2.139073	3.97867578	Diplogasteridae	50861	Nematoda	Nematoda	291	3.1e-74	NTclustered	gi\|158821919\|gb\|EU195983.1\|	49349	g4546	i0	95.135	90.7903225806452	185	8	99	1	1	184	1797	1981	Aduncospiculum halicti strain JB120 28S ribosomal RNA gene, partial sequence	blastn	16887	292	0.996575342465753	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Aduncospiculum	Aduncospiculum halicti
8733886	8733886	PRJNA400391_S_NODE_5707_length_165_cov_1.346154_g5646_i0	PRJNA400391	5707	165	1.346154	2.2211541	Metazoa	33208	Nematoda	Nematoda	115	1.73e-21	NTclustered	gi\|158821917\|gb\|EU195981.1\|	96661	g5646	i0	84.167	37.5818181818182	120	18	73	1	46	165	2774	2656	Rhabditoides inermis strain SB328 28S ribosomal RNA gene, partial sequence	blastn	6201	115	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Rhabditoides	Rhabditoides inermis
30360252	30360252	PRJNA400391_S_NODE_1812_length_291_cov_3.429688_g1751_i0	PRJNA400391	1812	291	3.429688	9.98039208	Strongyloides ratti	34506	Nematoda	Nematoda	68.2	2.52e-12	NR	XP_024500768.1	34506	g1751	i0	64.8	1.05154639175258	54	19	55.7	0	290	129	5	58	XP_024500768.1 Hypothetical protein SRAE_0000067900 [Strongyloides ratti]	diamond	306	68.2	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);;