metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA879314" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA879314" 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
9785683	9785683	PRJNA879314_P_NODE_1288_length_382_cov_2.307443_g1238_i0	PRJNA879314	1288	382	2.307443	8.81443226	Clavelina lepadiformis	159417	Chordata	Chordata	182	1.08e-52	NR	CAK8683257.1	159417	g1238	i0	70.5	48.0549738219895	122	36	95.8	0	367	2	1	122	CAK8683257.1 unnamed protein product [Clavelina lepadiformis]	diamond	18357	182	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Aplousobranchia	Clavelinidae	Clavelina	Clavelina lepadiformis
26675150	26675150	PRJNA879314_P_NODE_3061_length_285_cov_1.495283_g3011_i0	PRJNA879314	3061	285	1.495283	4.26155655	Bufotes viridis	30338	Chordata	Chordata	45.8	0.00487	NR	CAK8609802.1	30338	g3011	i0	60.6	0.789473684210526	33	13	34.7	0	186	284	1	33	CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis]	diamond	225	46.2	0.991341991341991	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
28571134	28571134	PRJNA879314_P_NODE_7387_length_248_cov_0.891429_g7337_i0	PRJNA879314	7387	248	0.891429	2.21074392	Bufotes viridis	30338	Chordata	Chordata	51.2	3.97e-5	NR	CAK8622139.1	30338	g7337	i0	36.8	1.86290322580645	76	48	91.9	0	3	230	214	289	CAK8622139.1 LINE-1 retrotransposable element ORF2 protein [Bufotes viridis]	diamond	462	51.6	0.992248062015504	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
29454896	29454896	PRJNA879314_P_NODE_2550_length_302_cov_2.458515_g2500_i0	PRJNA879314	2550	302	2.458515	7.4247153	Erpetoichthys calabaricus	27687	Chordata	Chordata	129	9.279999999999999e-34	NR	XP_051791274.1	27687	g2500	i0	76.1	6.99337748344371	88	20	86.4	1	261	1	115	202	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	2112	129	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
30149872	30149872	PRJNA879314_P_NODE_7812_length_247_cov_3.747126_g7762_i0	PRJNA879314	7812	247	3.747126	9.25540122	Stegostoma tigrinum	3053191	Chordata	Chordata	59.3	5.55e-8	NR	XP_048415584.1	3053191	g7762	i0	96.4	2.38056680161943	28	1	34	0	245	162	830	857	XP_048415584.1 elongation factor 2 [Stegostoma tigrinum]	diamond	588	59.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Orectolobiformes	Stegostomatidae	Stegostoma	Stegostoma tigrinum
31453887	31453887	PRJNA879314_P_NODE_5636_length_251_cov_0.876404_g5586_i0	PRJNA879314	5636	251	0.876404	2.19977404	Chordata	7711	Chordata	Chordata	103	1.83e-26	NR	NP_740225.1	178879	g5586	i0	98.1	130.494023904382	53	1	63.3	0	202	44	25	77	NP_740225.1 NADH dehydrogenase subunit 3 [Polypterus senegalus senegalus]	diamond	32754	104	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus

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