metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA384462" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA384462" 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
2956016	2956016	PRJNA384462_S_NODE_363_length_771_cov_8.019391_g290_i0	PRJNA384462	363	771	8.019391	61.82950461	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	305	3.34e-93	NR	MCP9264969.1	6287	g290	i0	69.9	10.4902723735409	206	62	80.2	0	13	630	801	1006	MCP9264969.1 60S ribosomal protein L10 [Dirofilaria immitis]	diamond	8088	305	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Dirofilaria	Dirofilaria immitis
11884003	11884003	PRJNA384462_S_NODE_2690_length_316_cov_7.063670_g2574_i0	PRJNA384462	2690	316	7.06367	22.3211972	Meloidogyne enterolobii	390850	Nematoda	Nematoda	62.8	7.85e-9	NR	CAD2164178.1	390850	g2574	i0	40.4	3.66455696202532	94	52	85.4	2	292	23	4	97	CAD2164178.1 unnamed protein product [Meloidogyne enterolobii]	diamond	1158	62.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii
22081762	22081762	PRJNA384462_S_NODE_1438_length_435_cov_2.090674_g1322_i0	PRJNA384462	1438	435	2.090674	9.0944319	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	164	8.969999999999999e-47	NR	KRY31199.1	6334	g1322	i0	73.1	201.731034482759	119	31	82.1	1	3	359	196	313	KRY31199.1 histone H3 [Trichinella spiralis]	diamond	87753	165	0.993939393939394	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
26870916	26870916	PRJNA384462_S_NODE_3901_length_267_cov_1.844037_g3785_i0	PRJNA384462	3901	267	1.844037	4.92357879	Rhabditida	6236	Nematoda	Nematoda	71.6	1.59e-12	NR	KAK6060278.1	27828	g3785	i0	67.9	2.51685393258427	53	16	59.6	1	39	197	1	52	KAK6060278.1 ribosomal L29e protein [Cooperia oncophora]	diamond	672	72	0.994444444444444	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Cooperia	Cooperia oncophora
26933861	26933861	PRJNA384462_S_NODE_1502_length_425_cov_3.034574_g1386_i0	PRJNA384462	1502	425	3.034574	12.8969395	Trichostrongylidae	6315	Nematoda	Nematoda	64.3	3.76e-9	NR	KAK6022555.1	6317	g1386	i0	69.6	1.29176470588235	46	13	32.5	1	425	288	179	223	KAK6022555.1 V-type ATPase, D subunit [Ostertagia ostertagi]	diamond	549	64.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Ostertagia	Ostertagia ostertagi
27359823	27359823	PRJNA384462_S_NODE_2303_length_343_cov_3.629252_g2187_i0	PRJNA384462	2303	343	3.629252	12.44833436	Mesorhabditis spiculigera	96644	Nematoda	Nematoda	86.3	5.84e-17	NR	CAJ0584621.1	96644	g2187	i0	67.9	1.4868804664723	53	17	46.4	0	7	165	414	466	CAJ0584621.1 unnamed protein product, partial [Mesorhabditis spiculigera]	diamond	510	86.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Mesorhabditis	Mesorhabditis spiculigera
28923547	28923547	PRJNA384462_S_NODE_9928_length_184_cov_1.133333_g9812_i0	PRJNA384462	9928	184	1.133333	2.08533272	Heterodera	34509	Nematoda	Nematoda	53.9	1.86e-6	NR	KAL3068977.1	97005	g9812	i0	46.7	5.65760869565217	60	30	94.6	1	176	3	466	525	KAL3068977.1 hypothetical protein niasHS_015692 [Heterodera schachtii]	diamond	1041	53.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera schachtii
32383070	32383070	PRJNA384462_S_NODE_15699_length_159_cov_2.290909_g15583_i0	PRJNA384462	15699	159	2.290909	3.64254531	Aphelenchoides besseyi	269767	Nematoda	Nematoda	67.8	1.42e-11	NR	KAI6215557.1	269767	g15583	i0	56.3	1.81132075471698	48	21	90.6	0	2	145	291	338	KAI6215557.1 Fructose-bisphosphatase [Aphelenchoides besseyi]	diamond	288	67.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
32730411	32730411	PRJNA384462_S_NODE_10860_length_178_cov_1.550388_g10744_i0	PRJNA384462	10860	178	1.550388	2.75969064	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	45.1	0.00162	NR	GMT09317.1	1538716	g10744	i0	53.1	0.539325842696629	32	15	53.9	0	26	121	117	148	GMT09317.1 hypothetical protein PFISCL1PPCAC_614, partial [Pristionchus fissidentatus]	diamond	96	45.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus

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