metadata: contig_metadata: 4 rows where bioproject = "PRJNA408129", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA408129", 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
26600410	26600410	PRJNA408129_S_NODE_3281_length_298_cov_4.639847_g3263_i0	PRJNA408129	3281	298	4.639847	13.82674406	Lingula anatina	7574	Brachiopoda	other_Eukaryota	94	3.6e-20	NR	XP_013409912.1	7574	g3263	i0	64.5	7.52013422818792	76	27	76.5	0	292	65	307	382	XP_013409912.1 vacuolar protein-sorting-associated protein 36 [Lingula anatina]	diamond	2241	94	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
27138312	27138312	PRJNA408129_S_NODE_13902_length_200_cov_4.368098_g13884_i0	PRJNA408129	13902	200	4.368098	8.736196	Lingula anatina	7574	Brachiopoda	other_Eukaryota	51.6	1.6e-5	NR	XP_013390064.1	7574	g13884	i0	42.6	1.83	61	35	91.5	0	17	199	936	996	XP_013390064.1 nucleoprotein TPR [Lingula anatina]	diamond	366	51.6	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
31276156	31276156	PRJNA408129_S_NODE_24635_length_168_cov_1.122137_g24617_i0	PRJNA408129	24635	168	1.122137	1.88519016	Lingula anatina	7574	Brachiopoda	other_Eukaryota	45.1	0.00215	NR	XP_013381033.1	7574	g24617	i0	54	0.892857142857143	50	21	89.3	1	153	4	721	768	XP_013381033.1 midasin-like [Lingula anatina]	diamond	150	45.1	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
31719043	31719043	PRJNA408129_S_NODE_27837_length_162_cov_0.904000_g27819_i0	PRJNA408129	27837	162	0.904	1.46448	Lingula anatina	7574	Brachiopoda	other_Eukaryota	62	2.02e-9	NR	XP_013380389.1	7574	g27819	i0	64.2	0.981481481481482	53	18	98.1	1	4	162	56	107	XP_013380389.1 solute carrier family 2, facilitated glucose transporter member 10 isoform X2 [Lingula anatina]	diamond	159	62	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);;