metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB7799" 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
25799357	25799357	PRJEB7799h_S_NODE_4291_length_165_cov_1.346154_g4288_i0	PRJEB7799	4291	165	1.346154	2.2211541	Lamprotornis superbus	245042	Chordata	Chordata	69.3	1.74e-12	NR	KAI1234130.1	245042	g4288	i0	61.1	10.5454545454545	54	19	98.2	1	1	162	129	180	KAI1234130.1 hypothetical protein IHE44_0003845 [Lamprotornis superbus]	diamond	1740	69.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Sturnidae	Lamprotornis	Lamprotornis superbus
32923230	32923230	PRJEB7799o_S_NODE_3297_length_168_cov_2.654135_g3289_i0	PRJEB7799	3297	168	2.654135	4.4589468	Metazoa	33208	Chordata	Chordata	43.1	0.0052	NR	KAF6347324.1	59472	g3289	i0	54.1	8.5	37	17	66.1	0	168	58	95	131	KAF6347324.1 ribosomal protein S3A [Pipistrellus kuhlii]	diamond	1428	43.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Vespertilionidae	Pipistrellus	Pipistrellus kuhlii
32974743	32974743	PRJEB7799n_S_NODE_4538_length_216_cov_4.867403_g4501_i0	PRJEB7799	4538	216	4.867403	10.51359048	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	69.7	7.79e-14	NR	3J0L_X	9986	g4501	i0	61.3	1.73611111111111	62	20	80.6	2	212	39	1	62	3J0L_X Chain X, Ribosomal protein S30 [Oryctolagus cuniculus]	diamond	375	70.1	0.994293865905849	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Lagomorpha	Leporidae	Oryctolagus	Oryctolagus cuniculus
32974786	32974786	PRJEB7799p_S_NODE_7586_length_206_cov_2.701754_g7563_i0	PRJEB7799	7586	206	2.701754	5.56561324	Mammalia	40674	Chordata	Chordata	70.9	7.81e-14	NR	XP_035294684.1	10029	g7563	i0	64.8	59.7815533980583	54	19	78.6	0	202	41	61	114	XP_035294684.1 60S ribosomal protein L23a isoform X2 [Cricetulus griseus]	diamond	12315	71.6	0.990223463687151	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Cricetulus	Cricetulus griseus
32991792	32991792	PRJEB7799n_S_NODE_4227_length_223_cov_4.803191_g4190_i0	PRJEB7799	4227	223	4.803191	10.71111593	root	1	Root_unresolved	Root_unresolved	42.4	0.0392	NR	MEE6468930.1	8439	g4190	i0	45.6	1.60089686098655	57	25	72.6	2	54	215	987	1040	MEE6468930.1 hypothetical protein [Ascaphus truei]	diamond	357	42.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ascaphidae	Ascaphus	Ascaphus truei
33101694	33101694	PRJEB7799p_S_NODE_9702_length_194_cov_1.459119_g9679_i0	PRJEB7799	9702	194	1.459119	2.83069086	Branchiostoma belcheri	7741	Chordata	Chordata	44.3	0.0021	NR	XP_019639315.1	7741	g9679	i0	48.9	1.42268041237113	45	19	69.6	1	187	53	90	130	XP_019639315.1 PREDICTED: profilin-1A-like [Branchiostoma belcheri]	diamond	276	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
33135777	33135777	PRJEB7799p_S_NODE_5327_length_229_cov_2.489691_g5304_i0	PRJEB7799	5327	229	2.489691	5.70139239	Varanus komodoensis	61221	Chordata	Chordata	63.2	1.49e-9	NR	KAF7240769.1	61221	g5304	i0	58.9	5.86899563318777	56	23	73.4	0	1	168	246	301	KAF7240769.1 60S ribosomal protein L6 [Varanus komodoensis]	diamond	1344	63.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Varanidae	Varanus	Varanus komodoensis
33152265	33152265	PRJEB7799l_S_NODE_11280_length_164_cov_1.434109_g11251_i0	PRJEB7799	11280	164	1.434109	2.35193876	Myotis brandtii	109478	Chordata	Chordata	42.4	0.00853	NR	EPQ05826.1	109478	g11251	i0	44.4	0.658536585365854	36	20	65.9	0	52	159	6	41	EPQ05826.1 hypothetical protein D623_10006509 [Myotis brandtii]	diamond	108	42.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Vespertilionidae	Myotis	Myotis brandtii
33152730	33152730	PRJEB7799p_S_NODE_1808_length_331_cov_1.841216_g1785_i0	PRJEB7799	1808	331	1.841216	6.09442496	Eubalaena glacialis	27606	Chordata	Chordata	91.7	3.32e-20	NR	XP_061048735.1	27606	g1785	i0	61.8	5.13897280966767	68	26	61.6	0	329	126	146	213	XP_061048735.1 small ribosomal subunit protein eS4, X isoform-like [Eubalaena glacialis]	diamond	1701	91.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Balaenidae	Eubalaena	Eubalaena glacialis

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