metadata: contig_metadata: 6 rows where bioproject = "PRJNA638138", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJNA638138", tax_clade = "Opisthokonta" 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
8262818	8262818	PRJNA638138_P_NODE_8767_length_347_cov_1.547445_g8552_i0	PRJNA638138	8767	347	1.547445	5.36963415	Strongyloides papillosus	174720	Nematoda	Nematoda	202	3.08e-47	NTclustered	gi\|690018840\|emb\|LM526136.1\|	174720	g8552	i0	79.649	7.59654178674352	285	54	82	4	34	316	8041	7759	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000493	blastn	2636	202	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
10813766	10813766	PRJNA638138_P_NODE_9309_length_340_cov_1.104869_g9094_i0	PRJNA638138	9309	340	1.104869	3.7565546	Metazoa	33208	Nematoda	Nematoda	198	1.64e-60	NR	KRZ40300.1	6337	g9094	i0	92.9	1289.81470588235	113	8	99.7	0	339	1	223	335	KRZ40300.1 histone H3 [Trichinella pseudospiralis]	diamond	438537	199	0.994974874371859	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis
15912294	15912294	PRJNA638138_P_NODE_28013_length_246_cov_0.890173_g27798_i0	PRJNA638138	28013	246	0.890173	2.18982558	Strongyloides ratti	34506	Nematoda	Nematoda	246	9.5e-61	NTclustered	gi\|1376144465\|ref\|XM_024652690.1\|	34506	g27798	i0	85.897	94.5975609756098	234	29	94	4	3	234	263	32	Strongyloides ratti Actin, alpha cardiac muscle 1 (SRAE_2000170700), partial mRNA	blastn	23271	246	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
27662289	27662289	PRJNA638138_P_NODE_34084_length_242_cov_0.911243_g33869_i0	PRJNA638138	34084	242	0.911243	2.20520806	Rhabditida	6236	Nematoda	Nematoda	95.5	6.35e-24	NR	NP_001370541.1	6239	g33869	i0	71.7	13.4504132231405	60	17	74.4	0	230	51	6	65	NP_001370541.1 Small ribosomal subunit protein eS28 [Caenorhabditis elegans]	diamond	3255	95.9	0.995828988529718	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
32811501	32811501	PRJNA638138_P_NODE_27840_length_246_cov_0.890173_g27625_i0	PRJNA638138	27840	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	71.6	2.46e-12	NR	KFD59604.1	68888	g27625	i0	43.6	11.2073170731707	78	39	89	1	223	5	140	217	KFD59604.1 hypothetical protein M514_28218 [Trichuris suis]	diamond	2757	71.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
32874504	32874504	PRJNA638138_P_NODE_980_length_915_cov_0.967933_g808_i0	PRJNA638138	980	915	0.967933	8.85658695	root	1	Root_unresolved	Root_unresolved	170	8.41e-46	NR	VDM16675.1	6293	g808	i0	54.3	1.7016393442623	173	79	56.7	0	41	559	239	411	VDM16675.1 unnamed protein product [Wuchereria bancrofti]	diamond	1557	170	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Wuchereria	Wuchereria bancrofti

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