metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1069776" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1069776" 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
29941146	29941146	PRJNA1069776_S_NODE_21191_length_229_cov_4.892473_g20877_i0	PRJNA1069776	21191	229	4.892473	11.20376317	Meloidogyne enterolobii	390850	Nematoda	Nematoda	42.4	0.0427	NR	CAD2183941.1	390850	g20877	i0	41.4	1.83406113537118	70	31	81.2	3	203	18	1264	1331	CAD2183941.1 unnamed protein product [Meloidogyne enterolobii]	diamond	420	42.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
30225301	30225301	PRJNA1069776_S_NODE_53952_length_151_cov_2.768519_g53638_i0	PRJNA1069776	53952	151	2.768519	4.18046369	Trichinella pseudospiralis	6337	Nematoda	Nematoda	41.6	0.0276	NR	KRY87921.1	6337	g53638	i0	50	0.913907284768212	46	23	91.4	0	151	14	327	372	KRY87921.1 hypothetical protein T4D_14233 [Trichinella pseudospiralis]	diamond	138	41.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis
30257291	30257291	PRJNA1069776_S_NODE_28852_length_200_cov_3.974522_g28538_i0	PRJNA1069776	28852	200	3.974522	7.949044	Ostertagia ostertagi	6317	Nematoda	Nematoda	39.7	0.0377	NR	KAK6026689.1	6317	g28538	i0	55.9	0.51	34	15	51	0	90	191	9	42	KAK6026689.1 hypothetical protein OSTOST_07329, partial [Ostertagia ostertagi]	diamond	102	39.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Ostertagia	Ostertagia ostertagi
30888846	30888846	PRJNA1069776_S_NODE_1954_length_504_cov_25.225597_g1652_i0	PRJNA1069776	1954	504	25.225597	127.13700888	Dictyocaulus viviparus	29172	Nematoda	Nematoda	59.3	7.15e-8	NR	KJH41339.1	29172	g1652	i0	100	0.142857142857143	24	0	14.3	0	382	453	32	55	KJH41339.1 hypothetical protein DICVIV_12690 [Dictyocaulus viviparus]	diamond	72	59.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Dictyocaulus	Dictyocaulus viviparus
31932174	31932174	PRJNA1069776_S_NODE_3837_length_401_cov_16.413408_g3523_i0	PRJNA1069776	3837	401	16.413408	65.81776608	Dictyocaulus viviparus	29172	Nematoda	Nematoda	59.3	2.94e-8	NR	KJH41339.1	29172	g3523	i0	100	0.179551122194514	24	0	18	0	279	350	32	55	KJH41339.1 hypothetical protein DICVIV_12690 [Dictyocaulus viviparus]	diamond	72	59.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Dictyocaulus	Dictyocaulus viviparus

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