metadata: contig_metadata: 4 rows where bioproject = "PRJNA1242190", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJNA1242190", 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
16353494	16353494	PRJNA1242190_S_NODE_4733_length_374_cov_4.388704_g4726_i0	PRJNA1242190	4733	374	4.388704	16.41375296	Pristionchus	54125	Nematoda	Nematoda	106	2.69e-18	NTclustered	gi\|150984424\|gb\|EF634854.1\|	54126	g4726	i0	91.026	7.15775401069519	78	7	21	0	123	200	572	495	Pristionchus pacificus small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	2677	106	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
27168189	27168189	PRJNA1242190_S_NODE_2482_length_474_cov_3.309227_g2475_i0	PRJNA1242190	2482	474	3.309227	15.68573598	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	86.7	1.59e-18	NR	GMT18625.1	1538716	g2475	i0	41.3	0.765822784810127	121	66	75.9	2	44	403	10	126	GMT18625.1 hypothetical protein PFISCL1PPCAC_9922 [Pristionchus fissidentatus]	diamond	363	86.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus
27926411	27926411	PRJNA1242190_S_NODE_1605_length_536_cov_3.723542_g1598_i0	PRJNA1242190	1605	536	3.723542	19.95818512	Bursaphelenchus xylophilus	6326	Nematoda	Nematoda	202	1.6e-63	NR	CAD5208001.1	6326	g1598	i0	66.2	1.62873134328358	145	49	81.2	0	6	440	1	145	CAD5208001.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	873	202	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
30547509	30547509	PRJNA1242190_S_NODE_2293_length_485_cov_5.650485_g2286_i0	PRJNA1242190	2293	485	5.650485	27.40485225	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	75.1	1.42e-13	NR	KAE9556682.1	2598192	g2286	i0	37.3	1.25567010309278	102	64	63.1	0	477	172	65	166	KAE9556682.1 hypothetical protein FO519_000088 [Halicephalobus sp. NKZ332]	diamond	609	75.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332

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