metadata: contig_metadata: 3 rows where bioproject = "PRJNA485080", tax_kingdom = "Metazoa" and tax

3 rows where bioproject = "PRJNA485080", 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
27044706	27044706	PRJNA485080_P_NODE_14482_length_297_cov_0.933036_g14388_i0	PRJNA485080	14482	297	0.933036	2.77111692	Brugia malayi	6279	Nematoda	Nematoda	110	1.87e-28	NR	CDQ07418.1	6279	g14388	i0	68.1	2.72727272727273	69	22	69.7	0	295	89	70	138	CDQ07418.1 Bm11692, partial [Brugia malayi]	diamond	810	110	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
27708552	27708552	PRJNA485080_P_NODE_23004_length_251_cov_0.865169_g22910_i0	PRJNA485080	23004	251	0.865169	2.17157419	Aphelenchoides avenae	70226	Nematoda	Nematoda	43.9	0.0164	NR	KAH7728860.1	70226	g22910	i0	33.3	0.752988047808765	63	41	75.3	1	63	251	81	142	KAH7728860.1 Protein E01G6.1 [Aphelenchoides avenae]	diamond	189	43.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides avenae
30408649	30408649	PRJNA485080_P_NODE_7793_length_363_cov_2.337931_g7699_i0	PRJNA485080	7793	363	2.337931	8.48668953	Rhabditida	6236	Nematoda	Nematoda	157	1.95e-43	NR	KAF8367523.1	54126	g7699	i0	92.5	14.7272727272727	120	9	99.2	0	361	2	268	387	KAF8367523.1 lin-53, partial [Pristionchus pacificus]	diamond	5346	157	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus

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