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

5 rows where analysis = "diamond", bioproject = "PRJNA753151" 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
27874150	27874150	PRJNA753151_S_NODE_68145_length_326_cov_3.219081_g65855_i0	PRJNA753151	68145	326	3.219081	10.49420406	Popillia japonica	7064	Arthropoda	Arthropoda	41.2	0.0456	NR	KAK9701104.1	7064	g65855	i0	31.4	0.644171779141104	70	45	61.7	2	266	66	2	71	KAK9701104.1 hypothetical protein QE152_g30833 [Popillia japonica]	diamond	210	41.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Scarabaeidae	Popillia	Popillia japonica
28126847	28126847	PRJNA753151_S_NODE_202705_length_203_cov_1.125000_g200415_i0	PRJNA753151	202705	203	1.125	2.28375	Araneus ventricosus	182803	Arthropoda	Arthropoda	70.5	5.28e-13	NR	GBM52174.1	182803	g200415	i0	55.9	2.52709359605911	59	26	87.2	0	14	190	87	145	GBM52174.1 hypothetical protein AVEN_147945-1 [Araneus ventricosus]	diamond	513	70.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Araneus	Araneus ventricosus
30031215	30031215	PRJNA753151_S_NODE_251511_length_178_cov_4.311111_g249221_i0	PRJNA753151	251511	178	4.311111	7.67377758	Diptera	7147	Arthropoda	Arthropoda	69.3	4.91e-13	NR	XP_058988034.1	7370	g249221	i0	81	6.33707865168539	42	8	70.8	0	126	1	11	52	XP_058988034.1 ADP-ribose glycohydrolase OARD1 isoform X3 [Musca domestica]	diamond	1128	69.7	0.994261119081779	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Muscidae	Musca	Musca domestica
30306137	30306137	PRJNA753151_S_NODE_90252_length_294_cov_7.701195_g87962_i0	PRJNA753151	90252	294	7.701195	22.6415133	Schistocerca gregaria	7010	Arthropoda	Arthropoda	89.4	1.26e-19	NR	XP_049851799.1	7010	g87962	i0	72.6	0.63265306122449	62	17	63.3	0	294	109	135	196	XP_049851799.1 ras-related protein Rab-2B-like [Schistocerca gregaria]	diamond	186	89.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca gregaria
31506836	31506836	PRJNA753151_S_NODE_238896_length_184_cov_2.049645_g236606_i0	PRJNA753151	238896	184	2.049645	3.7713468	Tribolium castaneum	7070	Arthropoda	Arthropoda	69.7	2.95e-13	NR	KYB24744.1	7070	g236606	i0	73.8	0.684782608695652	42	11	68.5	0	162	37	97	138	KYB24744.1 hypothetical protein TcasGA2_TC031173 [Tribolium castaneum]	diamond	126	69.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tribolium	Tribolium castaneum

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