metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA565584" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA565584" 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
13310818	13310818	PRJNA565584_P_NODE_36631_length_498_cov_7.724706_g35480_i0	PRJNA565584	36631	498	7.724706	38.46903588	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	122	9.86e-31	NR	XP_065319472.1	3053472	g35480	i0	57.4	12.9879518072289	108	43	65.1	1	327	4	42	146	XP_065319472.1 small ribosomal subunit protein uS5-like [Gordionus sp. m RMFG-2023]	diamond	6468	122	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
14584537	14584537	PRJNA565584_P_NODE_175812_length_249_cov_1.744318_g174660_i0	PRJNA565584	175812	249	1.744318	4.34335182	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	132	1.16e-35	NR	XP_065321611.1	3053472	g174660	i0	68.7	3	83	26	100	0	1	249	141	223	XP_065321611.1 small ribosomal subunit protein RACK1-like [Gordionus sp. m RMFG-2023]	diamond	747	132	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
28279402	28279402	PRJNA565584_P_NODE_74326_length_344_cov_7.483395_g73175_i0	PRJNA565584	74326	344	7.483395	25.7428788	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	123	1.26e-33	NR	XP_065322390.1	3053472	g73175	i0	73.3	0.75	86	23	75	0	274	17	26	111	XP_065322390.1 small ribosomal subunit protein eS25-like [Gordionus sp. m RMFG-2023]	diamond	258	123	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
32197599	32197599	PRJNA565584_P_NODE_73898_length_345_cov_6.183824_g72747_i0	PRJNA565584	73898	345	6.183824	21.3341928	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	127	3.81e-35	NR	XP_065322390.1	3053472	g72747	i0	73	0.773913043478261	89	24	77.4	0	290	24	26	114	XP_065322390.1 small ribosomal subunit protein eS25-like [Gordionus sp. m RMFG-2023]	diamond	267	127	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);;