metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA682774" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA682774" 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
1940648	1940648	PRJNA682774_P_NODE_4242_length_248_cov_1.337143_g4213_i0	PRJNA682774	4242	248	1.337143	3.31611464	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	315	2.59e-81	NTclustered	gi\|829169016\|ref\|XM_001015519.3\|	312017	g4213	i0	95	0.806451612903226	200	10	81	0	1	200	200	1	Tetrahymena thermophila SB210 60S ribosomal protein L26 partial mRNA	blastn	200	315	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
2450005	2450005	PRJNA682774_P_NODE_1402_length_368_cov_2.115254_g1373_i0	PRJNA682774	1402	368	2.115254	7.78413472	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	97.1	1.59e-15	NTclustered	gi\|10824\|emb\|X53988.1\|	5911	g1373	i0	75.576	1.76902173913043	217	42	57	8	105	315	755	544	T.thermophila Icr-A gene for initiation and co-stimulation factor-A	blastn	651	97.1	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
5768272	5768272	PRJNA682774_P_NODE_2365_length_296_cov_1.049327_g2336_i0	PRJNA682774	2365	296	1.049327	3.10600792	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	481	2.96e-131	NTclustered	gi\|10790\|emb\|X12767.1\|	5908	g2336	i0	95.946	99.7263513513514	296	12	100	0	1	296	856	561	Tetrahymena pyriformis alpha-tubulin gene	blastn	29519	481	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
5768279	5768279	PRJNA682774_P_NODE_3025_length_267_cov_1.603093_g2996_i0	PRJNA682774	3025	267	1.603093	4.28025831	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	289	1.71e-73	NTclustered	gi\|829162159\|ref\|XM_001012898.2\|	312017	g2996	i0	88.889	3.36329588014981	234	26	88	0	2	235	19	252	Tetrahymena thermophila SB210 acyl-CoA-binding protein partial mRNA	blastn	898	289	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
5768288	5768288	PRJNA682774_P_NODE_3625_length_252_cov_0.871508_g3596_i0	PRJNA682774	3625	252	0.871508	2.19620016	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	259	1.25e-64	NTclustered	gi\|829191952\|ref\|XM_001023996.3\|	312017	g3596	i0	89.655	12.6150793650794	203	21	81	0	26	228	203	1	Tetrahymena thermophila SB210 protein disulfide-isomerase partial mRNA	blastn	3179	259	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
7043307	7043307	PRJNA682774_P_NODE_3046_length_266_cov_1.616580_g3017_i0	PRJNA682774	3046	266	1.61658	4.3001028	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	292	1.32e-74	NTclustered	gi\|829144883\|ref\|XM_001009836.3\|	312017	g3017	i0	89.868	0.853383458646617	227	23	85	0	1	227	227	1	Tetrahymena thermophila SB210 40S ribosomal protein S12 partial mRNA	blastn	227	292	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
7043311	7043311	PRJNA682774_P_NODE_3266_length_258_cov_1.264865_g3237_i0	PRJNA682774	3266	258	1.264865	3.2633517	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	254	6e-63	NTclustered	gi\|829191934\|ref\|XM_001023979.4\|	312017	g3237	i0	84.47	1.02325581395349	264	34	100	5	1	258	450	188	Tetrahymena thermophila SB210 60S acidic ribosomal protein partial mRNA	blastn	264	254	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
8317799	8317799	PRJNA682774_P_NODE_2867_length_274_cov_1.805970_g2838_i0	PRJNA682774	2867	274	1.80597	4.9483578	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	172	1.85e-38	NTclustered	gi\|229593638\|ref\|XM_001027526.3\|	312017	g2838	i0	79.435	0.905109489051095	248	47	90	4	2	247	805	1050	Tetrahymena thermophila SB210 Ndc1 protein partial mRNA	blastn	248	172	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
13418603	13418603	PRJNA682774_P_NODE_1971_length_320_cov_1.263158_g1942_i0	PRJNA682774	1971	320	1.263158	4.0421056	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	399	9.3e-107	NTclustered	gi\|829192652\|ref\|XM_001030092.3\|	312017	g1942	i0	91.986	0.896875	287	19	89	3	1	285	285	1	Tetrahymena thermophila SB210 40S ribosomal protein S8-2 partial mRNA	blastn	287	399	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
13418606	13418606	PRJNA682774_P_NODE_2291_length_300_cov_1.374449_g2262_i0	PRJNA682774	2291	300	1.374449	4.123347	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	544	3.78e-150	NTclustered	gi\|10782\|emb\|X54004.1\|	5908	g2262	i0	99.333	89.79	300	2	100	0	1	300	1610	1909	Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA	blastn	26937	544	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
15967361	15967361	PRJNA682774_P_NODE_2993_length_268_cov_1.600000_g2964_i0	PRJNA682774	2993	268	1.6	4.288	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	139	1.83e-28	NTclustered	gi\|118348431\|ref\|XM_001007691.1\|	312017	g2964	i0	77.729	0.854477611940298	229	49	85	2	3	230	1760	1533	Tetrahymena thermophila SB210 Na,H/K antiporter P-type ATPase alpha subunit family protein partial mRNA	blastn	229	139	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
15967374	15967374	PRJNA682774_P_NODE_3933_length_250_cov_0.881356_g3904_i0	PRJNA682774	3933	250	0.881356	2.20339	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	113	1.02e-20	NTclustered	gi\|829184305\|ref\|XM_001021590.2\|	312017	g3904	i0	78.652	0.712	178	33	70	5	20	195	4341	4167	Tetrahymena thermophila SB210 tubulin-tyrosine ligase family protein partial mRNA	blastn	178	113	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
17242587	17242587	PRJNA682774_P_NODE_3714_length_252_cov_0.871508_g3685_i0	PRJNA682774	3714	252	0.871508	2.19620016	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	289	1.6e-73	NTclustered	gi\|829189813\|ref\|XM_001023402.3\|	312017	g3685	i0	87.302	1.98412698412698	252	32	100	0	1	252	70	321	Tetrahymena thermophila SB210 ADP-ribosylation factor(Arf)/Arf-like (Arl) small GTPase family protein partial mRNA	blastn	500	289	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
23617539	23617539	PRJNA682774_P_NODE_3259_length_258_cov_1.556757_g3230_i0	PRJNA682774	3259	258	1.556757	4.01643306	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	355	1.6e-93	NTclustered	gi\|829174408\|ref\|XM_012797985.1\|	312017	g3230	i0	91.765	0.988372093023256	255	21	99	0	2	256	94	348	Tetrahymena thermophila SB210 60S ribosomal protein L17 partial mRNA	blastn	255	355	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
24890817	24890817	PRJNA682774_P_NODE_4420_length_247_cov_0.896552_g4391_i0	PRJNA682774	4420	247	0.896552	2.21448344	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	355	1.52e-93	NTclustered	gi\|829199477\|ref\|XM_001027976.3\|	312017	g4391	i0	92.683	1.5587044534413	246	18	99	0	2	247	660	415	Tetrahymena thermophila SB210 60S ribosomal protein L3, putative partial mRNA	blastn	385	355	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
24890835	24890835	PRJNA682774_P_NODE_640_length_543_cov_1.119149_g611_i0	PRJNA682774	640	543	1.119149	6.07697907	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	723	0	NTclustered	gi\|829143268\|ref\|XM_001009807.3\|	312017	g611	i0	93.802	6.71270718232044	484	25	89	4	1	483	274	753	Tetrahymena thermophila SB210 tyrosine 3-monooxygenase/tryptophan 5-monooxygenase activation protein, epsilon protein partial mRNA	blastn	3645	723	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila

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