metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA564810" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA564810" 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
5657980	5657980	PRJNA564810_S_NODE_3405_length_287_cov_3.198198_g3383_i0	PRJNA564810	3405	287	3.198198	9.17882826	root	1	Root_unresolved	Root_unresolved	178	1.1999999999999998e-53	NR	CAK8671822.1	159417	g3383	i0	84	145.526132404181	94	15	98.3	0	283	2	180	273	CAK8671822.1 unnamed protein product [Clavelina lepadiformis]	diamond	41766	179	0.994413407821229	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Aplousobranchia	Clavelinidae	Clavelina	Clavelina lepadiformis
27142141	27142141	PRJNA564810_S_NODE_3962_length_274_cov_1.626794_g3940_i0	PRJNA564810	3962	274	1.626794	4.45741556	Nyctereutes procyonoides	34880	Chordata	Chordata	51.2	2.87e-6	NR	CAD7689335.1	34880	g3940	i0	50.9	0.602189781021898	55	22	60.2	1	40	204	1	50	CAD7689335.1 unnamed protein product [Nyctereutes procyonoides]	diamond	165	51.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Nyctereutes	Nyctereutes procyonoides
27395601	27395601	PRJNA564810_S_NODE_8003_length_213_cov_0.918919_g7981_i0	PRJNA564810	8003	213	0.918919	1.95729747	Hemiscyllium ocellatum	170820	Chordata	Chordata	45.8	0.00203	NR	XP_060702192.1	170820	g7981	i0	42.6	2.02816901408451	54	31	76.1	0	162	1	255	308	XP_060702192.1 lysine-specific demethylase 4B isoform X4 [Hemiscyllium ocellatum]	diamond	432	45.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Orectolobiformes	Hemiscylliidae	Hemiscyllium	Hemiscyllium ocellatum
27472360	27472360	PRJNA564810_S_NODE_6063_length_236_cov_1.631579_g6041_i0	PRJNA564810	6063	236	1.631579	3.85052644	Metazoa	33208	Chordata	Chordata	69.3	6.65e-12	NR	KAI8509936.1	7741	g6041	i0	59.6	3.30508474576271	52	21	66.1	0	1	156	201	252	KAI8509936.1 diphthine synthase [Branchiostoma belcheri]	diamond	780	69.7	0.994261119081779	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
28009199	28009199	PRJNA564810_S_NODE_3065_length_296_cov_2.523810_g3043_i0	PRJNA564810	3065	296	2.52381	7.4704776	root	1	Root_unresolved	Root_unresolved	49.7	2.57e-4	NR	KAJ1206372.1	8319	g3043	i0	39.2	5.95945945945946	74	38	75	1	29	250	201	267	KAJ1206372.1 hypothetical protein NDU88_001778 [Pleurodeles waltl]	diamond	1764	49.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
28184486	28184486	PRJNA564810_S_NODE_1866_length_343_cov_1.881295_g1844_i0	PRJNA564810	1866	343	1.881295	6.45284185	Molossus molossus	27622	Chordata	Chordata	122	3.98e-30	NR	KAF6438719.1	27622	g1844	i0	57.9	0.997084548104956	114	48	99.7	0	2	343	338	451	KAF6438719.1 protein phosphatase 2 scaffold subunit Abeta [Molossus molossus]	diamond	342	122	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Molossidae	Molossus	Molossus molossus
28311114	28311114	PRJNA564810_S_NODE_8426_length_204_cov_3.913669_g8404_i0	PRJNA564810	8426	204	3.913669	7.98388476	Xenopus tropicalis	8364	Chordata	Chordata	42.4	0.0324	NR	XP_004913737.2	8364	g8404	i0	37.8	1.32352941176471	45	28	66.2	0	52	186	180	224	XP_004913737.2 PHD and RING finger domain-containing protein 1 isoform X3 [Xenopus tropicalis]	diamond	270	42.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
32021314	32021314	PRJNA564810_S_NODE_4338_length_266_cov_1.855721_g4316_i0	PRJNA564810	4338	266	1.855721	4.93621786	Chordata	7711	Chordata	Chordata	71.6	1.08e-12	NR	XP_006268452.2	8496	g4316	i0	61.5	53.3684210526316	52	20	58.6	0	13	168	195	246	XP_006268452.2 transmembrane emp24 domain-containing protein 10 [Alligator mississippiensis]	diamond	14196	71.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Crocodylia	Alligatoridae	Alligator	Alligator mississippiensis
32622160	32622160	PRJNA564810_S_NODE_3820_length_277_cov_1.919811_g3798_i0	PRJNA564810	3820	277	1.919811	5.31787647	Aves	8782	Chordata	Chordata	82.4	4.75e-16	NR	PKK25464.1	8932	g3798	i0	75	21.2382671480144	56	14	60.6	0	276	109	347	402	PKK25464.1 testis expressed 9 [Columba livia]	diamond	5883	82.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Columbiformes	Columbidae	Columba	Columba livia
32765887	32765887	PRJNA564810_S_NODE_3120_length_295_cov_1.182609_g3098_i0	PRJNA564810	3120	295	1.182609	3.48869655	Branchiostoma belcheri	7741	Chordata	Chordata	48.1	4.75e-4	NR	XP_019614525.1	7741	g3098	i0	47.3	0.559322033898305	55	27	54.9	2	295	134	127	180	XP_019614525.1 PREDICTED: COMM domain-containing protein 1-like [Branchiostoma belcheri]	diamond	165	48.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri

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