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

11 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax_phylum = "Arthropoda"

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
4194371	4194371	PRJNA229468_S_NODE_404_length_247_cov_1.171717_g391_i0	PRJNA229468	404	247	1.171717	2.89414099	Amphibalanus amphitrite	1232801	Arthropoda	Arthropoda	126	2.78e-33	NR	KAF0291935.1	1232801	g391	i0	68.3	1.9919028340081	82	26	99.6	0	247	2	113	194	KAF0291935.1 Cathepsin L [Amphibalanus amphitrite]	diamond	492	126	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Thecostraca	Balanomorpha	Balanidae	Amphibalanus	Amphibalanus amphitrite
15670085	15670085	PRJNA229468_S_NODE_1213_length_162_cov_1.353982_g1200_i0	PRJNA229468	1213	162	1.353982	2.19345084	Allacma fusca	39272	Arthropoda	Arthropoda	78.2	4.58e-16	NR	CAG7724150.1	39272	g1200	i0	76.9	1.87037037037037	52	12	96.3	0	160	5	144	195	CAG7724150.1 unnamed protein product [Allacma fusca]	diamond	303	78.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Symphypleona	Sminthuridae	Allacma	Allacma fusca
27313225	27313225	PRJNA229468_S_NODE_1043_length_167_cov_2.161017_g1030_i0	PRJNA229468	1043	167	2.161017	3.60889839	Opisthokonta	33154	Arthropoda	Arthropoda	47.8	2.27e-4	NR	KAJ8679391.1	131215	g1030	i0	47.3	6.62874251497006	55	23	98.8	2	167	3	14	62	KAJ8679391.1 hypothetical protein QAD02_015178 [Eretmocerus hayati]	diamond	1107	47.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Aphelinidae	Eretmocerus	Eretmocerus hayati
28621579	28621579	PRJNA229468_S_NODE_867_length_180_cov_1.137405_g854_i0	PRJNA229468	867	180	1.137405	2.047329	Blomia tropicalis	40697	Arthropoda	Arthropoda	77.4	9.46e-15	NR	KAJ6223651.1	40697	g854	i0	67.3	12.6833333333333	49	16	81.7	0	149	3	152	200	KAJ6223651.1 hypothetical protein RDWZM_002196 [Blomia tropicalis]	diamond	2283	77.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Echimyopodidae	Blomia	Blomia tropicalis
28653060	28653060	PRJNA229468_S_NODE_567_length_213_cov_0.932927_g554_i0	PRJNA229468	567	213	0.932927	1.98713451	Apolygus lucorum	248454	Arthropoda	Arthropoda	57.4	1.74e-7	NR	KAF6208424.1	248454	g554	i0	50.9	0.774647887323944	55	27	77.5	0	174	10	35	89	KAF6208424.1 hypothetical protein GE061_016880 [Apolygus lucorum]	diamond	165	57.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Miridae	Apolygus	Apolygus lucorum
29018415	29018415	PRJNA229468_S_NODE_948_length_174_cov_0.976000_g935_i0	PRJNA229468	948	174	0.976	1.69824	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	83.6	1.5700000000000001e-19	NR	MCL4169634.1	82763	g935	i0	71.9	2.98275862068966	57	16	98.3	0	171	1	8	64	MCL4169634.1 hypothetical protein [Idotea baltica]	diamond	519	83.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
29997123	29997123	PRJNA229468_S_NODE_231_length_322_cov_1.860806_g218_i0	PRJNA229468	231	322	1.860806	5.99179532	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	126	6.389999999999998e-35	NR	XP_014219446.1	29053	g218	i0	62.9	30.111801242236	97	34	90.4	1	291	1	5	99	XP_014219446.1 60S ribosomal protein L31 [Copidosoma floridanum]	diamond	9696	126	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Encyrtidae	Copidosoma	Copidosoma floridanum
30913387	30913387	PRJNA229468_S_NODE_894_length_178_cov_1.480620_g881_i0	PRJNA229468	894	178	1.48062	2.6355036	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.1	3.94e-5	NR	RWS23232.1	299467	g881	i0	43.4	6.42134831460674	53	30	89.3	0	18	176	439	491	RWS23232.1 ABC transporter-like protein 12 [Leptotrombidium deliense]	diamond	1143	50.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombiculidae	Leptotrombidium	Leptotrombidium deliense
31116397	31116397	PRJNA229468_S_NODE_435_length_237_cov_1.904255_g422_i0	PRJNA229468	435	237	1.904255	4.51308435	Anoplophora glabripennis	217634	Arthropoda	Arthropoda	86.7	1.2e-19	NR	XP_018578213.1	217634	g422	i0	83.3	6.0253164556962	54	9	68.4	0	3	164	80	133	XP_018578213.1 ubiquitin-like protein FUBI [Anoplophora glabripennis]	diamond	1428	86.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Cerambycidae	Anoplophora	Anoplophora glabripennis
31401408	31401408	PRJNA229468_S_NODE_316_length_279_cov_1.795652_g303_i0	PRJNA229468	316	279	1.795652	5.00986908	Idotea baltica	82763	Arthropoda	Arthropoda	147	3.2599999999999995e-42	NR	MCL4121308.1	82763	g303	i0	68.8	2	93	29	100	0	279	1	41	133	MCL4121308.1 hypothetical protein [Idotea baltica]	diamond	558	147	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
31685715	31685715	PRJNA229468_S_NODE_1157_length_164_cov_0.886957_g1144_i0	PRJNA229468	1157	164	0.886957	1.45460948	Lepeophtheirus salmonis	72036	Arthropoda	Arthropoda	69.7	6.92e-13	NR	ADD38186.1	72036	g1144	i0	53.7	0.98780487804878	54	25	98.8	0	163	2	77	130	ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis]	diamond	162	69.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Siphonostomatoida	Caligidae	Lepeophtheirus	Lepeophtheirus salmonis

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