metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA931595" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA931595" 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
27246173	27246173	PRJNA931595_P_NODE_9263_length_279_cov_1.475728_g9154_i0	PRJNA931595	9263	279	1.475728	4.11728112	Dinothrombium tinctorium	1965070	Arthropoda	Arthropoda	120	3.72e-29	NR	RWS00845.1	1965070	g9154	i0	70.7	0.989247311827957	92	27	98.9	0	277	2	583	674	RWS00845.1 pre-mRNA cleavage complex 2 protein Pcf11-like isoform X1 [Dinothrombium tinctorium]	diamond	276	120	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombidiidae	Dinothrombium	Dinothrombium tinctorium
27530504	27530504	PRJNA931595_P_NODE_9023_length_281_cov_1.480769_g8914_i0	PRJNA931595	9023	281	1.480769	4.16096089	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	122	4.5000000000000004e-30	NR	KAH9400523.1	59818	g8914	i0	85.1	0.790035587188612	74	9	76.9	1	1	216	1892	1965	KAH9400523.1 AAA ATPase midasin [Tyrophagus putrescentiae]	diamond	222	122	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
28288113	28288113	PRJNA931595_P_NODE_13826_length_246_cov_1.335260_g13717_i0	PRJNA931595	13826	246	1.33526	3.2847396	Rhagoletis zephyria	28612	Arthropoda	Arthropoda	83.2	2.33e-16	NR	XP_017489429.1	28612	g13717	i0	100	0.48780487804878	40	0	48.8	0	120	1	39	78	XP_017489429.1 PREDICTED: nuclear pore complex protein Nup155-like [Rhagoletis zephyria]	diamond	120	83.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Rhagoletis	Rhagoletis zephyria
28509344	28509344	PRJNA931595_P_NODE_5187_length_345_cov_1.088235_g5078_i0	PRJNA931595	5187	345	1.088235	3.75441075	Dermatophagoides pteronyssinus	6956	Arthropoda	Arthropoda	87	9.38e-20	NR	KAH9416493.1	6956	g5078	i0	84	0.434782608695652	50	8	43.5	0	100	249	31	80	KAH9416493.1 hypothetical protein DERP_014542 [Dermatophagoides pteronyssinus]	diamond	150	87	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides pteronyssinus
29614063	29614063	PRJNA931595_P_NODE_3510_length_400_cov_1.287462_g3402_i0	PRJNA931595	3510	400	1.287462	5.149848	Dermatophagoides pteronyssinus	6956	Arthropoda	Arthropoda	229	1.81e-67	NR	KAH9412944.1	6956	g3402	i0	94.6	0.9675	129	7	96.8	0	2	388	566	694	KAH9412944.1 hypothetical protein DERP_013254 [Dermatophagoides pteronyssinus]	diamond	387	229	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides pteronyssinus
29867045	29867045	PRJNA931595_P_NODE_10531_length_268_cov_1.153846_g10422_i0	PRJNA931595	10531	268	1.153846	3.09230728	Oppiella nova	334625	Arthropoda	Arthropoda	73.2	8.69e-13	NR	CAD7660316.1	334625	g10422	i0	50.7	2.42910447761194	73	16	81.7	1	257	39	11	63	CAD7660316.1 unnamed protein product, partial [Oppiella nova]	diamond	651	73.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
30719962	30719962	PRJNA931595_P_NODE_13014_length_249_cov_0.875000_g12905_i0	PRJNA931595	13014	249	0.875	2.17875	Dermatophagoides pteronyssinus	6956	Arthropoda	Arthropoda	131	5.349999999999999e-37	NR	KAH9426076.1	6956	g12905	i0	97	0.807228915662651	67	2	80.7	0	35	235	1	67	KAH9426076.1 hypothetical protein DERP_007016 [Dermatophagoides pteronyssinus]	diamond	201	131	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides pteronyssinus
32364609	32364609	PRJNA931595_P_NODE_7699_length_293_cov_2.813636_g7590_i0	PRJNA931595	7699	293	2.813636	8.24395348	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	203	1.19e-61	NR	KAH9402498.1	59818	g7590	i0	94.9	1.00341296928328	98	4	99.3	1	3	293	44	141	KAH9402498.1 Yip1 member 6 [Tyrophagus putrescentiae]	diamond	294	203	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
32396192	32396192	PRJNA931595_P_NODE_6279_length_319_cov_1.646341_g6170_i0	PRJNA931595	6279	319	1.646341	5.25182779	Dermatophagoides pteronyssinus	6956	Arthropoda	Arthropoda	129	7.22e-36	NR	KAH9412943.1	6956	g6170	i0	88.6	0.658307210031348	70	8	65.8	0	228	19	86	155	KAH9412943.1 hypothetical protein DERP_013253 [Dermatophagoides pteronyssinus]	diamond	210	129	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides pteronyssinus
32522956	32522956	PRJNA931595_P_NODE_7519_length_296_cov_3.242152_g7410_i0	PRJNA931595	7519	296	3.242152	9.59676992	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	46.6	0.00296	NR	KAH9410077.1	59818	g7410	i0	54.8	0.425675675675676	42	19	42.6	0	168	293	49	90	KAH9410077.1 Mucolipin-2 [Tyrophagus putrescentiae]	diamond	126	46.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
32743407	32743407	PRJNA931595_P_NODE_11840_length_255_cov_1.395604_g11731_i0	PRJNA931595	11840	255	1.395604	3.5587902	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	86.3	2.01e-17	NR	KAH9394917.1	59818	g11731	i0	75	0.988235294117647	84	15	91.8	2	20	253	29	112	KAH9394917.1 hypothetical protein TYRP_004980 [Tyrophagus putrescentiae]	diamond	252	86.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae

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