metadata: contig_metadata: 9 rows where bioproject = "PRJNA1137393", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA1137393", 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
13038395	13038395	PRJNA1137393_P_NODE_20231_length_201_cov_1.868421_g19715_i0	PRJNA1137393	20231	201	1.868421	3.75552621	Sterkiella histriomuscorum	94289	SAR_Eukaryotes	SAR_Eukaryotes	279	7.370000000000001e-71	NTclustered	gi\|220966760\|gb\|FJ545743.1\|	94289	g19715	i0	91.667	38.9054726368159	204	13	100	3	1	201	7323	7121	Sterkiella histriomuscorum 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; macronuclear	blastn	7820	279	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Sterkiella	Sterkiella histriomuscorum
18136367	18136367	PRJNA1137393_P_NODE_14795_length_223_cov_1.390805_g14279_i0	PRJNA1137393	14795	223	1.390805	3.10149515	Colpoda sp.	41631	SAR_Eukaryotes	SAR_Eukaryotes	351	1.74e-92	NTclustered	gi\|2651357788\|gb\|PP174303.1\|	41631	g14279	i0	95.067	99.4932735426009	223	11	100	0	1	223	3369	3591	Colpoda sp. isolate CIL1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	22187	351	1	Eukaryota	Sar	Ciliophora	Colpodea	Colpodida	Colpodidae	Colpoda	Colpoda sp.
19410573	19410573	PRJNA1137393_P_NODE_10636_length_254_cov_4.990244_g10120_i0	PRJNA1137393	10636	254	4.990244	12.67521976	Gonostomum sinicum	1959106	SAR_Eukaryotes	SAR_Eukaryotes	459	1.1599999999999999e-124	NTclustered	gi\|1823934439\|gb\|MT233439.1\|	1959106	g10120	i0	99.213	99.8740157480315	254	2	100	0	1	254	1460	1713	Gonostomum sinicum isolate LX201501050401 large subunit ribosomal RNA gene, partial sequence	blastn	25368	459	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Gonostomatidae	Gonostomum	Gonostomum sinicum
20158501	20158501	PRJNA1137393_P_NODE_3056_length_542_cov_7.405680_g2549_i0	PRJNA1137393	3056	542	7.40568	40.1387856	Urostylida	486728	SAR_Eukaryotes	SAR_Eukaryotes	765	0	NTclustered	gi\|1700451369\|gb\|MN160209.1\|	57509	g2549	i0	92.294	100.749077490775	545	32	100	7	1	542	544	1081	Urostyla grandis strain UK 1 small subunit ribosomal RNA gene, partial sequence	blastn	54606	765	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Urostylida	Urostylidae	Urostyla	Urostyla grandis
20686067	20686067	PRJNA1137393_P_NODE_15377_length_220_cov_1.614035_g14861_i0	PRJNA1137393	15377	220	1.614035	3.550877	uncultured Hypotrichia	305490	SAR_Eukaryotes	SAR_Eukaryotes	379	7.869999999999999e-101	NTclustered	gi\|1859609473\|gb\|MT640783.1\|	305490	g14861	i0	97.727	101	220	5	100	0	1	220	337	118	Uncultured Hypotrichia clone OTU56.10 large subunit ribosomal RNA gene, partial sequence	blastn	22220	379	1	Eukaryota	Sar	Ciliophora	Spirotrichea				uncultured Hypotrichia
24510592	24510592	PRJNA1137393_P_NODE_14600_length_224_cov_1.302857_g14084_i0	PRJNA1137393	14600	224	1.302857	2.91839968	Spirostomum yagiui	1471042	SAR_Eukaryotes	SAR_Eukaryotes	67.6	7.11e-7	NTclustered	gi\|2692944869\|ref\|NC_086648.1\|	1471042	g14084	i0	87.931	0.258928571428571	58	5	25	2	18	74	4949	4893	Spirostomum yagiui isolate XKC mitochondrion, complete genome	blastn	58	67.6	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Spirostomidae	Spirostomum	Spirostomum yagiui
27386636	27386636	PRJNA1137393_P_NODE_24223_length_191_cov_1.330986_g23707_i0	PRJNA1137393	24223	191	1.330986	2.54218326	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	56.2	3.28e-7	NR	CDW72378.1	5949	g23707	i0	56.5	1.44502617801047	46	20	72.3	0	1	138	703	748	CDW72378.1 UNKNOWN [Stylonychia lemnae]	diamond	276	56.2	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
29691028	29691028	PRJNA1137393_P_NODE_54650_length_166_cov_0.888889_g54134_i0	PRJNA1137393	54650	166	0.888889	1.47555574	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	67.4	2.67e-11	NR	XP_001012580.2	312017	g54134	i0	57.4	0.849397590361446	47	20	84.9	0	142	2	465	511	XP_001012580.2 zinc carboxypeptidase family protein [Tetrahymena thermophila SB210]	diamond	141	67.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
30323709	30323709	PRJNA1137393_P_NODE_53352_length_166_cov_0.888889_g52836_i0	PRJNA1137393	53352	166	0.888889	1.47555574	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	57.8	6.59e-8	NR	XP_001014787.2	312017	g52836	i0	53.7	0.975903614457831	54	25	97.6	0	162	1	431	484	XP_001014787.2 HELP domain protein [Tetrahymena thermophila SB210]	diamond	162	57.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila

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