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

7 rows where analysis = "diamond", bioproject = "PRJEB12366" 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
20767	20767	PRJEB12366_P_NODE_18901_length_157_cov_1.967213_g18711_i0	PRJEB12366	18901	157	1.967213	3.08852441	Metazoa	33208	Chordata	Chordata	105	7.55e-25	NR	XP_023378286.1	132908	g18711	i0	92	6.72611464968153	50	4	95.5	0	6	155	442	491	XP_023378286.1 F-box/WD repeat-containing protein 1A isoform X9 [Pteropus vampyrus]	diamond	1056	106	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Pteropodidae	Pteropus	Pteropus vampyrus
8947742	8947742	PRJEB12366_P_NODE_17628_length_165_cov_1.146154_g17438_i0	PRJEB12366	17628	165	1.146154	1.8911541	Metazoa	33208	Chordata	Chordata	109	4.49e-26	NR	XP_009862085.1	7719	g17438	i0	96.3	28.4727272727273	54	2	98.2	0	163	2	105	158	XP_009862085.1 splicing factor 3B subunit 3 isoform X2 [Ciona intestinalis]	diamond	4698	110	0.990909090909091	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Cionidae	Ciona	Ciona intestinalis
16597549	16597549	PRJEB12366_P_NODE_14434_length_188_cov_2.875817_g14244_i0	PRJEB12366	14434	188	2.875817	5.40653596	Latimeria chalumnae	7897	Chordata	Chordata	97.8	1.28e-24	NR	XP_014343652.1	7897	g14244	i0	87	81.5585106382979	54	7	86.2	0	26	187	26	79	XP_014343652.1 U6 snRNA-associated Sm-like protein LSm6 isoform X1 [Latimeria chalumnae]	diamond	15333	97.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
27058318	27058318	PRJEB12366_P_NODE_6982_length_302_cov_1.382022_g6792_i0	PRJEB12366	6982	302	1.382022	4.17370644	Metazoa	33208	Chordata	Chordata	43.9	0.031	NR	XP_026540820.1	8663	g6792	i0	41.8	1.53973509933775	55	30	52.6	1	41	199	2613	2667	XP_026540820.1 LOW QUALITY PROTEIN: SCO-spondin [Notechis scutatus]	diamond	465	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Elapidae	Notechis	Notechis scutatus
28858268	28858268	PRJEB12366_P_NODE_19028_length_157_cov_0.983607_g18838_i0	PRJEB12366	19028	157	0.983607	1.54426299	root	1	Root_unresolved	Root_unresolved	77.4	6.04e-16	NR	KAE8607413.1	8364	g18838	i0	70.2	14.2356687898089	47	14	89.8	0	14	154	38	84	KAE8607413.1 hypothetical protein XENTR_v10011173 [Xenopus tropicalis]	diamond	2235	77.8	0.994858611825193	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
29117456	29117456	PRJEB12366_P_NODE_17349_length_166_cov_1.832061_g17159_i0	PRJEB12366	17349	166	1.832061	3.04122126	Cervus elaphus hippelaphus	46360	Chordata	Chordata	84.3	2.87e-17	NR	OWK15625.1	46360	g17159	i0	75.5	1.78915662650602	53	13	95.8	0	166	8	330	382	OWK15625.1 KLC3 [Cervus elaphus hippelaphus]	diamond	297	84.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Cervus	Cervus elaphus
32087753	32087753	PRJEB12366_P_NODE_15558_length_179_cov_2.770833_g15368_i0	PRJEB12366	15558	179	2.770833	4.95979107	Neotoma lepida	56216	Chordata	Chordata	86.3	3.82e-19	NR	OBS77550.1	56216	g15368	i0	95.7	1.57541899441341	46	2	77.1	0	161	24	1	46	OBS77550.1 hypothetical protein A6R68_20061, partial [Neotoma lepida]	diamond	282	86.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Neotoma	Neotoma lepida

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