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

5 rows where analysis = "diamond", bioproject = "PRJNA688655" 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
26924104	26924104	PRJNA688655_P_NODE_11222_length_247_cov_0.885057_g11157_i0	PRJNA688655	11222	247	0.885057	2.18609079	Idotea baltica	82763	Arthropoda	Arthropoda	114	1.14e-28	NR	MCL4125753.1	82763	g11157	i0	67.1	0.959514170040486	79	23	96	1	247	11	229	304	MCL4125753.1 hypothetical protein [Idotea baltica]	diamond	237	114	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
26998761	26998761	PRJNA688655_P_NODE_4022_length_317_cov_0.942623_g3957_i0	PRJNA688655	4022	317	0.942623	2.98811491	Drosophila	7215	Arthropoda	Arthropoda	80.5	4.83e-15	NR	NP_001162772.1	7227	g3957	i0	40.8	6.47318611987382	98	53	89.9	2	292	8	14	109	NP_001162772.1 transducer of ERBB2, isoform F [Drosophila melanogaster]	diamond	2052	80.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
27840158	27840158	PRJNA688655_P_NODE_8804_length_250_cov_0.870056_g8739_i0	PRJNA688655	8804	250	0.870056	2.17514	Trypoxylus dichotomus	273928	Arthropoda	Arthropoda	57.8	1.83e-7	NR	GJQ76753.1	273928	g8739	i0	48.2	0.672	56	29	67.2	0	181	14	236	291	GJQ76753.1 hypothetical protein Trydic_g15596 [Trypoxylus dichotomus]	diamond	168	57.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Scarabaeidae	Trypoxylus	Trypoxylus dichotomus
27935155	27935155	PRJNA688655_P_NODE_16105_length_241_cov_0.916667_g16040_i0	PRJNA688655	16105	241	0.916667	2.20916747	Halotydeus destructor	2874060	Arthropoda	Arthropoda	60.5	2.1e-8	NR	KAI1295348.1	2874060	g16040	i0	41.9	1.89211618257261	74	42	92.1	1	5	226	354	426	KAI1295348.1 Crossover junction endonuclease MUS81 [Halotydeus destructor]	diamond	456	60.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Penthaleidae	Halotydeus	Halotydeus destructor
32137160	32137160	PRJNA688655_P_NODE_18_length_2637_cov_7.782761_g12_i0	PRJNA688655	18	2637	7.782761	205.23140757	Portunus trituberculatus	210409	Arthropoda	Arthropoda	70.1	1.27e-10	NR	MPC39078.1	210409	g12	i0	48.4	0.10580204778157	93	45	10.5	3	1266	1541	1	91	MPC39078.1 hypothetical protein [Portunus trituberculatus]	diamond	279	70.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Portunus	Portunus trituberculatus

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