metadata: contig_metadata: 6 rows where bioproject = "PRJNA688736", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJNA688736", tax_clade = "Opisthokonta" 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
24894207	24894207	PRJNA688736_P_NODE_4280_length_691_cov_5.250809_g4014_i0	PRJNA688736	4280	691	5.250809	36.28309019	Lingula anatina	7574	Brachiopoda	other_Eukaryota	348	1.01e-118	NR	XP_013395677.1	7574	g4014	i0	81.9	2.93487698986975	227	40	98.1	1	679	2	1	227	XP_013395677.1 60S ribosomal protein L7a [Lingula anatina]	diamond	2028	348	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
26840926	26840926	PRJNA688736_P_NODE_46941_length_246_cov_0.901734_g46656_i0	PRJNA688736	46941	246	0.901734	2.21826564	Metazoa	33208	Brachiopoda	other_Eukaryota	107	5.02e-25	NR	XP_013411028.1	7574	g46656	i0	54.3	8.89024390243902	81	35	98.8	1	4	246	196	274	XP_013411028.1 sialin [Lingula anatina]	diamond	2187	107	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
28850531	28850531	PRJNA688736_P_NODE_15328_length_391_cov_3.625786_g15043_i0	PRJNA688736	15328	391	3.625786	14.17682326	Lingula anatina	7574	Brachiopoda	other_Eukaryota	194	2.39e-60	NR	XP_013399327.1	7574	g15043	i0	81	5.82352941176471	126	24	96.7	0	380	3	2	127	XP_013399327.1 40S ribosomal protein S7 [Lingula anatina]	diamond	2277	194	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
31093329	31093329	PRJNA688736_P_NODE_44955_length_248_cov_0.891429_g44670_i0	PRJNA688736	44955	248	0.891429	2.21074392	Lingula anatina	7574	Brachiopoda	other_Eukaryota	55.5	1.27e-6	NR	XP_013418391.1	7574	g44670	i0	68.4	0.919354838709677	38	12	46	0	246	133	425	462	XP_013418391.1 tetratricopeptide repeat protein 38 isoform X1 [Lingula anatina]	diamond	228	55.5	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
32800231	32800231	PRJNA688736_P_NODE_41240_length_252_cov_0.871508_g40955_i0	PRJNA688736	41240	252	0.871508	2.19620016	Lingula anatina	7574	Brachiopoda	other_Eukaryota	106	8.58e-25	NR	XP_013407887.1	7574	g40955	i0	66.2	0.916666666666667	77	26	91.7	0	251	21	158	234	XP_013407887.1 AP-4 complex subunit mu-1 isoform X1 [Lingula anatina]	diamond	231	106	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
32831885	32831885	PRJNA688736_P_NODE_31180_length_287_cov_1.387850_g30895_i0	PRJNA688736	31180	287	1.38785	3.9831295	Lingula anatina	7574	Brachiopoda	other_Eukaryota	61.6	8.53e-9	NR	XP_013397226.1	7574	g30895	i0	50.9	1.76655052264808	55	26	57.5	1	170	6	33	86	XP_013397226.1 uncharacterized protein LOC106164020 isoform X4 [Lingula anatina]	diamond	507	61.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);;