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

4 rows where bioproject = "PRJEB81171", 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
6099790	6099790	PRJEB81171_P_NODE_2785_length_395_cov_4.931677_g2658_i0	PRJEB81171	2785	395	4.931677	19.48012415	Pristionchus	54125	Nematoda	Nematoda	154	1.0099999999999999e-32	NTclustered	gi\|524845312\|gb\|KC819366.1\|	1355913	g2658	i0	80.18	29.4455696202532	222	30	54	11	97	311	263	49	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds	blastn	11631	154	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus
6517518	6517518	PRJEB81171_P_NODE_1946_length_473_cov_2.977500_g1822_i0	PRJEB81171	1946	473	2.9775	14.083575	Rhabditoides inermis	96661	Nematoda	Nematoda	259	2.53e-64	NTclustered	gi\|256709332\|gb\|GQ422341.1\|	96661	g1822	i0	80.226	8.77167019027484	354	62	74	6	60	409	384	35	Rhabditoides inermis large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	4149	259	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Rhabditoides	Rhabditoides inermis
28076474	28076474	PRJEB81171_P_NODE_7485_length_255_cov_1.285714_g7358_i0	PRJEB81171	7485	255	1.285714	3.2785707	Aphelenchoides fujianensis	1052528	Nematoda	Nematoda	68.2	4.4e-11	NR	KAI6233889.1	1052528	g7358	i0	51.7	1.56470588235294	60	29	70.6	0	188	9	17	76	KAI6233889.1 Filamin-C [Aphelenchoides fujianensis]	diamond	399	68.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides fujianensis
28448366	28448366	PRJEB81171_P_NODE_7966_length_251_cov_2.471910_g7839_i0	PRJEB81171	7966	251	2.47191	6.2044941	Pristionchus	54125	Nematoda	Nematoda	60.1	3.12e-8	NR	KAF8357760.1	54126	g7839	i0	89.3	1.00398406374502	28	3	33.5	0	84	1	1	28	KAF8357760.1 best-18 [Pristionchus pacificus]	diamond	252	60.1	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);;