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

6 rows where analysis = "diamond", bioproject = "PRJNA229468" 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
1642070	1642070	PRJNA229468_S_NODE_862_length_180_cov_1.450382_g849_i0	PRJNA229468	862	180	1.450382	2.6106876	Trichechus manatus latirostris	127582	Chordata	Chordata	73.6	2.23e-13	NR	XP_004378497.1	127582	g849	i0	66.7	17.1	57	19	95	0	177	7	251	307	XP_004378497.1 E3 ubiquitin-protein ligase UHRF1 [Trichechus manatus latirostris]	diamond	3078	73.9	0.995940460081191	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Sirenia	Trichechidae	Trichechus	Trichechus manatus
11845856	11845856	PRJNA229468_S_NODE_930_length_175_cov_1.944444_g917_i0	PRJNA229468	930	175	1.944444	3.402777	Opisthokonta	33154	Chordata	Chordata	105	3.6199999999999997e-28	NR	KAH0506066.1	79684	g917	i0	86	17.0228571428571	57	8	97.7	0	3	173	6	62	KAH0506066.1 60S ribosomal protein L36a [Microtus ochrogaster]	diamond	2979	106	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Microtus	Microtus ochrogaster
16944571	16944571	PRJNA229468_S_NODE_694_length_197_cov_1.033784_g681_i0	PRJNA229468	694	197	1.033784	2.03655448	Chordata	7711	Chordata	Chordata	85.5	1.73e-17	NR	XP_067954439.1	7769	g681	i0	66.1	10.5837563451777	62	20	92.9	1	186	4	389	450	XP_067954439.1 LOW QUALITY PROTEIN: thioredoxin reductase 1, cytoplasmic-like [Myxine glutinosa]	diamond	2085	85.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Myxini	Myxiniformes	Myxinidae	Myxine	Myxine glutinosa
28134157	28134157	PRJNA229468_S_NODE_1045_length_167_cov_1.855932_g1032_i0	PRJNA229468	1045	167	1.855932	3.09940644	Mammalia	40674	Chordata	Chordata	80.1	8.94e-16	NR	XP_058138020.1	9361	g1032	i0	67.3	31.6167664670659	55	18	98.8	0	166	2	503	557	XP_058138020.1 E3 ubiquitin-protein ligase UHRF1 isoform X1 [Dasypus novemcinctus]	diamond	5280	80.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Cingulata	Dasypodidae	Dasypus	Dasypus novemcinctus
30358843	30358843	PRJNA229468_S_NODE_652_length_202_cov_1.666667_g639_i0	PRJNA229468	652	202	1.666667	3.36666734	Ascaphus truei	8439	Chordata	Chordata	51.6	1.17e-5	NR	MEE6511301.1	8439	g639	i0	37.1	1.03960396039604	70	36	93.6	2	3	191	165	233	MEE6511301.1 hypothetical protein [Ascaphus truei]	diamond	210	51.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ascaphidae	Ascaphus	Ascaphus truei
31717486	31717486	PRJNA229468_S_NODE_897_length_178_cov_1.162791_g884_i0	PRJNA229468	897	178	1.162791	2.06976798	Engystomops pustulosus	76066	Chordata	Chordata	43.9	7.71e-4	NR	KAG8588135.1	76066	g884	i0	57.1	0.589887640449438	35	13	59	1	1	105	37	69	KAG8588135.1 hypothetical protein GDO81_005883 [Engystomops pustulosus]	diamond	105	43.9	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);;