metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA675042" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA675042" 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
1923466	1923466	PRJNA675042_P_NODE_72262_length_290_cov_1.267281_g71812_i0	PRJNA675042	72262	290	1.267281	3.6751149	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.027	NTclustered	gi\|829143869\|ref\|XM_001009683.2\|	312017	g71812	i0	100	0.096551724137931	28	0	10	0	185	212	3280	3307	Tetrahymena thermophila SB210 50S ribosome-binding GTPase partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
3197096	3197096	PRJNA675042_P_NODE_143363_length_246_cov_0.890173_g142913_i0	PRJNA675042	143363	246	0.890173	2.18982558	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|2386239791\|ref\|XM_001443154.2\|	5888	g142913	i0	100	0.113821138211382	28	0	11	0	16	43	4550	4577	Paramecium tetraurelia uncharacterized protein (GSPATT00011394001), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
8299252	8299252	PRJNA675042_P_NODE_119547_length_249_cov_0.909091_g119097_i0	PRJNA675042	119547	249	0.909091	2.26363659	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.006	NTclustered	gi\|829154569\|ref\|XM_001011058.2\|	312017	g119097	i0	100	0.116465863453815	29	0	12	0	208	236	212	240	Tetrahymena thermophila SB210 MFS transporter, putative partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
9575814	9575814	PRJNA675042_P_NODE_61208_length_306_cov_1.008584_g60758_i0	PRJNA675042	61208	306	1.008584	3.08626704	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	62.1	4.74e-5	NTclustered	gi\|829195140\|ref\|XM_012800393.1\|	312017	g60758	i0	97.297	0.120915032679739	37	0	12	1	47	82	579	543	Tetrahymena thermophila SB210 transmembrane protein, putative partial mRNA	blastn	37	62.1	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
10850191	10850191	PRJNA675042_P_NODE_139869_length_246_cov_1.676301_g139419_i0	PRJNA675042	139869	246	1.676301	4.12370046	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|145499776\|ref\|XM_001435836.1\|	5888	g139419	i0	100	0.121951219512195	30	0	12	0	46	75	5069	5040	Paramecium tetraurelia uncharacterized protein (GSPATT00037261001), partial mRNA	blastn	30	56.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
12125226	12125226	PRJNA675042_P_NODE_11710_length_478_cov_1.140741_g11261_i0	PRJNA675042	11710	478	1.140741	5.45274198	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.013	NTclustered	gi\|829100739\|ref\|XM_001007752.2\|	312017	g11261	i0	96.875	0.0669456066945607	32	1	7	0	320	351	331	300	Tetrahymena thermophila SB210 myotubularin-related protein partial mRNA	blastn	32	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
12126311	12126311	PRJNA675042_P_NODE_45110_length_333_cov_1.184615_g44660_i0	PRJNA675042	45110	333	1.184615	3.94476795	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.031	NTclustered	gi\|829177015\|ref\|XM_001018661.2\|	312017	g44660	i0	88.372	0.129129129129129	43	5	13	0	71	113	871	913	Tetrahymena thermophila SB210 transmembrane protein, putative partial mRNA	blastn	43	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
17224737	17224737	PRJNA675042_P_NODE_21194_length_407_cov_0.979042_g20744_i0	PRJNA675042	21194	407	0.979042	3.98470094	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.011	NTclustered	gi\|829139579\|ref\|XM_001009190.2\|	312017	g20744	i0	94.444	0.0884520884520884	36	1	9	1	92	127	4119	4153	Tetrahymena thermophila SB210 bowman-birk serine protease inhibitor family protein partial mRNA	blastn	36	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
22845771	22845771	PRJNA675042_P_NODE_70498_length_292_cov_6.009132_g70048_i0	PRJNA675042	70498	292	6.009132	17.54666544	Colpoda	5979	SAR_Eukaryotes	SAR_Eukaryotes	529	1.0299999999999996e-145	NTclustered	gi\|1802599795\|gb\|MT001204.1\|	41631	g70048	i0	99.315	99.9897260273973	292	2	100	0	1	292	890	599	Colpoda sp. strain HFCC836 small subunit ribosomal RNA gene, partial sequence	blastn	29197	534	0.99063670411985	Eukaryota	Sar	Ciliophora	Colpodea	Colpodida	Colpodidae	Colpoda	Colpoda sp.

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