metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1072736" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1072736" 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
26710399	26710399	PRJNA1072736_S_NODE_4761_length_178_cov_4.703704_g4756_i0	PRJNA1072736	4761	178	4.703704	8.37259312	root	1	Root_unresolved	Root_unresolved	119	8.560000000000001e-33	NR	AAR11853.1	10090	g4756	i0	98.3	15.8932584269663	59	1	99.4	0	2	178	77	135	AAR11853.1 reverse transcriptase, partial [Mus musculus]	diamond	2829	119	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
27320335	27320335	PRJNA1072736_S_NODE_6223_length_162_cov_1.579832_g6218_i0	PRJNA1072736	6223	162	1.579832	2.55932784	Ovis ammon polii x Ovis aries	2918886	Chordata	Chordata	69.7	8.77e-13	NR	KAI4586444.1	2918886	g6218	i0	84.6	0.722222222222222	39	6	72.2	0	128	12	139	177	KAI4586444.1 hypothetical protein MJG53_004231 [Ovis ammon polii x Ovis aries]	diamond	117	69.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis ammon polii x Ovis aries
28164405	28164405	PRJNA1072736_S_NODE_3765_length_194_cov_1.556291_g3760_i0	PRJNA1072736	3765	194	1.556291	3.01920454	root	1	Root_unresolved	Root_unresolved	129	7.98e-33	NR	AAA39757.1	10090	g3760	i0	98.4	29.6907216494845	64	1	99	0	193	2	5	68	AAA39757.1 pol protein, partial [Mus musculus]	diamond	5760	129	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
28741131	28741131	PRJNA1072736_S_NODE_5867_length_166_cov_1.317073_g5862_i0	PRJNA1072736	5867	166	1.317073	2.18634118	Phyllostomus discolor	89673	Chordata	Chordata	41.6	0.0302	NR	KAF6084349.1	89673	g5862	i0	64	0.451807228915663	25	9	45.2	0	120	46	17	41	KAF6084349.1 hypothetical protein HJG60_008620 [Phyllostomus discolor]	diamond	75	41.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Phyllostomidae	Phyllostomus	Phyllostomus discolor
29206494	29206494	PRJNA1072736_S_NODE_4289_length_185_cov_3.612676_g4284_i0	PRJNA1072736	4289	185	3.612676	6.6834506	Cladistia	1338366	Chordata	Chordata	44.7	0.00368	NR	XP_043941443.1	7888	g4284	i0	95	31.7837837837838	20	1	32.4	0	124	183	1756	1775	XP_043941443.1 ubiquitin carboxyl-terminal hydrolase 24 [Protopterus annectens]	diamond	5880	45.1	0.991130820399113	Eukaryota	Opisthokonta	Metazoa	Chordata		Ceratodontiformes	Protopteridae	Protopterus	Protopterus annectens
29206495	29206495	PRJNA1072736_S_NODE_6029_length_164_cov_1.677686_g6024_i0	PRJNA1072736	6029	164	1.677686	2.75140504	root	1	Root_unresolved	Root_unresolved	55.5	4.02e-7	NR	KAI5938739.1	9974	g6024	i0	64.1	17.1585365853659	39	14	71.3	0	135	19	221	259	KAI5938739.1 LINE-1 retrotransposable element ORF2 protein [Manis javanica]	diamond	2814	55.8	0.99462365591397806	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Pholidota	Manidae	Manis	Manis javanica
29964205	29964205	PRJNA1072736_S_NODE_7591_length_151_cov_0.870370_g7586_i0	PRJNA1072736	7591	151	0.87037	1.3142587	Chordata	7711	Chordata	Chordata	48.9	5.99e-5	NR	KAI8522083.1	7741	g7586	i0	53.7	21.9735099337748	41	18	79.5	1	32	151	28	68	KAI8522083.1 hypothetical protein Bbelb_018370 [Branchiostoma belcheri]	diamond	3318	48.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
30130226	30130226	PRJNA1072736_S_NODE_6052_length_164_cov_1.165289_g6047_i0	PRJNA1072736	6052	164	1.165289	1.91107396	Muntiacus reevesi	9886	Chordata	Chordata	55.5	2.69e-7	NR	KAB0387345.1	9886	g6047	i0	51.2	0.75	41	20	75	0	164	42	192	232	KAB0387345.1 hypothetical protein FD755_002301, partial [Muntiacus reevesi]	diamond	123	55.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Muntiacus	Muntiacus reevesi
32785419	32785419	PRJNA1072736_S_NODE_7580_length_151_cov_0.870370_g7575_i0	PRJNA1072736	7580	151	0.87037	1.3142587	Mirounga angustirostris	9716	Chordata	Chordata	77.4	5.84e-15	NR	XP_064441285.1	9716	g7575	i0	68.9	0.894039735099338	45	14	89.4	0	14	148	85	129	XP_064441285.1 F-box-like/WD repeat-containing protein TBL1XR1 isoform X2 [Mirounga angustirostris]	diamond	135	77.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Mirounga	Mirounga angustirostris

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