metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA556842" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA556842" 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
27773384	27773384	PRJNA556842_P_NODE_4444_length_443_cov_4.133005_g3948_i0	PRJNA556842	4444	443	4.133005	18.30921215	Staurois parvus	386267	Chordata	Chordata	53.5	5.8e-6	NR	CAI9557087.1	386267	g3948	i0	63.9	0.487584650112867	36	11	23	1	235	336	24	59	CAI9557087.1 unnamed protein product, partial [Staurois parvus]	diamond	216	53.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
28689096	28689096	PRJNA556842_P_NODE_17047_length_156_cov_1.983193_g16542_i0	PRJNA556842	17047	156	1.983193	3.09378108	Staurois parvus	386267	Chordata	Chordata	40.4	0.00759	NR	CAI9622433.1	386267	g16542	i0	78.9	0.365384615384615	19	4	36.5	0	3	59	14	32	CAI9622433.1 unnamed protein product, partial [Staurois parvus]	diamond	57	40.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
29793804	29793804	PRJNA556842_P_NODE_7991_length_292_cov_1.968627_g7487_i0	PRJNA556842	7991	292	1.968627	5.74839084	Bufotes viridis	30338	Chordata	Chordata	43.1	0.0447	NR	CAK8629749.1	30338	g7487	i0	60	0.35958904109589	35	14	36	0	200	96	329	363	CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis]	diamond	105	43.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
30204372	30204372	PRJNA556842_P_NODE_12912_length_195_cov_1.120253_g12407_i0	PRJNA556842	12912	195	1.120253	2.18449335	Polypterus senegalus	55291	Chordata	Chordata	65.1	2.32e-10	NR	KAG2461018.1	55291	g12407	i0	60.4	3.15384615384615	53	21	81.5	0	195	37	287	339	KAG2461018.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	615	65.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
32006530	32006530	PRJNA556842_P_NODE_16978_length_157_cov_1.025000_g16473_i0	PRJNA556842	16978	157	1.025	1.60925	Colius striatus	57412	Chordata	Chordata	43.5	0.00595	NR	XP_061871356.1	57412	g16473	i0	39.6	0.917197452229299	48	25	91.7	1	149	6	273	316	XP_061871356.1 lysophosphatidic acid receptor 2 isoform X2 [Colius striatus]	diamond	144	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Coliiformes	Coliidae	Colius	Colius striatus

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