metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA393181" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA393181" and tax_kingdom = "Metazoa"

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
1685498	1685498	PRJNA393181_S_NODE_35722_length_182_cov_3.434483_g35616_i0	PRJNA393181	35722	182	3.434483	6.25075906	root	1	Root_unresolved	Root_unresolved	99	1.32e-22	NR	XP_046859871.1	2897299	g35616	i0	66.1	1.94505494505495	59	20	97.3	0	6	182	184	242	XP_046859871.1 fumarylacetoacetase-like [Xenia sp. Carnegie-2017]	diamond	354	99	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
13164090	13164090	PRJNA393181_S_NODE_22391_length_246_cov_2.636364_g22285_i0	PRJNA393181	22391	246	2.636364	6.48545544	root	1	Root_unresolved	Root_unresolved	70.5	2e-12	NR	MEE6515959.1	8439	g22285	i0	44.3	9.40243902439024	79	33	82.9	1	3	206	67	145	MEE6515959.1 hypothetical protein [Ascaphus truei]	diamond	2313	70.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ascaphidae	Ascaphus	Ascaphus truei
20812271	20812271	PRJNA393181_S_NODE_35277_length_184_cov_1.850340_g35171_i0	PRJNA393181	35277	184	1.85034	3.4046256	root	1	Root_unresolved	Root_unresolved	57	1.59e-7	NR	VVC97936.1	189913	g35171	i0	69	11.0217391304348	42	12	68.5	1	126	1	92	132	VVC97936.1 unnamed protein product [Leptidea sinapis]	diamond	2028	57	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Pieridae	Leptidea	Leptidea sinapis
24030140	24030140	PRJNA393181_S_NODE_24799_length_231_cov_1.994845_g24693_i0	PRJNA393181	24799	231	1.994845	4.60809195	Mollusca	6447	Mollusca	Mollusca	81.3	8.83e-16	NR	XP_048243562.1	6454	g24693	i0	52.1	1.8961038961039	71	33	92.2	1	228	16	127	196	XP_048243562.1 putative L-amino-acid oxidase YobN isoform X1 [Haliotis rufescens]	diamond	438	82	0.991463414634146	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
27675797	27675797	PRJNA393181_S_NODE_26384_length_222_cov_2.178378_g26278_i0	PRJNA393181	26384	222	2.178378	4.83599916	Lacerta agilis	80427	Chordata	Chordata	79.7	2.77e-15	NR	XP_033002290.1	80427	g26278	i0	63.1	1.75675675675676	65	21	87.8	2	195	1	1191	1252	XP_033002290.1 uncharacterized protein K02A2.6-like [Lacerta agilis]	diamond	390	79.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Lacerta	Lacerta agilis
27739073	27739073	PRJNA393181_S_NODE_44764_length_157_cov_1.300000_g44658_i0	PRJNA393181	44764	157	1.3	2.041	Mirounga leonina	9715	Chordata	Chordata	45.8	8.35e-4	NR	KAF3830524.1	9715	g44658	i0	64.7	0.974522292993631	51	18	97.5	0	155	3	98	148	KAF3830524.1 hypothetical protein GH733_004343 [Mirounga leonina]	diamond	153	45.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Mirounga	Mirounga leonina
27864851	27864851	PRJNA393181_S_NODE_37385_length_177_cov_1.821429_g37279_i0	PRJNA393181	37385	177	1.821429	3.22392933	Lacerta agilis	80427	Chordata	Chordata	91.7	8.89e-20	NR	XP_033002290.1	80427	g37279	i0	77.2	2.89830508474576	57	13	96.6	0	3	173	387	443	XP_033002290.1 uncharacterized protein K02A2.6-like [Lacerta agilis]	diamond	513	91.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Lacerta	Lacerta agilis
28906718	28906718	PRJNA393181_S_NODE_27948_length_214_cov_2.355932_g27842_i0	PRJNA393181	27948	214	2.355932	5.04169448	Strigops habroptila	2489341	Chordata	Chordata	42	0.0482	NR	XP_030331398.1	2489341	g27842	i0	36.2	0.658878504672897	47	30	65.9	0	195	55	105	151	XP_030331398.1 ancient ubiquitous protein 1 isoform X1 [Strigops habroptila]	diamond	141	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Psittaciformes	Psittacidae	Strigops	Strigops habroptila
29917462	29917462	PRJNA393181_S_NODE_30691_length_202_cov_1.339394_g30585_i0	PRJNA393181	30691	202	1.339394	2.70557588	Lacerta agilis	80427	Chordata	Chordata	99	3.53e-22	NR	XP_033002290.1	80427	g30585	i0	66.7	3.07425742574257	69	21	99.5	1	201	1	244	312	XP_033002290.1 uncharacterized protein K02A2.6-like [Lacerta agilis]	diamond	621	99	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Lacerta	Lacerta agilis
30896957	30896957	PRJNA393181_S_NODE_18574_length_275_cov_2.457983_g18468_i0	PRJNA393181	18574	275	2.457983	6.75945325	Polyplax serrata	468196	Arthropoda	Arthropoda	64.7	4.56e-10	NR	KAK6619586.1	468196	g18468	i0	75	0.698181818181818	32	8	34.9	0	3	98	183	214	KAK6619586.1 hypothetical protein RUM43_012343 [Polyplax serrata]	diamond	192	64.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Polyplacidae	Polyplax	Polyplax serrata
31592470	31592470	PRJNA393181_S_NODE_34216_length_188_cov_1.291391_g34110_i0	PRJNA393181	34216	188	1.291391	2.42781508	Clunio marinus	568069	Arthropoda	Arthropoda	116	1.04e-29	NR	CRL02559.1	568069	g34110	i0	85.5	0.98936170212766	62	9	98.9	0	186	1	251	312	CRL02559.1 CLUMA_CG015843, isoform A [Clunio marinus]	diamond	186	116	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Clunio	Clunio marinus

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