metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1242190" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1242190" 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
5454315	5454315	PRJNA1242190_S_NODE_11905_length_252_cov_1.748603_g11898_i0	PRJNA1242190	11905	252	1.748603	4.40647956	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	363	9.289999999999996e-96	NTclustered	gi\|347439271\|gb\|JN111984.1\|	151077	g11898	i0	97.63	82.6984126984127	211	5	100	0	42	252	702	912	Chilodonella uncinata strain USA_SC2 clone SP1 beta tubulin (btub) gene, partial cds; macronuclear	blastn	20840	363	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
6153823	6153823	PRJNA1242190_S_NODE_7465_length_311_cov_0.882353_g7458_i0	PRJNA1242190	7465	311	0.882353	2.74411783	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	394	4.189999999999999e-105	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g7458	i0	91.126	86.8006430868167	293	23	94	2	1	293	1946	1657	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	26995	394	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
7428905	7428905	PRJNA1242190_S_NODE_3226_length_435_cov_5.784530_g3219_i0	PRJNA1242190	3226	435	5.78453	25.1627055	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	545	1.5799999999999996e-150	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g3219	i0	96.375	29.6689655172414	331	12	83	0	29	359	32	362	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	12906	545	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
8004148	8004148	PRJNA1242190_S_NODE_13067_length_245_cov_2.848837_g13060_i0	PRJNA1242190	13067	245	2.848837	6.97965065	Sterkiella histriomuscorum	94289	SAR_Eukaryotes	SAR_Eukaryotes	176	1.26e-39	NTclustered	gi\|47176465\|gb\|AY618045.1\|	94289	g13060	i0	93.966	46.4775510204082	116	7	47	0	1	116	537	422	Sterkiella histriomuscorum clone UGC1O0002_L19_F genomic sequence	blastn	11387	176	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Sterkiella	Sterkiella histriomuscorum
8703938	8703938	PRJNA1242190_S_NODE_7027_length_318_cov_5.608163_g7020_i0	PRJNA1242190	7027	318	5.608163	17.83395834	Sterkiella	94288	SAR_Eukaryotes	SAR_Eukaryotes	169	2.8399999999999997e-37	NTclustered	gi\|331686195\|gb\|HQ432921.1\|	94289	g7020	i0	78.309	65.7169811320755	272	51	84	8	20	287	1205	1472	Sterkiella histriomuscorum strain BA elongation factor-1 (ef-1) gene, complete cds; macronuclear	blastn	20898	169	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Sterkiella	Sterkiella histriomuscorum
10555008	10555008	PRJNA1242190_S_NODE_3689_length_414_cov_3.938416_g3682_i0	PRJNA1242190	3689	414	3.938416	16.30504224	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	737	0	NTclustered	gi\|300676714\|gb\|GQ377691.1\|	151077	g3682	i0	99.029	51.6594202898551	412	3	99	1	4	414	450	39	Chilodonella uncinata rps22a (rps22a) mRNA, complete cds	blastn	21387	737	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
13104753	13104753	PRJNA1242190_S_NODE_13591_length_242_cov_3.597633_g13584_i0	PRJNA1242190	13591	242	3.597633	8.70627186	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	364	2.4699999999999992e-96	NTclustered	gi\|301014695\|gb\|GQ377692.1\|	151077	g13584	i0	93.548	1.02479338842975	248	10	100	2	1	242	499	252	Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence	blastn	248	364	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
13804460	13804460	PRJNA1242190_S_NODE_4011_length_400_cov_5.009174_g4004_i0	PRJNA1242190	4011	400	5.009174	20.036696	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	246	1.64e-60	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g4004	i0	94.375	6.2025	160	9	40	0	1	160	2923	3082	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	2481	246	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
15653843	15653843	PRJNA1242190_S_NODE_11713_length_253_cov_9.638889_g11706_i0	PRJNA1242190	11713	253	9.638889	24.38638917	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	233	7.64e-57	NTclustered	gi\|33327399\|gb\|AF527985.1\|	151077	g11706	i0	97.778	69.9920948616601	135	3	53	0	119	253	1	135	Chilodonella uncinata clone 5 histone H4 (H4) gene, partial cds	blastn	17708	233	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
16928114	16928114	PRJNA1242190_S_NODE_3874_length_406_cov_4.432432_g3867_i0	PRJNA1242190	3874	406	4.432432	17.99567392	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	612	1.4299999999999996e-170	NTclustered	gi\|300676719\|gb\|GQ377693.1\|	151077	g3867	i0	95.55	16.4211822660099	382	17	94	0	25	406	699	318	Chilodonella uncinata gcr5-like mRNA, partial sequence	blastn	6667	612	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
20752364	20752364	PRJNA1242190_S_NODE_11217_length_258_cov_3.140541_g11210_i0	PRJNA1242190	11217	258	3.140541	8.10259578	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	394	3.39e-105	NTclustered	gi\|110644972\|gb\|DQ665918.1\|	151077	g11210	i0	94.51	94.922480620155	255	14	99	0	1	255	386	640	Chilodonella uncinata clone 1 beta-tubulin gene, partial cds	blastn	24490	394	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
20752368	20752368	PRJNA1242190_S_NODE_1137_length_581_cov_6.525591_g1130_i0	PRJNA1242190	1137	581	6.525591	37.91368371	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	763	0	NTclustered	gi\|110645063\|gb\|DQ665311.1\|	151077	g1130	i0	97.327	40.0636833046472	449	12	77	0	133	581	1205	757	Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear	blastn	23277	763	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
23303340	23303340	PRJNA1242190_S_NODE_7939_length_302_cov_6.406114_g7932_i0	PRJNA1242190	7939	302	6.406114	19.34646428	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	115	3.5400000000000006e-21	NTclustered	gi\|829192014\|ref\|XM_012799966.1\|	312017	g7932	i0	88.421	1.39072847682119	95	11	31	0	161	255	219	125	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	420	115	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
24577202	24577202	PRJNA1242190_S_NODE_3280_length_432_cov_3.286908_g3273_i0	PRJNA1242190	3280	432	3.286908	14.19944256	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	366	1.3099999999999999e-96	NTclustered	gi\|300676719\|gb\|GQ377693.1\|	151077	g3273	i0	90.842	7.16898148148148	273	25	63	0	160	432	539	267	Chilodonella uncinata gcr5-like mRNA, partial sequence	blastn	3097	366	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata

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