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

5 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Tardigrada"

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
26748485	26748485	PRJEB64798_P_NODE_240541_length_155_cov_2.849057_g238775_i0	PRJEB64798	240541	155	2.849057	4.41603835	Hypsibius exemplaris	2072580	Tardigrada	other_Eukaryota	70.1	2.5e-12	NR	OQV19801.1	2072580	g238775	i0	60	1.93548387096774	50	20	96.8	0	152	3	65	114	OQV19801.1 Selenocysteine-specific elongation factor [Hypsibius exemplaris]	diamond	300	70.1	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Hypsibiidae	Hypsibius	Hypsibius exemplaris
28423604	28423604	PRJEB64798_P_NODE_252666_length_150_cov_11.851485_g250900_i0	PRJEB64798	252666	150	11.851485	17.7772275	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	49.7	3.82e-5	NR	XP_055352971.1	2943436	g250900	i0	50	0.96	48	22	92	1	10	147	1470	1517	XP_055352971.1 LOW QUALITY PROTEIN: muscle calcium channel subunit alpha-1-like [Paramacrobiotus metropolitanus]	diamond	144	49.7	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus
28676054	28676054	PRJEB64798_P_NODE_147447_length_189_cov_370.514286_g145681_i0	PRJEB64798	147447	189	370.514286	700.27200054	Ramazzottius varieornatus	947166	Tardigrada	other_Eukaryota	40.4	0.0373	NR	GAV04005.1	947166	g145681	i0	35.5	0.984126984126984	62	40	98.4	0	4	189	38	99	GAV04005.1 hypothetical protein RvY_14353 [Ramazzottius varieornatus]	diamond	186	40.4	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Ramazzottiidae	Ramazzottius	Ramazzottius varieornatus
28826708	28826708	PRJEB64798_P_NODE_160308_length_183_cov_4.544776_g158542_i0	PRJEB64798	160308	183	4.544776	8.31694008	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.8	2.42e-5	NR	GAV08437.1	947166	g158542	i0	52.9	2.22950819672131	34	16	55.7	0	171	70	815	848	GAV08437.1 hypothetical protein RvY_18124 [Ramazzottius varieornatus]	diamond	408	51.2	0.9921875	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Ramazzottiidae	Ramazzottius	Ramazzottius varieornatus
30033835	30033835	PRJEB64798_P_NODE_173331_length_177_cov_4.437500_g171565_i0	PRJEB64798	173331	177	4.4375	7.854375	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	76.6	1.62e-14	NR	XP_055341541.1	2943436	g171565	i0	63.6	1.86440677966102	55	20	93.2	0	10	174	156	210	XP_055341541.1 lysosomal aspartic protease-like [Paramacrobiotus metropolitanus]	diamond	330	76.6	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus

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