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

5 rows where analysis = "diamond", bioproject = "PRJNA773247" 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
17326997	17326997	PRJNA773247_P_NODE_10194_length_491_cov_18.401914_g10111_i0	PRJNA773247	10194	491	18.401914	90.35339774	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	213	3.3e-66	NR	KAE8602086.1	8364	g10111	i0	79.5	245.9633401222	122	25	74.5	0	4	369	169	290	KAE8602086.1 hypothetical protein XENTR_v10013878 [Xenopus tropicalis]	diamond	120768	214	0.995327102803738	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
29642408	29642408	PRJNA773247_P_NODE_15750_length_372_cov_9.521739_g15666_i0	PRJNA773247	15750	372	9.521739	35.42086908	Chionomys nivalis	269649	Chordata	Chordata	45.1	0.0248	NR	XP_057607189.1	269649	g15666	i0	40.3	0.5	62	33	48.4	2	229	50	843	902	XP_057607189.1 rho guanine nucleotide exchange factor 4 isoform X3 [Chionomys nivalis]	diamond	186	45.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Chionomys	Chionomys nivalis
31896090	31896090	PRJNA773247_P_NODE_10157_length_492_cov_15.267303_g10074_i0	PRJNA773247	10157	492	15.267303	75.11513076	Metazoa	33208	Chordata	Chordata	65.1	2.34e-10	NR	ELR57188.1	72004	g10074	i0	41	3.59146341463415	100	47	53.7	2	458	195	1	100	ELR57188.1 60S acidic ribosomal protein P2, partial [Bos mutus]	diamond	1767	65.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos mutus
32044881	32044881	PRJNA773247_P_NODE_9338_length_521_cov_3.459821_g9255_i0	PRJNA773247	9338	521	3.459821	18.02566741	Spizaetus tyrannus	252798	Chordata	Chordata	47	0.0143	NR	NXJ57053.1	252798	g9255	i0	43.1	0.414587332053743	72	34	38.6	3	517	317	85	154	NXJ57053.1 PDLI2 protein [Spizaetus tyrannus]	diamond	216	47	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Accipitriformes	Accipitridae	Spizaetus	Spizaetus tyrannus
32298304	32298304	PRJNA773247_P_NODE_26259_length_272_cov_3.728643_g26175_i0	PRJNA773247	26259	272	3.728643	10.14190896	Perognathus longimembris pacificus	214514	Chordata	Chordata	45.4	0.006	NR	XP_048225255.1	214514	g26175	i0	42.5	0.805147058823529	73	35	75	2	29	232	642	712	XP_048225255.1 uncharacterized protein ZSWIM9 isoform X2 [Perognathus longimembris pacificus]	diamond	219	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Heteromyidae	Perognathus	Perognathus longimembris

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