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

5 rows where analysis = "diamond", bioproject = "PRJNA690592" and tax_phylum = "Nematomorpha"

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
26670626	26670626	PRJNA690592_S_NODE_111781_length_313_cov_1.708333_g110767_i0	PRJNA690592	111781	313	1.708333	5.34708229	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	93.6	9.94e-20	NR	CAK9290736.1	3053472	g110767	i0	52.2	0.862619808306709	90	42	85.3	1	42	308	198	287	CAK9290736.1 unnamed protein product [Gordionus sp. m RMFG-2023]	diamond	270	93.6	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
28598592	28598592	PRJNA690592_S_NODE_96147_length_333_cov_1.165385_g95133_i0	PRJNA690592	96147	333	1.165385	3.88073205	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	85.5	1.43e-17	NR	CAK9299756.1	3053472	g95133	i0	57.9	3.65765765765766	76	31	67.6	1	75	299	21	96	CAK9299756.1 unnamed protein product [Gordionus sp. m RMFG-2023]	diamond	1218	85.5	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
28756146	28756146	PRJNA690592_S_NODE_132287_length_292_cov_1.652968_g131273_i0	PRJNA690592	132287	292	1.652968	4.82666656	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	108	2.5500000000000003e-27	NR	XP_065319484.1	3053472	g131273	i0	52.6	2.98972602739726	97	45	99.7	1	292	2	38	133	XP_065319484.1 ras-related protein Rab-18A-like [Gordionus sp. m RMFG-2023]	diamond	873	108	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
30082283	30082283	PRJNA690592_S_NODE_154292_length_273_cov_2.780000_g153278_i0	PRJNA690592	154292	273	2.78	7.5894	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	52	3e-5	NR	CAK9295974.1	3053472	g153278	i0	38.6	0.769230769230769	70	42	76.9	1	269	60	741	809	CAK9295974.1 unnamed protein product [Gordionus sp. m RMFG-2023]	diamond	210	52	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
32485499	32485499	PRJNA690592_S_NODE_185579_length_251_cov_1.297753_g184565_i0	PRJNA690592	185579	251	1.297753	3.25736003	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	80.9	1.47e-15	NR	XP_065320264.1	3053472	g184565	i0	44.3	1.05179282868526	88	40	94.4	2	247	11	336	423	XP_065320264.1 polypyrimidine tract-binding protein 2-like [Gordionus sp. m RMFG-2023]	diamond	264	80.9	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023

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