metadata: contig_metadata: 4 rows where bioproject = "PRJNA1196438", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA1196438", 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
9251289	9251289	PRJNA1196438_P_NODE_6188_length_404_cov_3.794562_g5767_i0	PRJNA1196438	6188	404	3.794562	15.33003048	Strongyloides papillosus	174720	Nematoda	Nematoda	202	3.64e-47	NTclustered	gi\|690018840\|emb\|LM526136.1\|	174720	g5767	i0	79.649	6.58168316831683	285	54	70	4	55	337	7759	8041	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000493	blastn	2659	202	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
15626240	15626240	PRJNA1196438_P_NODE_67473_length_249_cov_4.335227_g67046_i0	PRJNA1196438	67473	249	4.335227	10.79471523	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	138	1.21e-37	NR	KRY42289.1	6334	g67046	i0	90.4	1709.77108433735	83	8	100	0	249	1	217	299	KRY42289.1 histone H3, partial [Trichinella spiralis]	diamond	425733	139	0.992805755395683	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
28575677	28575677	PRJNA1196438_P_NODE_42787_length_284_cov_3.924171_g42360_i0	PRJNA1196438	42787	284	3.924171	11.14464564	Metazoa	33208	Nematoda	Nematoda	59.7	6.86e-8	NR	OUC47204.1	6335	g42360	i0	100	251.80985915493	29	0	30.6	0	198	284	77	105	OUC47204.1 myosin head [Trichinella nativa]	diamond	71514	59.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella nativa
31779150	31779150	PRJNA1196438_P_NODE_68237_length_249_cov_0.886364_g67810_i0	PRJNA1196438	68237	249	0.886364	2.20704636	Soboliphyme baturini	241478	Nematoda	Nematoda	127	9.09e-32	NR	VDP07127.1	241478	g67810	i0	72	1.97590361445783	82	23	98.8	0	3	248	368	449	VDP07127.1 unnamed protein product [Soboliphyme baturini]	diamond	492	127	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Dioctophymatida	Soboliphymatidae	Soboliphyme	Soboliphyme baturini

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