metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA744060" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA744060" 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
722875	722875	PRJNA744060_P_NODE_12121_length_460_cov_3.113695_g11793_i0	PRJNA744060	12121	460	3.113695	14.322997	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	327	6.62e-85	NTclustered	gi\|145526872\|ref\|XM_001449205.1\|	5888	g11793	i0	80.516	7.76521739130435	426	83	93	0	2	427	121	546	Paramecium tetraurelia uncharacterized protein (GSPATT00016658001), partial mRNA	blastn	3572	327	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
6302509	6302509	PRJNA744060_P_NODE_10805_length_487_cov_12.898551_g10477_i0	PRJNA744060	10805	487	12.898551	62.81594337	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	453	1.11e-122	NTclustered	gi\|161787\|gb\|M87304.1\|TETHIS31A	5911	g10477	i0	86.506	78.7556468172485	415	52	85	4	34	446	583	171	Tetrahymena thermophila histone H3 (HHT1) gene, complete cds	blastn	38354	453	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
6302533	6302533	PRJNA744060_P_NODE_28145_length_307_cov_3.294872_g27816_i0	PRJNA744060	28145	307	3.294872	10.11525704	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	217	9.6e-52	NTclustered	gi\|10805\|emb\|X52242.1\|	5911	g27816	i0	84.305	13.0456026058632	223	33	72	2	79	300	30	251	T.thermophila mRNA for calmodulin	blastn	4005	217	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
7101710	7101710	PRJNA744060_P_NODE_17166_length_388_cov_3.647619_g16837_i0	PRJNA744060	17166	388	3.647619	14.15276172	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	324	7.11e-84	NTclustered	gi\|161194\|gb\|M76407.1\|SLECALMODU	5949	g16837	i0	83.099	12.9355670103093	355	60	91	0	34	388	608	254	Stylonychia lemnae calmodulin gene, complete cds	blastn	5019	324	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
7576449	7576449	PRJNA744060_P_NODE_6986_length_602_cov_7.948960_g6663_i0	PRJNA744060	6986	602	7.94896	47.8527392	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	699	0	NTclustered	gi\|10790\|emb\|X12767.1\|	5908	g6663	i0	91.228	77.0664451827243	513	45	85	0	90	602	1640	1128	Tetrahymena pyriformis alpha-tubulin gene	blastn	46394	699	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
14752488	14752488	PRJNA744060_P_NODE_4912_length_712_cov_1.640063_g4611_i0	PRJNA744060	4912	712	1.640063	11.67724856	Isotricha intestinalis	47897	SAR_Eukaryotes	SAR_Eukaryotes	529	2.6999999999999993e-145	NTclustered	gi\|92790151\|emb\|AJ965261.1\|	47897	g4611	i0	89.227	169.491573033708	427	41	60	5	287	712	670	248	Isotricha intestinalis partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene)	blastn	120678	529	1	Eukaryota	Sar	Ciliophora	Litostomatea	Vestibuliferida	Isotrichidae	Isotricha	Isotricha intestinalis
16026149	16026149	PRJNA744060_P_NODE_4693_length_728_cov_18.555725_g4393_i0	PRJNA744060	4693	728	18.555725	135.085678	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	610	9.59e-170	NTclustered	gi\|10782\|emb\|X54004.1\|	5908	g4393	i0	82.321	60.853021978022	741	96	100	29	1	728	2179	1461	Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA	blastn	44301	610	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
16026348	16026348	PRJNA744060_P_NODE_7873_length_567_cov_14.882591_g7549_i0	PRJNA744060	7873	567	14.882591	84.38429097	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	246	2.39e-60	NTclustered	gi\|2149885\|gb\|U93852.1\|ECU93852	5936	g7549	i0	83.032	48.3615520282187	277	42	49	4	156	430	1148	875	Euplotes crassus histone H2B (H2B(1)) gene, complete cds	blastn	27421	246	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
16026351	16026351	PRJNA744060_P_NODE_7953_length_564_cov_11.572301_g7628_i0	PRJNA744060	7953	564	11.572301	65.26777764	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	483	1.66e-131	NTclustered	gi\|217404\|dbj\|D10521.1\|TETCALW	5908	g7628	i0	86	75.5478723404255	450	63	80	0	83	532	473	24	Tetrahymena pyriformis mRNA for calmodulin, complete cds	blastn	42609	483	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
19050243	19050243	PRJNA744060_P_NODE_35835_length_276_cov_1.758621_g35506_i0	PRJNA744060	35835	276	1.758621	4.85379396	Oxytrichidae	57506	SAR_Eukaryotes	SAR_Eukaryotes	176	1.44e-39	NTclustered	gi\|331686220\|gb\|HQ432924.1\|	94289	g35506	i0	80.687	33.768115942029	233	39	83	6	4	233	859	630	Sterkiella histriomuscorum strain 310 heat shock protein 70 (hsp70) gene, complete cds; macronuclear	blastn	9320	176	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Sterkiella	Sterkiella histriomuscorum
21125480	21125480	PRJNA744060_P_NODE_1257_length_1255_cov_5.934856_g1101_i0	PRJNA744060	1257	1255	5.934856	74.4824428	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	708	0	NTclustered	gi\|9837417\|gb\|AF287229.1\|	5908	g1101	i0	78.745	66.4454183266932	1068	219	85	8	149	1212	2005	942	Tetrahymena pyriformis heat shock protein 90 (HSP81) gene, partial cds	blastn	83389	708	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
21125835	21125835	PRJNA744060_P_NODE_29777_length_299_cov_4.230088_g29448_i0	PRJNA744060	29777	299	4.230088	12.64796312	uncultured ciliate	187299	SAR_Eukaryotes	SAR_Eukaryotes	536	6.3e-148	NTclustered	gi\|213058599\|gb\|FJ410756.1\|	187299	g29448	i0	98.997	101.130434782609	299	3	100	0	1	299	20	318	Uncultured ciliate clone EBA41.23 18S ribosomal RNA gene, partial sequence	blastn	30238	536	1	Eukaryota	Sar	Ciliophora					uncultured ciliate
21600657	21600657	PRJNA744060_P_NODE_12537_length_452_cov_17.005277_g12209_i0	PRJNA744060	12537	452	17.005277	76.86385204	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	265	5.17e-66	NTclustered	gi\|10816\|emb\|X04755.1\|	5911	g12209	i0	82.838	29.287610619469	303	45	66	4	70	369	354	652	Tetrahymena DNA for histone H4-II	blastn	13238	265	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
23676623	23676623	PRJNA744060_P_NODE_51399_length_242_cov_0.923077_g51070_i0	PRJNA744060	51399	242	0.923077	2.23384634	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	193	1.23e-44	NTclustered	gi\|10160\|emb\|X06874.1\|	5949	g51070	i0	81.07	90.3471074380165	243	44	100	2	1	242	560	319	Stylonychia macronuclear beta-2 tubulin gene	blastn	21864	193	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
25425100	25425100	PRJNA744060_P_NODE_26120_length_318_cov_2.669388_g25791_i0	PRJNA744060	26120	318	2.669388	8.48865384	Tintinnida	200604	SAR_Eukaryotes	SAR_Eukaryotes	459	1.5000000000000002e-124	NTclustered	gi\|23957291\|gb\|AF399167.1\|	1513492	g25791	i0	92.994	99.5345911949686	314	22	99	0	1	314	827	514	Schmidingerella sp. LAK-2008 clone Fehr99atub_3 alpha-tubulin gene, partial cds	blastn	31652	459	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Tintinnida	Rhabdonellidae	Schmidingerella	Schmidingerella sp. LAK-2008

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