metadata: contig_metadata: 3 rows where analysis = "diamond", bioproject = "PRJNA1095825" and tax

3 rows where analysis = "diamond", bioproject = "PRJNA1095825" 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
27762868	27762868	PRJNA1095825_P_NODE_242584_length_250_cov_0.870056_g239521_i0	PRJNA1095825	242584	250	0.870056	2.17514	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	73.9	4.01e-13	NR	XP_065316689.1	3053472	g239521	i0	50	0.696	58	29	69.6	0	236	63	528	585	XP_065316689.1 piggyBac transposable element-derived protein 2-like [Gordionus sp. m RMFG-2023]	diamond	174	73.9	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
31015490	31015490	PRJNA1095825_P_NODE_283855_length_243_cov_0.905882_g280792_i0	PRJNA1095825	283855	243	0.905882	2.20129326	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	61.6	8.07e-9	NR	XP_065312932.1	3053472	g280792	i0	35.4	4.96296296296296	82	47	93.8	1	231	4	20	101	XP_065312932.1 cathepsin B-like [Gordionus sp. m RMFG-2023]	diamond	1206	61.6	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
31489977	31489977	PRJNA1095825_P_NODE_299936_length_227_cov_2.428571_g296873_i0	PRJNA1095825	299936	227	2.428571	5.51285617	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	65.1	4.07e-10	NR	CAK9301593.1	3053472	g296873	i0	40	0.92511013215859	70	42	92.5	0	6	215	1166	1235	CAK9301593.1 unnamed protein product [Gordionus sp. m RMFG-2023]	diamond	210	65.1	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);;