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

10 rows where analysis = "diamond", bioproject = "PRJNA881257" 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
26897272	26897272	PRJNA881257_P_NODE_16741_length_164_cov_1.400000_g16496_i0	PRJNA881257	16741	164	1.4	2.296	Microtus ochrogaster	79684	Chordata	Chordata	55.1	5.64e-7	NR	KAH0514787.1	79684	g16496	i0	75	0.878048780487805	48	12	87.8	0	17	160	679	726	KAH0514787.1 Matrix-remodeling-associated protein 8 [Microtus ochrogaster]	diamond	144	55.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Microtus	Microtus ochrogaster
27750538	27750538	PRJNA881257_P_NODE_15344_length_167_cov_0.881356_g15099_i0	PRJNA881257	15344	167	0.881356	1.47186452	Polypterus senegalus	55291	Chordata	Chordata	50.1	3.39e-5	NR	KAG2469876.1	55291	g15099	i0	60	19.688622754491	45	17	80.8	1	135	1	153	196	KAG2469876.1 TC1A transposase, partial [Polypterus senegalus]	diamond	3288	50.4	0.994047619047619	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
27844853	27844853	PRJNA881257_P_NODE_17724_length_163_cov_0.912281_g17479_i0	PRJNA881257	17724	163	0.912281	1.48701803	Fringilla coelebs	37598	Chordata	Chordata	44.3	0.00254	NR	CAM5971001.1	37598	g17479	i0	54.8	0.773006134969325	42	17	77.3	1	2	127	69	108	CAM5971001.1 unnamed protein product [Fringilla coelebs]	diamond	126	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Fringilla	Fringilla coelebs
27907874	27907874	PRJNA881257_P_NODE_14385_length_169_cov_0.866667_g14140_i0	PRJNA881257	14385	169	0.866667	1.46466723	Panthera pardus	9691	Chordata	Chordata	47.4	3.02e-4	NR	XP_053760110.1	9691	g14140	i0	73.1	0.461538461538462	26	7	46.2	0	137	60	276	301	XP_053760110.1 uncharacterized protein LOC109248688 [Panthera pardus]	diamond	78	47.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Panthera	Panthera pardus
28034618	28034618	PRJNA881257_P_NODE_7585_length_258_cov_1.148325_g7340_i0	PRJNA881257	7585	258	1.148325	2.9626785	Polypterus senegalus	55291	Chordata	Chordata	65.5	3.59e-10	NR	KAG2460242.1	55291	g7340	i0	54.9	0.593023255813954	51	23	59.3	0	155	3	235	285	KAG2460242.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	153	65.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
30876793	30876793	PRJNA881257_P_NODE_17514_length_163_cov_0.912281_g17269_i0	PRJNA881257	17514	163	0.912281	1.48701803	Crocuta crocuta	9678	Chordata	Chordata	58.9	1.38e-8	NR	KAF0883013.1	9678	g17269	i0	61.4	3.4601226993865	44	17	81	0	158	27	128	171	KAF0883013.1 LORF2 protein, partial [Crocuta crocuta]	diamond	564	58.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Hyaenidae	Crocuta	Crocuta crocuta
31730328	31730328	PRJNA881257_P_NODE_12477_length_183_cov_1.134328_g12232_i0	PRJNA881257	12477	183	1.134328	2.07582024	Bufotes viridis	30338	Chordata	Chordata	43.5	0.00883	NR	CAK8609802.1	30338	g12232	i0	57.6	1.67213114754098	33	14	54.1	0	81	179	1	33	CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis]	diamond	306	43.9	0.990888382687927	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
32015165	32015165	PRJNA881257_P_NODE_6518_length_285_cov_1.296610_g6273_i0	PRJNA881257	6518	285	1.29661	3.6953385	Bufotes viridis	30338	Chordata	Chordata	43.9	0.0224	NR	CAK8629749.1	30338	g6273	i0	74.1	0.284210526315789	27	7	28.4	0	114	194	335	361	CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis]	diamond	81	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
32300305	32300305	PRJNA881257_P_NODE_18439_length_152_cov_2.223301_g18194_i0	PRJNA881257	18439	152	2.223301	3.37941752	Pleurodeles waltl	8319	Chordata	Chordata	65.1	5.35e-11	NR	KAJ1185330.1	8319	g18194	i0	59.6	1.125	57	16	98.7	2	151	2	30	86	KAJ1185330.1 hypothetical protein NDU88_002123 [Pleurodeles waltl]	diamond	171	65.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
32836409	32836409	PRJNA881257_P_NODE_17160_length_164_cov_0.904348_g16915_i0	PRJNA881257	17160	164	0.904348	1.48313072	Molossus molossus	27622	Chordata	Chordata	42.4	0.0081	NR	KAF6500767.1	27622	g16915	i0	43.2	0.676829268292683	37	21	67.7	0	47	157	72	108	KAF6500767.1 hypothetical protein HJG59_007823 [Molossus molossus]	diamond	111	42.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Molossidae	Molossus	Molossus molossus

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