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

5 rows where analysis = "diamond", bioproject = "PRJNA611476" 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
19716282	19716282	PRJNA611476_P_NODE_61656_length_282_cov_1.282297_g60865_i0	PRJNA611476	61656	282	1.282297	3.61607754	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	96.3	7.260000000000001e-22	NR	XP_065322432.1	3053472	g60865	i0	73.3	7.19148936170213	60	16	63.8	0	1	180	111	170	XP_065322432.1 uncharacterized protein LOC135929673 isoform X2 [Gordionus sp. m RMFG-2023]	diamond	2028	96.3	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
28596223	28596223	PRJNA611476_P_NODE_28487_length_384_cov_0.990354_g27696_i0	PRJNA611476	28487	384	0.990354	3.80295936	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	100	2.93e-22	NR	XP_065313229.1	3053472	g27696	i0	40.2	1.9296875	127	71	97.7	3	8	382	5	128	XP_065313229.1 cathepsin B-like [Gordionus sp. m RMFG-2023]	diamond	741	100	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
29732504	29732504	PRJNA611476_P_NODE_3070_length_1124_cov_4.902950_g2468_i0	PRJNA611476	3070	1124	4.90295	55.109158	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	50.1	0.0164	NR	XP_065315305.1	3053472	g2468	i0	26.7	1.08629893238434	206	137	53.9	9	928	323	581	776	XP_065315305.1 uncharacterized protein LOC135924185 [Gordionus sp. m RMFG-2023]	diamond	1221	50.1	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
32103349	32103349	PRJNA611476_P_NODE_86658_length_249_cov_0.875000_g85867_i0	PRJNA611476	86658	249	0.875	2.17875	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	47.4	4.75e-4	NR	XP_065321737.1	3053472	g85867	i0	32.4	0.891566265060241	74	48	89.2	1	240	19	58	129	XP_065321737.1 NADH dehydrogenase [ubiquinone] 1 alpha subcomplex subunit 8-like [Gordionus sp. m RMFG-2023]	diamond	222	47.4	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
32766721	32766721	PRJNA611476_P_NODE_15500_length_501_cov_1.079439_g14710_i0	PRJNA611476	15500	501	1.079439	5.40798939	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	195	1.36e-57	NR	XP_065323757.1	3053472	g14710	i0	54.5	0.988023952095808	165	73	98.2	2	494	3	29	192	XP_065323757.1 cathepsin B-like [Gordionus sp. m RMFG-2023]	diamond	495	195	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);;