metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1215774" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1215774" 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
26946025	26946025	PRJNA1215774_P_NODE_58182_length_275_cov_2.059406_g57862_i0	PRJNA1215774	58182	275	2.059406	5.6633665	Staurois parvus	386267	Chordata	Chordata	53.1	1.63e-6	NR	CAI9557087.1	386267	g57862	i0	65.7	0.763636363636364	35	10	36	1	144	242	24	58	CAI9557087.1 unnamed protein product, partial [Staurois parvus]	diamond	210	53.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
27293920	27293920	PRJNA1215774_P_NODE_56823_length_279_cov_1.179612_g56503_i0	PRJNA1215774	56823	279	1.179612	3.29111748	Polypterus senegalus	55291	Chordata	Chordata	67.4	9.44e-11	NR	KAG2460242.1	55291	g56503	i0	54.4	7.3010752688172	68	31	73.1	0	265	62	178	245	KAG2460242.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	2037	67.8	0.994100294985251	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
31842552	31842552	PRJNA1215774_P_NODE_54937_length_284_cov_1.255924_g54617_i0	PRJNA1215774	54937	284	1.255924	3.56682416	Engystomops pustulosus	76066	Chordata	Chordata	80.1	4.55e-15	NR	KAG8571490.1	76066	g54617	i0	54.3	12.9084507042254	94	43	99.3	0	2	283	1011	1104	KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus]	diamond	3666	80.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
32507427	32507427	PRJNA1215774_P_NODE_80039_length_244_cov_0.900585_g79719_i0	PRJNA1215774	80039	244	0.900585	2.1974274	Polypterus senegalus	55291	Chordata	Chordata	82	3.06e-16	NR	KAG2456550.1	55291	g79719	i0	72.9	9.24590163934426	48	13	59	0	243	100	280	327	KAG2456550.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	2256	82	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus

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