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

5 rows where analysis = "diamond", bioproject = "PRJNA682774" and tax_phylum = "Chordata"

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
19791598	19791598	PRJNA682774_P_NODE_4016_length_250_cov_0.881356_g3987_i0	PRJNA682774	4016	250	0.881356	2.20339	Latimeria chalumnae	7897	Chordata	Chordata	95.1	1.51e-20	NR	XP_064412279.1	7897	g3987	i0	59	7.968	83	21	99.6	2	1	249	550	619	XP_064412279.1 mannosyl-oligosaccharide 1,2-alpha-mannosidase IA isoform X1 [Latimeria chalumnae]	diamond	1992	95.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
27662591	27662591	PRJNA682774_P_NODE_984_length_436_cov_1.275482_g955_i0	PRJNA682774	984	436	1.275482	5.56110152	Aves	8782	Chordata	Chordata	121	5.8099999999999994e-30	NR	KAI6074947.1	8832	g955	i0	46.9	29.5183486238532	143	74	97.7	2	433	8	119	260	KAI6074947.1 Aquaporin-4 isoform X2 [Aix galericulata]	diamond	12870	122	0.991803278688525	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Anseriformes	Anatidae	Aix	Aix galericulata
28957212	28957212	PRJNA682774_P_NODE_3488_length_253_cov_0.866667_g3459_i0	PRJNA682774	3488	253	0.866667	2.19266751	Anura	8342	Chordata	Chordata	104	8.729999999999998e-24	NR	OCT76043.1	8355	g3459	i0	59	9.84189723320158	83	32	98.4	1	251	3	572	652	OCT76043.1 hypothetical protein XELAEV_18031231mg [Xenopus laevis]	diamond	2490	105	0.990476190476191	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
29766113	29766113	PRJNA682774_P_NODE_5251_length_243_cov_0.917647_g5222_i0	PRJNA682774	5251	243	0.917647	2.22988221	Eurypyga helias	54383	Chordata	Chordata	64.7	1.53e-11	NR	KFV96751.1	54383	g5222	i0	42.9	1.72839506172839	70	40	86.4	0	23	232	10	79	KFV96751.1 Cytochrome b-c1 complex subunit 8, partial [Eurypyga helias]	diamond	420	64.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Eurypygiformes	Eurypygidae	Eurypyga	Eurypyga helias
32642544	32642544	PRJNA682774_P_NODE_2980_length_269_cov_1.341837_g2951_i0	PRJNA682774	2980	269	1.341837	3.60954153	Myxine glutinosa	7769	Chordata	Chordata	83.6	2.22e-16	NR	XP_067975911.1	7769	g2951	i0	38.3	5.10780669144981	94	51	97	2	262	2	447	540	XP_067975911.1 carnitine O-palmitoyltransferase 1, liver isoform-like isoform X1 [Myxine glutinosa]	diamond	1374	83.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Myxini	Myxiniformes	Myxinidae	Myxine	Myxine glutinosa

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