metadata: contig_metadata: 5 rows where bioproject = "PRJNA512103", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA512103", 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
9414651	9414651	PRJNA512103_P_NODE_7228_length_494_cov_1.370787_g6821_i0	PRJNA512103	7228	494	1.370787	6.77168778	Caenorhabditis elegans	6239	Nematoda	Nematoda	126	2.7999999999999998e-24	NTclustered	gi\|341353\|gb\|M25474.1\|CELTGMETC	6239	g6821	i0	89.32	16.7429149797571	103	8	21	3	273	374	43	143	Caenorhabditis elegans transfer RNA-Met (Met-tRNA3) gene	blastn	8271	126	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
27060930	27060930	PRJNA512103_P_NODE_34822_length_158_cov_2.027523_g34410_i0	PRJNA512103	34822	158	2.027523	3.20348634	Rhabditida	6236	Nematoda	Nematoda	92.4	1.07e-20	NR	KAF8366168.1	54126	g34410	i0	87.8	13.0253164556962	49	6	93	0	157	11	236	284	KAF8366168.1 hypothetical protein PRIPAC_83997, partial [Pristionchus pacificus]	diamond	2058	92.8	0.995689655172414	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
27330144	27330144	PRJNA512103_P_NODE_26123_length_184_cov_1.096296_g25711_i0	PRJNA512103	26123	184	1.096296	2.01718464	Diploscapter pachys	2018661	Nematoda	Nematoda	68.6	1.36e-11	NR	PAV58677.1	2018661	g25711	i0	55.8	0.847826086956522	52	23	84.8	0	171	16	1541	1592	PAV58677.1 hypothetical protein WR25_10059 [Diploscapter pachys]	diamond	156	68.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Diploscapter	Diploscapter pachys
29445336	29445336	PRJNA512103_P_NODE_29390_length_172_cov_1.617886_g28978_i0	PRJNA512103	29390	172	1.617886	2.78276392	Meloidogyne enterolobii	390850	Nematoda	Nematoda	45.1	7.36e-4	NR	CAD2154511.1	390850	g28978	i0	42.9	0.976744186046512	56	20	90.7	2	10	165	5	52	CAD2154511.1 unnamed protein product [Meloidogyne enterolobii]	diamond	168	45.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
29634585	29634585	PRJNA512103_P_NODE_17070_length_239_cov_2.721053_g16658_i0	PRJNA512103	17070	239	2.721053	6.50331667	Brugia malayi	6279	Nematoda	Nematoda	42.4	0.00973	NR	CDP90914.1	6279	g16658	i0	74.1	0.338912133891213	27	7	33.9	0	101	181	15	41	CDP90914.1 Bm13240 [Brugia malayi]	diamond	81	42.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi

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