metadata: contig_metadata: 6 rows where bioproject = "PRJNA664479" and tax

6 rows where bioproject = "PRJNA664479" 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
10833276	10833276	PRJNA664479_S_NODE_16229_length_164_cov_1.773913_g16153_i0	PRJNA664479	16229	164	1.773913	2.90921732	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	104	3.73e-18	NTclustered	gi\|829196136\|ref\|XM_001025866.3\|	312017	g16153	i0	91.892	0.451219512195122	74	6	45	0	91	164	510	437	Tetrahymena thermophila SB210 translationally-controlled tumor-like protein partial mRNA	blastn	74	104	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
12108493	12108493	PRJNA664479_S_NODE_7970_length_202_cov_1.235294_g7894_i0	PRJNA664479	7970	202	1.235294	2.49529388	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	248	2.09e-61	NTclustered	gi\|829194717\|ref\|XM_001025217.3\|	312017	g7894	i0	88.78	1.01485148514851	205	20	100	1	1	202	349	553	Tetrahymena thermophila SB210 ubiquitin-40S ribosomal protein S27a partial mRNA	blastn	205	248	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
28186655	28186655	PRJNA664479_S_NODE_16406_length_164_cov_0.886957_g16330_i0	PRJNA664479	16406	164	0.886957	1.45460948	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	101	8.14e-26	NR	XP_001025062.2	312017	g16330	i0	88.9	0.98780487804878	54	6	98.8	0	163	2	52	105	XP_001025062.2 40S ribosomal protein S24 [Tetrahymena thermophila SB210]	diamond	162	101	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
28344718	28344718	PRJNA664479_S_NODE_14226_length_167_cov_1.296610_g14150_i0	PRJNA664479	14226	167	1.29661	2.1653387	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	97.8	4.13e-24	NR	XP_004030146.1	5932	g14150	i0	88.9	0.970059880239521	54	6	97	0	165	4	109	162	XP_004030146.1 hypothetical protein IMG5_167040 [Ichthyophthirius multifiliis]	diamond	162	97.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
28502647	28502647	PRJNA664479_S_NODE_14547_length_167_cov_0.864407_g14471_i0	PRJNA664479	14547	167	0.864407	1.44355969	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	99.4	2.0199999999999998e-24	NR	XP_001019693.2	312017	g14471	i0	92.2	0.916167664670659	51	4	91.6	0	153	1	1	51	XP_001019693.2 60S ribosomal protein L6 [Tetrahymena thermophila SB210]	diamond	153	99.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
29733755	29733755	PRJNA664479_S_NODE_4630_length_244_cov_2.666667_g4554_i0	PRJNA664479	4630	244	2.666667	6.50666748	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	48.1	4.78e-4	NR	CAI2387805.1	5936	g4554	i0	37	1.77049180327869	73	46	89.8	0	220	2	261	333	CAI2387805.1 unnamed protein product [Moneuplotes crassus]	diamond	432	48.1	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);;