metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA326068" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA326068" 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
11868004	11868004	PRJNA326068_P_NODE_10490_length_305_cov_1.576087_g9530_i0	PRJNA326068	10490	305	1.576087	4.80706535	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	147	4.1399999999999996e-42	NR	MCL4117824.1	82763	g9530	i0	66.3	2.98032786885246	101	34	99.3	0	303	1	47	147	MCL4117824.1 hypothetical protein [Idotea baltica]	diamond	909	148	0.993243243243243	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
13142968	13142968	PRJNA326068_P_NODE_14311_length_229_cov_2.175000_g13348_i0	PRJNA326068	14311	229	2.175	4.98075	Arthropoda	6656	Arthropoda	Arthropoda	118	6.28e-31	NR	KAK8785384.1	6943	g13348	i0	74.1	13.7685589519651	81	16	99.6	1	1	228	56	136	KAK8785384.1 hypothetical protein V5799_008250 [Amblyomma americanum]	diamond	3153	118	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Amblyomma	Amblyomma americanum
20790923	20790923	PRJNA326068_P_NODE_19777_length_154_cov_1.672000_g18814_i0	PRJNA326068	19777	154	1.672	2.57488	Opisthokonta	33154	Arthropoda	Arthropoda	92	2.66e-22	NR	KAB7497964.1	96803	g18814	i0	76.5	38.7467532467532	51	12	99.4	0	1	153	73	123	KAB7497964.1 40S ribosomal protein S15a [Armadillidium nasatum]	diamond	5967	92	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Armadillidiidae	Armadillidium	Armadillidium nasatum
28053607	28053607	PRJNA326068_P_NODE_11645_length_278_cov_15.678715_g10683_i0	PRJNA326068	11645	278	15.678715	43.5868277	Tribolium castaneum	7070	Arthropoda	Arthropoda	46.2	0.00341	NR	XP_008199173.3	7070	g10683	i0	35.8	0.87410071942446	81	49	85.3	3	2	238	470	549	XP_008199173.3 protein bride of sevenless [Tribolium castaneum]	diamond	243	46.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tribolium	Tribolium castaneum
28639566	28639566	PRJNA326068_P_NODE_18827_length_167_cov_2.181159_g17864_i0	PRJNA326068	18827	167	2.181159	3.64253553	Opisthokonta	33154	Arthropoda	Arthropoda	91.3	2.43e-20	NR	RWS31359.1	299467	g17864	i0	81.5	19.4011976047904	54	10	97	0	165	4	73	126	RWS31359.1 60S ribosomal protein L5-like protein [Leptotrombidium deliense]	diamond	3240	91.7	0.995637949836423	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombiculidae	Leptotrombidium	Leptotrombidium deliense
29064215	29064215	PRJNA326068_P_NODE_11648_length_278_cov_9.771084_g10686_i0	PRJNA326068	11648	278	9.771084	27.16361352	Tenebrio molitor	7067	Arthropoda	Arthropoda	43.5	0.0304	NR	CAH1375291.1	7067	g10686	i0	35	2.27697841726619	80	51	85.3	1	277	41	479	558	CAH1375291.1 unnamed protein product [Tenebrio molitor]	diamond	633	43.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tenebrio	Tenebrio molitor
29176311	29176311	PRJNA326068_P_NODE_16949_length_199_cov_1.347059_g15986_i0	PRJNA326068	16949	199	1.347059	2.68064741	Opisthokonta	33154	Arthropoda	Arthropoda	63.5	6.37e-11	NR	CAG4636732.1	186181	g15986	i0	55.4	7.8391959798995	65	29	98	0	197	3	12	76	CAG4636732.1 EOG090X0NXS [Eubosmina coregoni]	diamond	1560	63.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Bosminidae	Eubosmina	Eubosmina coregoni
29902468	29902468	PRJNA326068_P_NODE_15471_length_215_cov_1.440860_g14508_i0	PRJNA326068	15471	215	1.44086	3.097849	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	55.5	3.65e-8	NR	MCL4117871.1	82763	g14508	i0	46.4	2.69302325581395	69	37	96.3	0	215	9	2	70	MCL4117871.1 hypothetical protein [Idotea baltica]	diamond	579	55.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
30864373	30864373	PRJNA326068_P_NODE_11954_length_272_cov_2.201646_g10991_i0	PRJNA326068	11954	272	2.201646	5.98847712	Maconellicoccus hirsutus	177089	Arthropoda	Arthropoda	68.9	7e-12	NR	ABM55665.1	177089	g10991	i0	49.4	9.79411764705882	83	38	88.2	2	272	33	71	152	ABM55665.1 putative ribosomal protein S8e [Maconellicoccus hirsutus]	diamond	2664	68.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Pseudococcidae	Maconellicoccus	Maconellicoccus hirsutus

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