metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA734313" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA734313" 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
27084049	27084049	PRJNA734313_S_NODE_17962_length_221_cov_1.172414_g17849_i0	PRJNA734313	17962	221	1.172414	2.59103494	Leptotrombidium deliense	299467	Arthropoda	Arthropoda	57	2.59e-7	NR	RWS31390.1	299467	g17849	i0	45	0.81447963800905	60	31	78.7	1	219	46	364	423	RWS31390.1 uncharacterized protein B4U80_02538 [Leptotrombidium deliense]	diamond	180	57	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombiculidae	Leptotrombidium	Leptotrombidium deliense
27347273	27347273	PRJNA734313_S_NODE_26523_length_180_cov_1.150376_g26410_i0	PRJNA734313	26523	180	1.150376	2.0706768	Araneidae	6913	Arthropoda	Arthropoda	90.9	7.61e-20	NR	XP_055941438.1	94029	g26410	i0	62.7	3.93333333333333	59	22	98.3	0	2	178	300	358	XP_055941438.1 protein SSUH2 homolog [Argiope bruennichi]	diamond	708	90.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Argiope	Argiope bruennichi
28094713	28094713	PRJNA734313_S_NODE_8965_length_313_cov_2.187970_g8852_i0	PRJNA734313	8965	313	2.18797	6.8483461	Leptopilina boulardi	63433	Arthropoda	Arthropoda	55.8	2.13e-6	NR	XP_051173332.1	63433	g8852	i0	29.7	0.87220447284345	91	55	87.2	2	312	40	38	119	XP_051173332.1 ankyrin-1-like [Leptopilina boulardi]	diamond	273	55.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Figitidae	Leptopilina	Leptopilina boulardi
29178585	29178585	PRJNA734313_S_NODE_16589_length_230_cov_2.229508_g16476_i0	PRJNA734313	16589	230	2.229508	5.1278684	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.9	2.01e-7	NR	KAK2720597.1	6661	g16476	i0	37.3	2.60869565217391	67	42	87.4	0	230	30	10	76	KAK2720597.1 hypothetical protein QYM36_004472 [Artemia franciscana]	diamond	600	54.3	0.992633517495396	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
29452047	29452047	PRJNA734313_S_NODE_10650_length_288_cov_1.481328_g10537_i0	PRJNA734313	10650	288	1.481328	4.26622464	Argiope bruennichi	94029	Arthropoda	Arthropoda	117	2.9299999999999993e-28	NR	XP_055928046.1	94029	g10537	i0	52.2	5.76041666666667	92	44	95.8	0	286	11	485	576	XP_055928046.1 macrophage mannose receptor 1-like [Argiope bruennichi]	diamond	1659	117	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Argiope	Argiope bruennichi
29494183	29494183	PRJNA734313_S_NODE_20370_length_207_cov_0.956250_g20257_i0	PRJNA734313	20370	207	0.95625	1.9794375	Metazoa	33208	Arthropoda	Arthropoda	62	3.85e-9	NR	CAD7232757.1	163714	g20257	i0	46.4	2	69	36	98.6	1	4	207	55	123	CAD7232757.1 unnamed protein product [Cyprideis torosa]	diamond	414	62.4	0.993589743589744	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cytherideidae	Cyprideis	Cyprideis torosa
30463573	30463573	PRJNA734313_S_NODE_3233_length_454_cov_12.825553_g3125_i0	PRJNA734313	3233	454	12.825553	58.22801062	Uroleucon formosanum	796250	Arthropoda	Arthropoda	47.4	0.00703	NR	KAL4119326.1	796250	g3125	i0	29.4	0.786343612334802	119	72	73.3	5	103	435	3	117	KAL4119326.1 hypothetical protein QTP88_012147 [Uroleucon formosanum]	diamond	357	47.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Uroleucon	Uroleucon formosanum

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