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

7 rows where analysis = "diamond", bioproject = "PRJNA1143173" 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
27133270	27133270	PRJNA1143173_P_NODE_25782_length_270_cov_2.710660_g25756_i0	PRJNA1143173	25782	270	2.71066	7.318782	Coturnix japonica	93934	Chordata	Chordata	60.5	2.07e-8	NR	XP_015706233.1	93934	g25756	i0	68.3	4.26666666666667	41	12	44.4	1	76	195	102	142	XP_015706233.1 LOW QUALITY PROTEIN: serine/threonine-protein phosphatase 4 catalytic subunit-like [Coturnix japonica]	diamond	1152	60.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Coturnix	Coturnix japonica
28018104	28018104	PRJNA1143173_P_NODE_36125_length_240_cov_3.970060_g36099_i0	PRJNA1143173	36125	240	3.97006	9.528144	Diceros bicornis minor	77932	Chordata	Chordata	50.8	5.01e-5	NR	KAF5922147.1	77932	g36099	i0	64.9	0.4625	37	13	46.3	0	122	12	184	220	KAF5922147.1 hypothetical protein HPG69_007033 [Diceros bicornis minor]	diamond	111	50.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Perissodactyla	Rhinocerotidae	Diceros	Diceros bicornis
29407164	29407164	PRJNA1143173_P_NODE_28049_length_263_cov_4.584211_g28023_i0	PRJNA1143173	28049	263	4.584211	12.05647493	Sus scrofa	9823	Chordata	Chordata	67	1.36e-10	NR	XP_020946894.1	9823	g28023	i0	55.2	0.76425855513308	67	30	76.4	0	48	248	405	471	XP_020946894.1 collagen alpha-2(I) chain-like [Sus scrofa]	diamond	201	67	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
30702290	30702290	PRJNA1143173_P_NODE_15354_length_298_cov_5.453333_g15328_i0	PRJNA1143173	15354	298	5.453333	16.25093234	Branchiostoma belcheri	7741	Chordata	Chordata	42.4	0.0322	NR	KAI8521773.1	7741	g15328	i0	47.4	0.38255033557047	38	20	38.3	0	197	84	22	59	KAI8521773.1 hypothetical protein Bbelb_015270 [Branchiostoma belcheri]	diamond	114	42.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
31797604	31797604	PRJNA1143173_P_NODE_42337_length_212_cov_7.956835_g42311_i0	PRJNA1143173	42337	212	7.956835	16.8684902	root	1	Root_unresolved	Root_unresolved	139	1.21e-36	NR	XP_030110853.2	10090	g42311	i0	97.1	11.8584905660377	70	2	99.1	0	1	210	103	172	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	2514	140	0.992857142857143	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
32315383	32315383	PRJNA1143173_P_NODE_13839_length_299_cov_5.287611_g13813_i0	PRJNA1143173	13839	299	5.287611	15.80995689	Heterodontus francisci	7792	Chordata	Chordata	55.1	3.52e-6	NR	XP_067914660.1	7792	g13813	i0	31.3	1.92642140468227	96	60	90.3	2	278	9	671	766	XP_067914660.1 uncharacterized protein wu:fj29h11 isoform X2 [Heterodontus francisci]	diamond	576	55.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Heterodontiformes	Heterodontidae	Heterodontus	Heterodontus francisci
32536747	32536747	PRJNA1143173_P_NODE_41039_length_220_cov_6.857143_g41013_i0	PRJNA1143173	41039	220	6.857143	15.0857146	Pleurodeles waltl	8319	Chordata	Chordata	45.4	0.0028	NR	KAJ1125738.1	8319	g41013	i0	46.2	0.886363636363636	65	31	85.9	2	30	218	68	130	KAJ1125738.1 hypothetical protein NDU88_004161 [Pleurodeles waltl]	diamond	195	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl

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