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

5 rows where analysis = "diamond", bioproject = "PRJNA772154" 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
8400657	8400657	PRJNA772154_P_NODE_21127_length_245_cov_1.360465_g20942_i0	PRJNA772154	21127	245	1.360465	3.33313925	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	82.4	1.68e-16	NR	KAL1506826.1	57062	g20942	i0	50	15.0489795918367	80	40	98	0	5	244	86	165	KAL1506826.1 hypothetical protein ABEB36_006116 [Hypothenemus hampei]	diamond	3687	82.8	0.995169082125604	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Hypothenemus	Hypothenemus hampei
9675558	9675558	PRJNA772154_P_NODE_10548_length_349_cov_1.695652_g10363_i0	PRJNA772154	10548	349	1.695652	5.91782548	Idotea baltica	82763	Arthropoda	Arthropoda	95.5	9.47e-23	NR	MCL4113735.1	82763	g10363	i0	76.4	0.92836676217765	55	13	47.3	0	330	166	1	55	MCL4113735.1 hypothetical protein [Idotea baltica]	diamond	324	95.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
29927091	29927091	PRJNA772154_P_NODE_20791_length_246_cov_0.901734_g20606_i0	PRJNA772154	20791	246	0.901734	2.21826564	Megalurothrips usitatus	439358	Arthropoda	Arthropoda	88.6	9.94e-19	NR	KAJ1529678.1	439358	g20606	i0	59.2	0.926829268292683	76	28	89	1	236	18	234	309	KAJ1529678.1 hypothetical protein ONE63_006434 [Megalurothrips usitatus]	diamond	228	88.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Megalurothrips	Megalurothrips usitatus
30021866	30021866	PRJNA772154_P_NODE_17691_length_253_cov_0.866667_g17506_i0	PRJNA772154	17691	253	0.866667	2.19266751	Idotea baltica	82763	Arthropoda	Arthropoda	96.3	7.5e-23	NR	MCL4141150.1	82763	g17506	i0	71.2	2.22924901185771	66	19	78.3	0	9	206	80	145	MCL4141150.1 hypothetical protein [Idotea baltica]	diamond	564	96.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
31633444	31633444	PRJNA772154_P_NODE_22876_length_242_cov_0.923077_g22691_i0	PRJNA772154	22876	242	0.923077	2.23384634	Trichomalopsis sarcophagae	543379	Arthropoda	Arthropoda	132	1.47e-33	NR	OXU30697.1	543379	g22691	i0	93.9	1.63636363636364	66	4	81.8	0	240	43	866	931	OXU30697.1 hypothetical protein TSAR_016922 [Trichomalopsis sarcophagae]	diamond	396	132	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Pteromalidae	Trichomalopsis	Trichomalopsis sarcophagae

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