metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA280983" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA280983" and tax_phylum = "Chordata"

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
23323686	23323686	PRJNA280983_P_NODE_2719_length_425_cov_1.486702_g2604_i0	PRJNA280983	2719	425	1.486702	6.3184835	Opisthokonta	33154	Chordata	Chordata	167	2.22e-49	NR	XP_019623368.1	7741	g2604	i0	57.9	25.0941176470588	140	59	98.8	0	1	420	12	151	XP_019623368.1 PREDICTED: 60S ribosomal protein L13a-like [Branchiostoma belcheri]	diamond	10665	168	0.994047619047619	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
27642980	27642980	PRJNA280983_P_NODE_5144_length_279_cov_4.008696_g5029_i0	PRJNA280983	5144	279	4.008696	11.18426184	Staurois parvus	386267	Chordata	Chordata	49.3	1.67e-5	NR	CAI9623369.1	386267	g5029	i0	50	0.473118279569892	44	22	47.3	0	159	28	19	62	CAI9623369.1 unnamed protein product [Staurois parvus]	diamond	132	49.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
27737835	27737835	PRJNA280983_P_NODE_5884_length_253_cov_1.348039_g5769_i0	PRJNA280983	5884	253	1.348039	3.41053867	Xenopus laevis	8355	Chordata	Chordata	42.7	0.0348	NR	OCT99772.1	8355	g5769	i0	47.7	0.521739130434783	44	23	52.2	0	77	208	47	90	OCT99772.1 hypothetical protein XELAEV_18005553mg [Xenopus laevis]	diamond	132	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
28007929	28007929	PRJNA280983_P_NODE_7505_length_209_cov_0.956250_g7390_i0	PRJNA280983	7505	209	0.95625	1.9985625	Metazoa	33208	Chordata	Chordata	59.3	3.44e-8	NR	XP_019639423.1	7741	g7390	i0	38.3	8.21052631578947	60	34	81.8	1	38	208	1035	1094	XP_019639423.1 PREDICTED: uncharacterized protein LOC109481332 [Branchiostoma belcheri]	diamond	1716	59.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
29979326	29979326	PRJNA280983_P_NODE_7951_length_199_cov_1.320000_g7836_i0	PRJNA280983	7951	199	1.32	2.6268	Ranitomeya imitator	111125	Chordata	Chordata	46.2	0.00127	NR	CAJ0952439.1	111125	g7836	i0	42.1	0.85929648241206	57	33	85.9	0	198	28	656	712	CAJ0952439.1 unnamed protein product [Ranitomeya imitator]	diamond	171	46.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
30422052	30422052	PRJNA280983_P_NODE_8993_length_180_cov_0.778626_g8878_i0	PRJNA280983	8993	180	0.778626	1.4015268	Bufotes viridis	30338	Chordata	Chordata	56.6	1.99e-7	NR	CAK8609802.1	30338	g8878	i0	70.6	1.16666666666667	34	10	56.7	0	109	8	1	34	CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis]	diamond	210	56.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
30484915	30484915	PRJNA280983_P_NODE_7333_length_213_cov_1.036585_g7218_i0	PRJNA280983	7333	213	1.036585	2.20792605	Staurois parvus	386267	Chordata	Chordata	48.9	1.31e-5	NR	CAI9540006.1	386267	g7218	i0	54.5	0.619718309859155	44	20	62	0	62	193	1	44	CAI9540006.1 unnamed protein product, partial [Staurois parvus]	diamond	132	48.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
30642680	30642680	PRJNA280983_P_NODE_11413_length_161_cov_0.910714_g11298_i0	PRJNA280983	11413	161	0.910714	1.46624954	Panurus biarmicus	181101	Chordata	Chordata	70.5	2.01e-12	NR	NWW34925.1	181101	g11298	i0	60	1.02484472049689	55	20	98.8	1	160	2	1104	1158	NWW34925.1 BMS1 protein [Panurus biarmicus]	diamond	165	70.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Sylviidae	Panurus	Panurus biarmicus
30958882	30958882	PRJNA280983_P_NODE_8074_length_197_cov_0.804054_g7959_i0	PRJNA280983	8074	197	0.804054	1.58398638	Bufotes viridis	30338	Chordata	Chordata	42.7	0.02	NR	CAK8629749.1	30338	g7959	i0	46.2	1.26395939086294	39	18	54.8	1	156	49	319	357	CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis]	diamond	249	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
31274766	31274766	PRJNA280983_P_NODE_1875_length_535_cov_10.430041_g1762_i0	PRJNA280983	1875	535	10.430041	55.80071935	Staurois parvus	386267	Chordata	Chordata	58.5	1.63e-7	NR	CAI9533415.1	386267	g1762	i0	40	1.89532710280374	110	47	51	4	409	137	1	110	CAI9533415.1 unnamed protein product [Staurois parvus]	diamond	1014	58.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
32572076	32572076	PRJNA280983_P_NODE_6959_length_223_cov_1.086207_g6844_i0	PRJNA280983	6959	223	1.086207	2.42224161	Turdus rufiventris	311356	Chordata	Chordata	57.4	1.97e-7	NR	KAF4797634.1	311356	g6844	i0	83.9	0.766816143497758	31	5	41.7	0	220	128	486	516	KAF4797634.1 hypothetical protein TURU_071784 [Turdus rufiventris]	diamond	171	57.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Turdidae	Turdus	Turdus rufiventris
32855134	32855134	PRJNA280983_P_NODE_10400_length_165_cov_0.879310_g10285_i0	PRJNA280983	10400	165	0.87931	1.4508615	Engystomops pustulosus	76066	Chordata	Chordata	60.5	7.41e-9	NR	KAG8571490.1	76066	g10285	i0	65.9	9.30909090909091	44	15	80	0	132	1	1030	1073	KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus]	diamond	1536	60.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus

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