metadata: contig_metadata: 5 rows where bioproject = "PRJNA801875" and tax

5 rows where bioproject = "PRJNA801875" and tax_phylum = "Brachiopoda"

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
3351963	3351963	PRJNA801875_P_NODE_1483_length_317_cov_2.156028_g1380_i0	PRJNA801875	1483	317	2.156028	6.83460876	Metazoa	33208	Brachiopoda	other_Eukaryota	145	4.26e-40	NR	XP_013394415.1	7574	g1380	i0	69.6	25.410094637224	92	28	87.1	0	314	39	118	209	XP_013394415.1 40S ribosomal protein SA-like [Lingula anatina]	diamond	8055	146	0.993150684931507	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
6325730	6325730	PRJNA801875_P_NODE_1625_length_299_cov_2.178030_g1522_i0	PRJNA801875	1625	299	2.17803	6.5123097	Metazoa	33208	Brachiopoda	other_Eukaryota	150	9.95e-40	NR	XP_013394736.1	7574	g1522	i0	76.5	6.14046822742475	102	20	98.3	1	296	3	6	107	XP_013394736.1 elongation factor 2 [Lingula anatina]	diamond	1836	150	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
30275592	30275592	PRJNA801875_P_NODE_1172_length_372_cov_2.991098_g1069_i0	PRJNA801875	1172	372	2.991098	11.12688456	Lingula anatina	7574	Brachiopoda	other_Eukaryota	47.4	0.00342	NR	XP_013403634.1	7574	g1069	i0	30.7	1.54838709677419	101	66	81.5	2	1	303	220	316	XP_013403634.1 peptidyl-prolyl cis-trans isomerase D [Lingula anatina]	diamond	576	47.4	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
32520528	32520528	PRJNA801875_P_NODE_4739_length_151_cov_1.008621_g4636_i0	PRJNA801875	4739	151	1.008621	1.52301771	Lingula anatina	7574	Brachiopoda	other_Eukaryota	48.5	9.79e-5	NR	XP_013380617.1	7574	g4636	i0	65.7	1.45033112582781	35	12	69.5	0	7	111	233	267	XP_013380617.1 serine/threonine-protein kinase PLK4-like [Lingula anatina]	diamond	219	48.5	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
32583632	32583632	PRJNA801875_P_NODE_2139_length_243_cov_1.495192_g2036_i0	PRJNA801875	2139	243	1.495192	3.63331656	Lingula anatina	7574	Brachiopoda	other_Eukaryota	85.5	8.12e-19	NR	XP_013412907.1	7574	g2036	i0	50	0.987654320987654	80	37	98.8	1	240	1	72	148	XP_013412907.1 eukaryotic translation initiation factor 5A-1 [Lingula anatina]	diamond	240	85.5	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina

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