metadata: contig_metadata: 7 rows where bioproject = "PRJNA1102048", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA1102048", 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
20612939	20612939	PRJNA1102048_P_NODE_2117_length_561_cov_2.446721_g2015_i0	PRJNA1102048	2117	561	2.446721	13.72610481	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	216	1.03e-68	NR	XP_013396982.1	7574	g2015	i0	78.3	51	138	30	73.8	0	558	145	9	146	XP_013396982.1 40S ribosomal protein S16 [Lingula anatina]	diamond	28611	218	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
20612942	20612942	PRJNA1102048_P_NODE_2197_length_552_cov_7.645094_g2095_i0	PRJNA1102048	2197	552	7.645094	42.20091888	Opisthokonta	33154	Brachiopoda	other_Eukaryota	197	4.52e-61	NR	XP_013412907.1	7574	g2095	i0	59.4	7.85326086956522	160	60	85.9	2	9	482	1	157	XP_013412907.1 eukaryotic translation initiation factor 5A-1 [Lingula anatina]	diamond	4335	197	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
27193977	27193977	PRJNA1102048_P_NODE_17762_length_241_cov_0.916667_g17658_i0	PRJNA1102048	17762	241	0.916667	2.20916747	Lingula anatina	7574	Brachiopoda	other_Eukaryota	72	1.8e-12	NR	XP_013415893.1	7574	g17658	i0	42.9	0.871369294605809	70	40	87.1	0	223	14	785	854	XP_013415893.1 exosome complex exonuclease RRP44 [Lingula anatina]	diamond	210	72	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
27857279	27857279	PRJNA1102048_P_NODE_12645_length_251_cov_0.865169_g12541_i0	PRJNA1102048	12645	251	0.865169	2.17157419	Lingula anatina	7574	Brachiopoda	other_Eukaryota	141	3.93e-37	NR	XP_013404463.1	7574	g12541	i0	74.7	0.99203187250996006	83	21	99.2	0	1	249	425	507	XP_013404463.1 lysine--tRNA ligase-like isoform X1 [Lingula anatina]	diamond	249	141	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
28511699	28511699	PRJNA1102048_P_NODE_2367_length_536_cov_1.613391_g2264_i0	PRJNA1102048	2367	536	1.613391	8.64777576	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	256	3.05e-81	NR	XP_013383369.1	7574	g2264	i0	70.4	76.6735074626866	169	50	94.6	0	1	507	220	388	XP_013383369.1 actin-related protein 2 [Lingula anatina]	diamond	41097	258	0.992248062015504	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
29269269	29269269	PRJNA1102048_P_NODE_13489_length_249_cov_2.267045_g13385_i0	PRJNA1102048	13489	249	2.267045	5.64494205	Metazoa	33208	Brachiopoda	other_Eukaryota	56.2	6.86e-7	NR	XP_013384439.1	7574	g13385	i0	79.4	10.2409638554217	34	7	41	0	248	147	498	531	XP_013384439.1 T-complex protein 1 subunit zeta [Lingula anatina]	diamond	2550	56.2	1	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
30572941	30572941	PRJNA1102048_P_NODE_2773_length_503_cov_2.595349_g2669_i0	PRJNA1102048	2773	503	2.595349	13.05460547	Lingula anatina	7574	Brachiopoda	other_Eukaryota	92.8	1.28e-18	NR	XP_013408888.1	7574	g2669	i0	37.3	0.94234592445328	158	71	77.5	3	414	25	23	180	XP_013408888.1 uncharacterized protein LOC106172641 [Lingula anatina]	diamond	474	92.8	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);;