metadata: contig_metadata: 8 rows where bioproject = "PRJNA1005695", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA1005695", tax_clade = "Sar" and tax_phylum = "Ciliophora"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
8654212	8654212	PRJNA1005695_P_NODE_21147_length_327_cov_2.586614_g20295_i0	PRJNA1005695	21147	327	2.586614	8.45822778	Helicoprorodontidae	1607782	SAR_Eukaryotes	SAR_Eukaryotes	137	8.25e-28	NTclustered	gi\|375305434\|gb\|JF975394.1\|	652932	g20295	i0	90.385	37.5474006116208	104	10	32	0	131	234	309	206	Trachelotractus entzi isolate LWW07033111 28S ribosomal RNA gene, partial sequence	blastn	12278	137	1	Eukaryota	Sar	Ciliophora	Litostomatea	Haptorida		Trachelotractus	Trachelotractus entzi
14182129	14182129	PRJNA1005695_P_NODE_19232_length_344_cov_2.490775_g18380_i0	PRJNA1005695	19232	344	2.490775	8.568266	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.033	NTclustered	gi\|471220273\|ref\|XM_004025160.1\|	5932	g18380	i0	100	0.0813953488372093	28	0	8	0	181	208	263	236	Ichthyophthirius multifiliis ubiquitin- hect domain protein, putative (IMG5_189580) mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
20127558	20127558	PRJNA1005695_P_NODE_26636_length_290_cov_1.433180_g25784_i0	PRJNA1005695	26636	290	1.43318	4.156222	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	472	1.74e-128	NTclustered	gi\|10782\|emb\|X54004.1\|	5908	g25784	i0	96.194	58.4689655172414	289	9	99	2	2	289	2968	3255	Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA	blastn	16956	472	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
27595895	27595895	PRJNA1005695_P_NODE_13824_length_411_cov_2.186391_g12972_i0	PRJNA1005695	13824	411	2.186391	8.98606701	Ciliophora	5878	SAR_Eukaryotes	SAR_Eukaryotes	159	1.21e-46	NR	CDW89718.1	5949	g12972	i0	55.9	13.8978102189781	136	60	99.3	0	411	4	32	167	CDW89718.1 60s ribosomal protein l16 [Stylonychia lemnae]	diamond	5712	159	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
29869112	29869112	PRJNA1005695_P_NODE_29691_length_274_cov_1.552239_g28839_i0	PRJNA1005695	29691	274	1.552239	4.25313486	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	54.7	3.13e-6	NR	AAR04353.1	5911	g28839	i0	30.9	6.43795620437956	81	52	85.4	2	251	18	73	152	AAR04353.1 putative MAPK [Tetrahymena thermophila]	diamond	1764	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
30880068	30880068	PRJNA1005695_P_NODE_8914_length_523_cov_1.706667_g8067_i0	PRJNA1005695	8914	523	1.706667	8.92586841	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	124	7.379999999999999e-31	NR	CAG9325519.1	1481888	g8067	i0	43	1.60611854684512	172	78	98.7	3	517	2	74	225	CAG9325519.1 unnamed protein product [Blepharisma stoltei]	diamond	840	125	0.992	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
32752798	32752798	PRJNA1005695_P_NODE_41160_length_233_cov_2.862500_g40308_i0	PRJNA1005695	41160	233	2.8625	6.669625	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	47	7.47e-4	NR	OMJ83359.1	5963	g40308	i0	33.9	1.55793991416309	59	39	76	0	14	190	73	131	OMJ83359.1 hypothetical protein SteCoe_15763 [Stentor coeruleus]	diamond	363	47	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
32902629	32902629	PRJNA1005695_P_NODE_29660_length_274_cov_1.995025_g28808_i0	PRJNA1005695	29660	274	1.995025	5.4663685	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	83.2	5.33e-18	NR	CAI2382075.1	5936	g28808	i0	68.8	2.12408759124088	64	18	67.9	1	189	4	1	64	CAI2382075.1 unnamed protein product [Moneuplotes crassus]	diamond	582	83.2	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus

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