metadata: contig_metadata: 4 rows where bioproject = "PRJEB50765" and tax

4 rows where bioproject = "PRJEB50765" 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
13744767	13744767	PRJEB50765_P_NODE_1071_length_308_cov_2.405904_g1047_i0	PRJEB50765	1071	308	2.405904	7.41018432	Caenorhabditis	6237	Nematoda	Nematoda	265	3.39e-66	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g1047	i0	87.446	76.4415584415584	231	27	75	2	77	306	1307	1078	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	23544	265	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
14147887	14147887	PRJEB50765_P_NODE_2352_length_184_cov_3.183673_g2328_i0	PRJEB50765	2352	184	3.183673	5.85795832	Caenorhabditis elegans	6239	Nematoda	Nematoda	202	1.47e-47	NTclustered	gi\|1972294218\|ref\|NM_001380754.2\|	6239	g2328	i0	86.413	97.8858695652174	184	25	100	0	1	184	86	269	Caenorhabditis elegans Actin-3 (act-3), mRNA	blastn	18011	202	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
16696179	16696179	PRJEB50765_P_NODE_514_length_477_cov_1.547727_g491_i0	PRJEB50765	514	477	1.547727	7.38265779	Meloidogyne graminicola	189291	Nematoda	Nematoda	172	1.47e-46	NR	KAF7634545.1	189291	g491	i0	65.4	3.88050314465409	127	42	78.6	1	9	383	796	922	KAF7634545.1 Elongation factor 1-alpha [Meloidogyne graminicola]	diamond	1851	172	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
27343133	27343133	PRJEB50765_P_NODE_1783_length_219_cov_1.686813_g1759_i0	PRJEB50765	1783	219	1.686813	3.69412047	root	1	Root_unresolved	Root_unresolved	94	2.48e-20	NR	KAI1716765.1	166010	g1759	i0	54.9	10.6849315068493	71	32	97.3	0	215	3	639	709	KAI1716765.1 elongation factor tu GTP binding domain-containing protein [Ditylenchus destructor]	diamond	2340	94.7	0.992608236536431	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anguinidae	Ditylenchus	Ditylenchus destructor

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