metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA505329" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA505329" 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
26887463	26887463	PRJNA505329_P_NODE_29001_length_188_cov_5.719424_g28530_i0	PRJNA505329	29001	188	5.719424	10.75251712	Sus scrofa	9823	Chordata	Chordata	48.5	1.64e-4	NR	XP_020946894.1	9823	g28530	i0	55.3	0.75	47	21	75	0	17	157	325	371	XP_020946894.1 collagen alpha-2(I) chain-like [Sus scrofa]	diamond	141	48.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
27298385	27298385	PRJNA505329_P_NODE_47403_length_164_cov_1.782609_g46932_i0	PRJNA505329	47403	164	1.782609	2.92347876	Staurois parvus	386267	Chordata	Chordata	50.4	5.44e-6	NR	CAI9548327.1	386267	g46932	i0	62.2	0.823170731707317	45	12	73.2	1	120	1	47	91	CAI9548327.1 unnamed protein product [Staurois parvus]	diamond	135	50.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
27803760	27803760	PRJNA505329_P_NODE_45544_length_166_cov_0.888889_g45073_i0	PRJNA505329	45544	166	0.888889	1.47555574	Crocuta crocuta	9678	Chordata	Chordata	44.3	0.00145	NR	KAF0880757.1	9678	g45073	i0	64.7	1.10240963855422	34	12	61.4	0	138	37	15	48	KAF0880757.1 LORF2 protein, partial [Crocuta crocuta]	diamond	183	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Hyaenidae	Crocuta	Crocuta crocuta
28403518	28403518	PRJNA505329_P_NODE_24666_length_195_cov_3.458904_g24195_i0	PRJNA505329	24666	195	3.458904	6.7448628	Mesocricetus auratus	10036	Chordata	Chordata	42	0.0362	NR	XP_005085349.2	10036	g24195	i0	37.5	1.10769230769231	72	33	92.3	3	9	188	249	320	XP_005085349.2 ceramide synthase 4 [Mesocricetus auratus]	diamond	216	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Mesocricetus	Mesocricetus auratus
28466817	28466817	PRJNA505329_P_NODE_38666_length_174_cov_1.640000_g38195_i0	PRJNA505329	38666	174	1.64	2.8536	Ceratotherium simum simum	73337	Chordata	Chordata	41.6	0.0393	NR	XP_014645778.1	73337	g38195	i0	38.6	0.758620689655172	44	27	75.9	0	150	19	252	295	XP_014645778.1 PREDICTED: autophagy-related protein 16-2 [Ceratotherium simum simum]	diamond	132	41.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Perissodactyla	Rhinocerotidae	Ceratotherium	Ceratotherium simum
30582403	30582403	PRJNA505329_P_NODE_30413_length_186_cov_3.722628_g29942_i0	PRJNA505329	30413	186	3.722628	6.92408808	Sus scrofa	9823	Chordata	Chordata	45.8	0.00143	NR	XP_020937328.1	9823	g29942	i0	47.7	0.709677419354839	44	23	71	0	166	35	12	55	XP_020937328.1 collagen alpha-2(I) chain-like [Sus scrofa]	diamond	132	45.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
30898697	30898697	PRJNA505329_P_NODE_11274_length_233_cov_3.548913_g10803_i0	PRJNA505329	11274	233	3.548913	8.26896729	Hyperolius riggenbachi	752182	Chordata	Chordata	43.1	0.0246	NR	XP_068115012.1	752182	g10803	i0	61.3	1.60944206008584	31	12	39.9	0	96	4	70	100	XP_068115012.1 guanylate cyclase 2G-like [Hyperolius riggenbachi]	diamond	375	43.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hyperoliidae	Hyperolius	Hyperolius riggenbachi
31103450	31103450	PRJNA505329_P_NODE_34995_length_179_cov_3.900000_g34524_i0	PRJNA505329	34995	179	3.9	6.981	Metazoa	33208	Chordata	Chordata	49.3	7.32e-5	NR	XP_067976134.1	7769	g34524	i0	47.5	5.93296089385475	59	28	93.9	2	169	2	6	64	XP_067976134.1 methyltransferase N6AMT1 isoform X3 [Myxine glutinosa]	diamond	1062	49.7	0.991951710261569	Eukaryota	Opisthokonta	Metazoa	Chordata	Myxini	Myxiniformes	Myxinidae	Myxine	Myxine glutinosa
31182620	31182620	PRJNA505329_P_NODE_43855_length_167_cov_2.262712_g43384_i0	PRJNA505329	43855	167	2.262712	3.77872904	Amblyraja radiata	386614	Chordata	Chordata	57.4	9.03e-8	NR	XP_032882298.1	386614	g43384	i0	63	0.826347305389222	46	17	82.6	0	166	29	360	405	XP_032882298.1 LOW QUALITY PROTEIN: uncharacterized protein LOC116976515, partial [Amblyraja radiata]	diamond	138	57.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Rajiformes	Rajidae	Amblyraja	Amblyraja radiata
31594294	31594294	PRJNA505329_P_NODE_35736_length_178_cov_3.023256_g35265_i0	PRJNA505329	35736	178	3.023256	5.38139568	Eschrichtius robustus	9764	Chordata	Chordata	48.5	1.35e-4	NR	MBV94732.1	9764	g35265	i0	55.6	0.758426966292135	45	11	75.8	2	137	3	239	274	MBV94732.1 Ribosome maturation protein SBDS [Eschrichtius robustus]	diamond	135	48.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Eschrichtiidae	Eschrichtius	Eschrichtius robustus
32543415	32543415	PRJNA505329_P_NODE_22699_length_200_cov_2.715232_g22228_i0	PRJNA505329	22699	200	2.715232	5.430464	Phocoena sinus	42100	Chordata	Chordata	51.6	1.54e-5	NR	XP_032458646.1	42100	g22228	i0	63.6	0.495	33	12	49.5	0	198	100	114	146	XP_032458646.1 ras-related protein Rab-31 isoform X1 [Phocoena sinus]	diamond	99	51.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Phocoenidae	Phocoena	Phocoena sinus
32700592	32700592	PRJNA505329_P_NODE_39040_length_173_cov_2.475806_g38569_i0	PRJNA505329	39040	173	2.475806	4.28314438	Ictidomys tridecemlineatus	43179	Chordata	Chordata	41.6	0.013	NR	KAG3273830.1	43179	g38569	i0	38.9	0.936416184971098	54	33	93.6	0	3	164	44	97	KAG3273830.1 hypothetical protein H1C71_019247, partial [Ictidomys tridecemlineatus]	diamond	162	41.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Sciuridae	Ictidomys	Ictidomys tridecemlineatus

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