metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA826497" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA826497" 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
9748648	9748648	PRJNA826497_S_NODE_16348_length_160_cov_25.409449_g16308_i0	PRJNA826497	16348	160	25.409449	40.6551184	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	98.6	3.15e-24	NR	XP_067872921.1	7792	g16308	i0	82.4	21.0375	51	9	95.6	0	6	158	111	161	XP_067872921.1 peptidyl-prolyl cis-trans isomerase H isoform X1 [Heterodontus francisci]	diamond	3366	98.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Heterodontiformes	Heterodontidae	Heterodontus	Heterodontus francisci
26999655	26999655	PRJNA826497_S_NODE_7502_length_203_cov_6.129412_g7462_i0	PRJNA826497	7502	203	6.129412	12.44270636	Chiroptera	9397	Chordata	Chordata	43.5	0.0113	NR	KAF6452900.1	27622	g7462	i0	57.6	3.91625615763547	33	14	48.8	0	184	86	124	156	KAF6452900.1 hypothetical protein HJG59_008207 [Molossus molossus]	diamond	795	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Molossidae	Molossus	Molossus molossus
27559842	27559842	PRJNA826497_S_NODE_12744_length_174_cov_2.822695_g12704_i0	PRJNA826497	12744	174	2.822695	4.9114893	Bos mutus	72004	Chordata	Chordata	46.2	8.62e-4	NR	ELR60936.1	72004	g12704	i0	73.1	0.448275862068966	26	7	44.8	0	18	95	41	66	ELR60936.1 Membrane transport protein XK [Bos mutus]	diamond	78	46.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos mutus
28822677	28822677	PRJNA826497_S_NODE_9688_length_189_cov_3.192308_g9648_i0	PRJNA826497	9688	189	3.192308	6.03346212	Hyla sarda	327740	Chordata	Chordata	46.2	0.00108	NR	XP_056374702.1	327740	g9648	i0	44.6	0.888888888888889	56	30	87.3	1	166	2	4	59	XP_056374702.1 kinesin-like protein KIF9 [Hyla sarda]	diamond	168	46.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hylidae	Hyla	Hyla sarda
30094557	30094557	PRJNA826497_S_NODE_7932_length_200_cov_4.233533_g7892_i0	PRJNA826497	7932	200	4.233533	8.467066	Metazoa	33208	Chordata	Chordata	49.3	9.49e-5	NR	XP_067977652.1	7769	g7892	i0	74.1	4.08	27	7	40.5	0	32	112	105	131	XP_067977652.1 uncharacterized protein [Myxine glutinosa]	diamond	816	49.7	0.991951710261569	Eukaryota	Opisthokonta	Metazoa	Chordata	Myxini	Myxiniformes	Myxinidae	Myxine	Myxine glutinosa
30212286	30212286	PRJNA826497_S_NODE_13772_length_170_cov_1.686131_g13732_i0	PRJNA826497	13772	170	1.686131	2.8664227	Bufo bufo	8384	Chordata	Chordata	45.4	0.00158	NR	XP_040270245.1	8384	g13732	i0	55.3	1.41176470588235	38	17	67.1	0	55	168	85	122	XP_040270245.1 collagen alpha-1(VII) chain-like [Bufo bufo]	diamond	240	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufo	Bufo bufo
31856053	31856053	PRJNA826497_S_NODE_5057_length_226_cov_11.663212_g5017_i0	PRJNA826497	5057	226	11.663212	26.35885912	Mus musculus	10090	Chordata	Chordata	140	5.2499999999999997e-39	NR	4M69_A	10090	g5017	i0	100	2.54867256637168	64	0	85	0	210	19	236	299	4M69_A Chain A, Receptor-interacting serine/threonine-protein kinase 3 [Mus musculus]	diamond	576	140	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
32267611	32267611	PRJNA826497_S_NODE_16058_length_161_cov_12.046875_g16018_i0	PRJNA826497	16058	161	12.046875	19.39546875	Staurois parvus	386267	Chordata	Chordata	50.4	1.56e-5	NR	CAI9550647.1	386267	g16018	i0	52.3	0.819875776397516	44	16	72.7	2	117	1	159	202	CAI9550647.1 unnamed protein product [Staurois parvus]	diamond	132	50.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
32362616	32362616	PRJNA826497_S_NODE_12879_length_173_cov_6.585714_g12839_i0	PRJNA826497	12879	173	6.585714	11.39328522	Mus musculus	10090	Chordata	Chordata	50.4	2.73e-5	NR	NP_001157579.1	10090	g12839	i0	80.8	1.35260115606936	26	5	45.1	0	2	79	397	422	NP_001157579.1 receptor-interacting serine/threonine-protein kinase 3 isoform 2 [Mus musculus]	diamond	234	50.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
32867073	32867073	PRJNA826497_S_NODE_5180_length_225_cov_3.718750_g5140_i0	PRJNA826497	5180	225	3.71875	8.3671875	Bos mutus	72004	Chordata	Chordata	50.8	2.56e-6	NR	ELR55903.1	72004	g5140	i0	57.1	2.04	49	21	65.3	0	16	162	15	63	ELR55903.1 hypothetical protein M91_19821, partial [Bos mutus]	diamond	459	50.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos mutus

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