metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA572587" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA572587" 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
26667733	26667733	PRJNA572587_P_NODE_21401_length_244_cov_13.025641_g21073_i0	PRJNA572587	21401	244	13.025641	31.78256404	Polypterus senegalus	55291	Chordata	Chordata	102	5.81e-24	NR	KAG2468145.1	55291	g21073	i0	73	1.81967213114754	74	20	91	0	22	243	132	205	KAG2468145.1 R144A ligase, partial [Polypterus senegalus]	diamond	444	102	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
27900569	27900569	PRJNA572587_P_NODE_17945_length_268_cov_53.415525_g17617_i0	PRJNA572587	17945	268	53.415525	143.153607	Orcinus orca	9733	Chordata	Chordata	44.3	0.0136	NR	XP_049552061.1	9733	g17617	i0	73.3	0.335820895522388	30	8	33.6	0	148	59	186	215	XP_049552061.1 COMM domain-containing protein 1 isoform X1 [Orcinus orca]	diamond	90	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Delphinidae	Orcinus	Orcinus orca
27995571	27995571	PRJNA572587_P_NODE_25145_length_224_cov_1.457143_g24817_i0	PRJNA572587	25145	224	1.457143	3.26400032	Columba livia	8932	Chordata	Chordata	42.4	0.0415	NR	PKK23084.1	8932	g24817	i0	46.3	0.723214285714286	54	22	72.3	2	197	36	679	725	PKK23084.1 complement component (3b/4b) receptor 1 (Knops blood group) [Columba livia]	diamond	162	42.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Columbiformes	Columbidae	Columba	Columba livia
28419721	28419721	PRJNA572587_P_NODE_31326_length_198_cov_12.281879_g30998_i0	PRJNA572587	31326	198	12.281879	24.31812042	Artiodactyla	91561	Chordata	Chordata	48.9	2.32e-5	NR	XDB51726.1	9925	g30998	i0	43.2	2.07575757575758	44	23	66.7	1	42	173	62	103	XDB51726.1 hypothetical protein ABFV05_005342 [Capra hircus]	diamond	411	48.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Capra	Capra hircus
28627187	28627187	PRJNA572587_P_NODE_14627_length_302_cov_1.114625_g14299_i0	PRJNA572587	14627	302	1.114625	3.3661675	Elgaria multicarinata webbii	159646	Chordata	Chordata	77	3.27e-14	NR	XP_062991674.1	159646	g14299	i0	76.1	27.317880794702	46	11	45.7	0	141	4	159	204	XP_062991674.1 aminoacyl tRNA synthase complex-interacting multifunctional protein 1 isoform X3 [Elgaria multicarinata webbii]	diamond	8250	77.4	0.994832041343669	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Anguidae	Elgaria	Elgaria multicarinata
30142344	30142344	PRJNA572587_P_NODE_37812_length_178_cov_19.589147_g37484_i0	PRJNA572587	37812	178	19.589147	34.86868166	Pristiophorus japonicus	55135	Chordata	Chordata	42.4	0.0217	NR	XP_070718146.1	55135	g37484	i0	45.8	0.808988764044944	48	21	80.9	2	157	14	198	240	XP_070718146.1 probable G-protein coupled receptor 139 [Pristiophorus japonicus]	diamond	144	42.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes		Pristiophoridae	Pristiophorus	Pristiophorus japonicus
30566739	30566739	PRJNA572587_P_NODE_34793_length_187_cov_4.942029_g34465_i0	PRJNA572587	34793	187	4.942029	9.24159423	Chordata	7711	Chordata	Chordata	109	9.77e-28	NR	PIO29040.1	8400	g34465	i0	98	75.3048128342246	51	1	81.8	0	17	169	3	53	PIO29040.1 hypothetical protein AB205_0122760, partial [Aquarana catesbeiana]	diamond	14082	110	0.990909090909091	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Aquarana	Aquarana catesbeiana

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