metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1151638" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1151638" 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
30293479	30293479	PRJNA1151638_P_NODE_4132_length_265_cov_1.536458_g4065_i0	PRJNA1151638	4132	265	1.536458	4.0716137	Ignelater luminosus	2038154	Arthropoda	Arthropoda	50.4	5.06e-5	NR	KAF2879400.1	2038154	g4065	i0	37.2	1.93584905660377	86	45	97.4	4	265	8	21	97	KAF2879400.1 hypothetical protein ILUMI_26773 [Ignelater luminosus]	diamond	513	50.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Elateridae	Ignelater	Ignelater luminosus
30925201	30925201	PRJNA1151638_P_NODE_1314_length_397_cov_1.709877_g1247_i0	PRJNA1151638	1314	397	1.709877	6.78821169	Bradysia odoriphaga	1564500	Arthropoda	Arthropoda	172	1.8e-49	NR	KAG4071632.1	1564500	g1247	i0	75.9	2.38790931989924	108	26	81.6	0	324	1	1	108	KAG4071632.1 hypothetical protein HA402_011786 [Bradysia odoriphaga]	diamond	948	172	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Bradysia	Bradysia odoriphaga
31177466	31177466	PRJNA1151638_P_NODE_3335_length_284_cov_1.459716_g3268_i0	PRJNA1151638	3335	284	1.459716	4.14559344	Anthophora quadrimaculata	597840	Arthropoda	Arthropoda	44.7	0.012	NR	CAK9809220.1	597840	g3268	i0	47.9	0.507042253521127	48	17	42.3	1	123	4	134	181	CAK9809220.1 Transposable element Tc3 transposase [Anthophora quadrimaculata]	diamond	144	44.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Anthophora	Anthophora quadrimaculata
31589064	31589064	PRJNA1151638_P_NODE_976_length_451_cov_1.050265_g909_i0	PRJNA1151638	976	451	1.050265	4.73669515	Procambarus clarkii	6728	Arthropoda	Arthropoda	256	1.73e-82	NR	QEE82512.1	6728	g909	i0	84.7	0.997782705099778	150	23	99.8	0	450	1	51	200	QEE82512.1 putative phospholipase membrane-associated protein, partial [Procambarus clarkii]	diamond	450	256	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
31905151	31905151	PRJNA1151638_P_NODE_6317_length_244_cov_0.912281_g6250_i0	PRJNA1151638	6317	244	0.912281	2.22596564	Galendromus occidentalis	34638	Arthropoda	Arthropoda	73.9	3.72e-13	NR	XP_018496297.1	34638	g6250	i0	97.2	0.442622950819672	36	1	44.3	0	135	242	252	287	XP_018496297.1 sorting nexin-29 [Galendromus occidentalis]	diamond	108	73.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Mesostigmata	Phytoseiidae	Galendromus	Galendromus occidentalis

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