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

9 rows where analysis = "diamond", bioproject = "PRJNA816527" 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
7197363	7197363	PRJNA816527_P_NODE_10246_length_328_cov_1.760784_g10196_i0	PRJNA816527	10246	328	1.760784	5.77537152	Rotaria	231623	Rotifera	other_Eukaryota	217	6.060000000000001e-70	NR	CAF3810701.1	392030	g10196	i0	91.7	2.99085365853659	109	9	99.7	0	1	327	30	138	CAF3810701.1 unnamed protein product [Rotaria magnacalcarata]	diamond	981	217	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
9747515	9747515	PRJNA816527_P_NODE_18808_length_246_cov_0.890173_g18758_i0	PRJNA816527	18808	246	0.890173	2.18982558	Metazoa	33208	Annelida	Annelida	96.3	2.23e-22	NR	ACR00066.1	644278	g18758	i0	60	21.0853658536585	75	29	91.5	1	226	2	105	178	ACR00066.1 cytochrome c oxidase subunit II [Paralvinella sulfincola]	diamond	5187	96.7	0.995863495346432	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella sulfincola
9747528	9747528	PRJNA816527_P_NODE_19228_length_245_cov_0.895349_g19178_i0	PRJNA816527	19228	245	0.895349	2.19360505	Gigantopelta aegis	1735272	Mollusca	Mollusca	99	1.5099999999999998e-23	NR	XP_041379271.1	1735272	g19178	i0	62.2	1.9469387755102	82	28	98	3	244	5	28	108	XP_041379271.1 LOW QUALITY PROTEIN: prolyl 3-hydroxylase OGFOD1-like [Gigantopelta aegis]	diamond	477	99	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
26619923	26619923	PRJNA816527_P_NODE_19541_length_244_cov_0.900585_g19491_i0	PRJNA816527	19541	244	0.900585	2.1974274	Eurotatoria	2816136	Rotifera	other_Eukaryota	140	1.65e-36	NR	UJR26868.1	104782	g19491	i0	79	2.98770491803279	81	17	99.6	0	244	2	267	347	UJR26868.1 hypothetical protein I4U23_008179 [Adineta vaga]	diamond	729	140	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
26959347	26959347	PRJNA816527_P_NODE_15182_length_268_cov_1.579487_g15132_i0	PRJNA816527	15182	268	1.579487	4.23302516	Rotaria sordida	392033	Rotifera	other_Eukaryota	137	2.7899999999999997e-35	NR	CAF1169739.1	392033	g15132	i0	70.1	4.91417910447761	87	26	97.4	0	2	262	254	340	CAF1169739.1 unnamed protein product [Rotaria sordida]	diamond	1317	137	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
27054524	27054524	PRJNA816527_P_NODE_20702_length_239_cov_2.777108_g20652_i0	PRJNA816527	20702	239	2.777108	6.63728812	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	63.5	1.3e-9	NR	CAF3779341.1	392030	g20652	i0	59.6	2.47280334728033	47	19	59	0	145	5	42	88	CAF3779341.1 unnamed protein product [Rotaria magnacalcarata]	diamond	591	63.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
27189431	27189431	PRJNA816527_P_NODE_14822_length_272_cov_1.547739_g14772_i0	PRJNA816527	14822	272	1.547739	4.20985008	Rotaria	231623	Rotifera	other_Eukaryota	168	1.61e-48	NR	CAF0926538.1	392033	g14772	i0	96.6	5.75735294117647	87	3	96	0	270	10	122	208	CAF0926538.1 unnamed protein product [Rotaria sordida]	diamond	1566	169	0.994082840236686	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
30307738	30307738	PRJNA816527_P_NODE_15912_length_260_cov_1.647059_g15862_i0	PRJNA816527	15912	260	1.647059	4.2823534	Phragmatopoma lapidosa	341668	Annelida	Annelida	99.4	3.4099999999999995e-23	NR	AKV16218.1	341668	g15862	i0	55.8	0.992307692307692	86	37	98.1	1	258	4	153	238	AKV16218.1 putative trypsin-like serine protease [Phragmatopoma lapidosa]	diamond	258	99.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellariidae	Phragmatopoma	Phragmatopoma lapidosa
32236144	32236144	PRJNA816527_P_NODE_17418_length_249_cov_2.551136_g17368_i0	PRJNA816527	17418	249	2.551136	6.35232864	Octodon degus	10160	Chordata	Chordata	42.7	0.0332	NR	XP_023565747.1	10160	g17368	i0	34.5	0.698795180722892	58	37	69.9	1	233	60	134	190	XP_023565747.1 uncharacterized protein LOC111815369 [Octodon degus]	diamond	174	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Octodontidae	Octodon	Octodon degus

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