metadata: contig_metadata: 5 rows where bioproject = "PRJNA1197996", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA1197996", tax_kingdom = "Metazoa" 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
324392	324392	PRJNA1197996_S_NODE_9901_length_335_cov_2.427481_g9847_i0	PRJNA1197996	9901	335	2.4274810000000002	8.13206135	Metazoa	33208	Brachiopoda	other_Eukaryota	115	2.899999999999999e-29	NR	XP_013399112.1	7574	g9847	i0	64.7	6.79701492537313	85	28	74.3	1	3	251	166	250	XP_013399112.1 isopentenyl-diphosphate Delta-isomerase 1-like [Lingula anatina]	diamond	2277	116	0.991379310344828	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
24549918	24549918	PRJNA1197996_S_NODE_10020_length_334_cov_1.739464_g9966_i0	PRJNA1197996	10020	334	1.739464	5.80980976	Lingula anatina	7574	Brachiopoda	other_Eukaryota	71.2	2.99e-12	NR	XP_013413032.1	7574	g9966	i0	44.3	0.62874251497006	70	39	62.9	0	332	123	157	226	XP_013413032.1 sulfotransferase family cytosolic 1B member 1 isoform X1 [Lingula anatina]	diamond	210	71.2	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
27103972	27103972	PRJNA1197996_S_NODE_2382_length_527_cov_6.092511_g2331_i0	PRJNA1197996	2382	527	6.092511	32.10753297	Lingula anatina	7574	Brachiopoda	other_Eukaryota	86.3	4.28e-16	NR	XP_023933064.1	7574	g2331	i0	85.1	1.33776091081594	47	7	26.8	0	2	142	434	480	XP_023933064.1 calumenin-A-like [Lingula anatina]	diamond	705	86.3	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
29724793	29724793	PRJNA1197996_S_NODE_18230_length_275_cov_3.495050_g18176_i0	PRJNA1197996	18230	275	3.49505	9.6113875	Lingula anatina	7574	Brachiopoda	other_Eukaryota	45.1	0.0075	NR	XP_013393501.1	7574	g18176	i0	51.8	1.44	56	24	58.9	2	3	164	218	272	XP_013393501.1 proteasome subunit alpha type-1 [Lingula anatina]	diamond	396	45.1	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
31020473	31020473	PRJNA1197996_S_NODE_18435_length_274_cov_2.741294_g18381_i0	PRJNA1197996	18435	274	2.741294	7.51114556	Lingula anatina	7574	Brachiopoda	other_Eukaryota	73.6	1.72e-13	NR	XP_013383896.1	7574	g18381	i0	71.4	1.65328467153285	49	14	53.6	0	2	148	178	226	XP_013383896.1 EEF1A lysine methyltransferase 2-like [Lingula anatina]	diamond	453	73.6	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);;