metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1020641" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1020641" 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
10363779	10363779	PRJNA1020641_P_NODE_4709_length_277_cov_1.132353_g4666_i0	PRJNA1020641	4709	277	1.132353	3.13661781	Sarcoptes scabiei	52283	Arthropoda	Arthropoda	84	1.76e-16	NR	KAF7494767.1	52283	g4666	i0	51.1	8.8158844765343	90	41	97.5	1	6	275	77	163	KAF7494767.1 Kinesin-like protein KIF3A [Sarcoptes scabiei]	diamond	2442	84	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Sarcoptidae	Sarcoptes	Sarcoptes scabiei
26869085	26869085	PRJNA1020641_P_NODE_7221_length_242_cov_0.911243_g7178_i0	PRJNA1020641	7221	242	0.911243	2.20520806	Metazoa	33208	Arthropoda	Arthropoda	102	2.68e-23	NR	XP_037797912.1	6687	g7178	i0	64.1	57.4710743801653	78	26	96.7	1	234	1	627	702	XP_037797912.1 putative pre-mRNA-splicing factor ATP-dependent RNA helicase PRP1 [Penaeus monodon]	diamond	13908	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus monodon
30919739	30919739	PRJNA1020641_P_NODE_7294_length_242_cov_0.911243_g7251_i0	PRJNA1020641	7294	242	0.911243	2.20520806	Agrilus planipennis	224129	Arthropoda	Arthropoda	82.4	4.06e-16	NR	XP_025837070.1	224129	g7251	i0	54.7	5.62809917355372	75	21	93	1	10	234	1369	1430	XP_025837070.1 dynein heavy chain 3, axonemal isoform X3 [Agrilus planipennis]	diamond	1362	82.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Buprestidae	Agrilus	Agrilus planipennis
31923566	31923566	PRJNA1020641_P_NODE_6557_length_246_cov_0.890173_g6514_i0	PRJNA1020641	6557	246	0.890173	2.18982558	Hemiptera	7524	Arthropoda	Arthropoda	97.8	1.68e-21	NR	XKL59431.1	473130	g6514	i0	56.8	5.81707317073171	81	35	98.8	0	1	243	513	593	XKL59431.1 hypothetical protein PGB90_000447 [Kerria lacca]	diamond	1431	98.2	0.995926680244399	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Tachardiidae	Kerria	Kerria lacca

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