metadata: contig_metadata: 7 rows where bioproject = "PRJNA1008624", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA1008624", 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
6532070	6532070	PRJNA1008624_P_NODE_12566_length_236_cov_1.620321_g12378_i0	PRJNA1008624	12566	236	1.620321	3.82395756	Trithigmostoma cucullulus	1346499	SAR_Eukaryotes	SAR_Eukaryotes	274	4.15e-69	NTclustered	gi\|759083539\|gb\|KM222156.1\|	1346499	g12378	i0	89.593	74.1652542372881	221	15	92	6	12	228	112	328	Trithigmostoma cucullulus voucher CXM08110902 large subunit ribosomal RNA gene, partial sequence	blastn	17503	274	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Trithigmostoma	Trithigmostoma cucullulus
10357223	10357223	PRJNA1008624_P_NODE_18289_length_199_cov_2.253333_g18101_i0	PRJNA1008624	18289	199	2.253333	4.48413267	Vorticella sp. 4 JG-2011	1295638	SAR_Eukaryotes	SAR_Eukaryotes	357	3.2699999999999996e-94	NTclustered	gi\|512134943\|gb\|JX178902.1\|	1295638	g18101	i0	99.49	98.5879396984925	196	1	98	0	1	196	1376	1181	Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	19619	357	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Vorticellidae	Vorticella	Vorticella sp. 4 JG-2011
27223979	27223979	PRJNA1008624_P_NODE_35443_length_163_cov_0.912281_g35255_i0	PRJNA1008624	35443	163	0.912281	1.48701803	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	73.9	8.12e-14	NR	CAG9328584.1	1481888	g35255	i0	72.1	0.791411042944785	43	12	79.1	0	161	33	158	200	CAG9328584.1 unnamed protein product [Blepharisma stoltei]	diamond	129	73.9	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
28487382	28487382	PRJNA1008624_P_NODE_28847_length_168_cov_0.873950_g28659_i0	PRJNA1008624	28847	168	0.87395	1.468236	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	106	5.66e-25	NR	OMJ68454.1	5963	g28659	i0	92.6	0.964285714285714	54	4	96.4	0	6	167	3117	3170	OMJ68454.1 hypothetical protein SteCoe_34092 [Stentor coeruleus]	diamond	162	106	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
30887584	30887584	PRJNA1008624_P_NODE_32294_length_165_cov_0.896552_g32106_i0	PRJNA1008624	32294	165	0.896552	1.4793108	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	50.4	2.42e-5	NR	CAI2360389.1	5936	g32106	i0	92.3	0.472727272727273	26	2	47.3	0	86	163	293	318	CAI2360389.1 unnamed protein product [Moneuplotes crassus]	diamond	78	50.4	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
32215911	32215911	PRJNA1008624_P_NODE_28498_length_168_cov_0.873950_g28310_i0	PRJNA1008624	28498	168	0.87395	1.468236	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	41.2	0.046	NR	CDW74479.1	5949	g28310	i0	54.8	0.553571428571429	31	14	55.4	0	115	23	216	246	CDW74479.1 UNKNOWN [Stylonychia lemnae]	diamond	93	41.2	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
32342621	32342621	PRJNA1008624_P_NODE_28519_length_168_cov_0.873950_g28331_i0	PRJNA1008624	28519	168	0.87395	1.468236	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	64.3	3.39e-10	NR	CAI2384268.1	5936	g28331	i0	58.3	0.857142857142857	48	20	85.7	0	10	153	534	581	CAI2384268.1 unnamed protein product [Moneuplotes crassus]	diamond	144	64.3	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);;