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

14 rows where analysis = "blastn", bioproject = "PRJEB75017" 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
135364	135364	PRJEB75017_P_NODE_1781_length_646_cov_10.706806_g1654_i0	PRJEB75017	1781	646	10.706806	69.16596676	Vorticella sp. 4 JG-2011	1295638	SAR_Eukaryotes	SAR_Eukaryotes	1171	0	NTclustered	gi\|512134943\|gb\|JX178902.1\|	1295638	g1654	i0	99.381	93.5046439628483	646	4	100	0	1	646	1648	1003	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	60404	1171	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Vorticellidae	Vorticella	Vorticella sp. 4 JG-2011
135372	135372	PRJEB75017_P_NODE_18241_length_242_cov_1.585799_g18112_i0	PRJEB75017	18241	242	1.585799	3.83763358	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	152	2.0899999999999998e-32	NTclustered	gi\|829181904\|ref\|XM_001020377.3\|	312017	g18112	i0	78.099	1	242	51	99	2	1	241	1450	1210	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	242	152	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
1409973	1409973	PRJEB75017_P_NODE_4902_length_397_cov_1.453704_g4773_i0	PRJEB75017	4902	397	1.453704	5.77120488	Polyplastron multivesiculatum	47894	SAR_Eukaryotes	SAR_Eukaryotes	412	1.5099999999999994e-110	NTclustered	gi\|92790171\|emb\|AJ965271.1\|	47894	g4773	i0	85.39	133.382871536524	397	58	100	0	1	397	7	403	Polyplastron multivesiculatum partial mRNA for Polyubiqutin 2 (polyubiqutin 2 gene)	blastn	52953	412	1	Eukaryota	Sar	Ciliophora	Litostomatea	Entodiniomorphida	Ophryoscolecidae	Polyplastron	Polyplastron multivesiculatum
3961538	3961538	PRJEB75017_P_NODE_7864_length_320_cov_1.319838_g7735_i0	PRJEB75017	7864	320	1.319838	4.2234816	Telotrochidium matiense	455295	SAR_Eukaryotes	SAR_Eukaryotes	272	2.12e-68	NTclustered	gi\|21898545\|gb\|AY101355.1\|	455295	g7735	i0	84.043	21.090625	282	45	88	0	1	282	293	12	Opisthonecta matiensis actin II gene, partial cds	blastn	6749	272	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Opisthonectidae	Telotrochidium	Telotrochidium matiense
7787713	7787713	PRJEB75017_P_NODE_15147_length_250_cov_0.881356_g15018_i0	PRJEB75017	15147	250	0.881356	2.20339	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	412	9.02e-111	NTclustered	gi\|829174084\|ref\|XM_001017488.3\|	312017	g15018	i0	96.4	3.252	250	9	100	0	1	250	30	279	Tetrahymena thermophila SB210 60S ribosomal protein L4 partial mRNA	blastn	813	412	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
9923598	9923598	PRJEB75017_P_NODE_2248_length_581_cov_4.088583_g2120_i0	PRJEB75017	2248	581	4.088583	23.75466723	Vorticella	60849	SAR_Eukaryotes	SAR_Eukaryotes	1074	0	NTclustered	gi\|363412159\|gb\|JN120233.1\|	679523	g2120	i0	100	99.9724612736661	581	0	100	0	1	581	1004	424	Vorticella gracilis isolate 88vorc2fwhfixgz4S1S2 18S ribosomal RNA gene, partial sequence	blastn	58084	1074	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Vorticellidae	Vorticella	Vorticella gracilis
12888986	12888986	PRJEB75017_P_NODE_9651_length_292_cov_1.990868_g9522_i0	PRJEB75017	9651	292	1.990868	5.81333456	Isotricha prostoma	5987	SAR_Eukaryotes	SAR_Eukaryotes	261	4.13e-65	NTclustered	gi\|92790159\|emb\|AJ965265.1\|	5987	g9522	i0	87.281	189.678082191781	228	29	78	0	13	240	436	663	Isotricha prostoma partial mRNA for Polyubiqutin 3 (polyubiqutin 3 gene)	blastn	55386	261	1	Eukaryota	Sar	Ciliophora	Litostomatea	Vestibuliferida	Isotrichidae	Isotricha	Isotricha prostoma
14163789	14163789	PRJEB75017_P_NODE_3252_length_485_cov_1.808252_g3123_i0	PRJEB75017	3252	485	1.808252	8.7700222	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	516	1.39e-141	NTclustered	gi\|217404\|dbj\|D10521.1\|TETCALW	5908	g3123	i0	87.333	78.820618556701	450	57	93	0	27	476	24	473	Tetrahymena pyriformis mRNA for calmodulin, complete cds	blastn	38228	516	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
16712036	16712036	PRJEB75017_P_NODE_16774_length_246_cov_0.901734_g16645_i0	PRJEB75017	16774	246	0.901734	2.21826564	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	327	3.3e-85	NTclustered	gi\|829149595\|ref\|XM_001009414.3\|	312017	g16645	i0	90.984	1.26829268292683	244	21	99	1	1	243	38	281	Tetrahymena thermophila SB210 50S ribosomal protein L1P mRNA	blastn	312	327	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
16712043	16712043	PRJEB75017_P_NODE_18214_length_242_cov_1.846154_g18085_i0	PRJEB75017	18214	242	1.846154	4.46769268	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	261	3.33e-65	NTclustered	gi\|829195582\|ref\|XM_001025656.3\|	312017	g18085	i0	88.785	0.884297520661157	214	22	88	2	30	242	42	254	Tetrahymena thermophila SB210 60S ribosomal protein L14 partial mRNA	blastn	214	261	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
16712079	16712079	PRJEB75017_P_NODE_5054_length_391_cov_1.619497_g4925_i0	PRJEB75017	5054	391	1.619497	6.33223327	Pseudovorticella sp. FG-2015	1607895	SAR_Eukaryotes	SAR_Eukaryotes	551	3.0199999999999986e-152	NTclustered	gi\|759083391\|gb\|KM222020.1\|	1607895	g4925	i0	92.072	99.4245524296675	391	31	100	0	1	391	178	568	Pseudovorticella sp. FG-2015 voucher SZ2010032108 alpha-tubulin gene, partial cds	blastn	38875	551	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Vorticellidae	Pseudovorticella	Pseudovorticella sp. FG-2015
17986933	17986933	PRJEB75017_P_NODE_17235_length_245_cov_0.906977_g17106_i0	PRJEB75017	17235	245	0.906977	2.22209365	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	200	7.46e-47	NTclustered	gi\|9246256\|gb\|AF119380.1\|AF119380	5908	g17106	i0	86.339	0.746938775510204	183	25	75	0	1	183	598	780	Tetrahymena pyriformis epiplasmin C (EPIC) gene, complete cds	blastn	183	200	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
18847295	18847295	PRJEB75017_P_NODE_9475_length_294_cov_3.800905_g9346_i0	PRJEB75017	9475	294	3.800905	11.1746607	Vorticella	60849	SAR_Eukaryotes	SAR_Eukaryotes	542	1.33e-149	NTclustered	gi\|219812771\|gb\|FJ552985.1\|	282477	g9346	i0	100	99.4727891156463	293	0	99	0	1	293	293	1	Uncultured peritrich clone LTSP_EUKA_P1P06 18S ribosomal RNA, 18S-25/28S ribosomal RNA intergenic spacer, partial sequence	blastn	29245	544	0.996323529411765	Eukaryota	Sar	Ciliophora	Oligohymenophorea				uncultured Peritrichia
21812209	21812209	PRJEB75017_P_NODE_8998_length_301_cov_1.657895_g8869_i0	PRJEB75017	8998	301	1.657895	4.99026395	Polyplastron multivesiculatum	47894	SAR_Eukaryotes	SAR_Eukaryotes	344	4.1299999999999985e-90	NTclustered	gi\|92790169\|emb\|AJ965270.1\|	47894	g8869	i0	87.973	175.441860465116	291	35	97	0	3	293	214	504	Polyplastron multivesiculatum partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene)	blastn	52808	344	1	Eukaryota	Sar	Ciliophora	Litostomatea	Entodiniomorphida	Ophryoscolecidae	Polyplastron	Polyplastron multivesiculatum

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