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

29 rows where analysis = "blastn", bioproject = "PRJNA682774" and tax_clade = "Sar"

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
664628	664628	PRJNA682774_P_NODE_1721_length_339_cov_1.759398_g1692_i0	PRJNA682774	1721	339	1.759398	5.96435922	uncultured Cercozoa	175275	SAR_Eukaryotes	SAR_Eukaryotes	604	1.9599999999999993e-168	NTclustered	gi\|512134091\|gb\|KC575315.1\|	175275	g1692	i0	98.82	100.330383480826	339	4	100	0	1	339	373	35	Uncultured cercozoan clone A.3.2 18S ribosomal RNA gene, partial sequence	blastn	34012	604	1	Eukaryota	Sar	Cercozoa					uncultured Cercozoa
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
4492575	4492575	PRJNA682774_P_NODE_2504_length_289_cov_2.166667_g2475_i0	PRJNA682774	2504	289	2.166667	6.26166763	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	180	1.18e-40	NTclustered	gi\|669159439\|ref\|XM_008617060.1\|	1156394	g2475	i0	78.246	48.9031141868512	285	58	98	4	4	286	451	169	Saprolegnia diclina VS20 60S ribosomal protein mRNA	blastn	14133	180	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
4492617	4492617	PRJNA682774_P_NODE_744_length_499_cov_1.718310_g715_i0	PRJNA682774	744	499	1.71831	8.5743669	Poterioochromonas malhamensis	88167	SAR_Eukaryotes	SAR_Eukaryotes	920	0	NTclustered	gi\|323690576\|gb\|GU935635.1\|	88167	g715	i0	100	73.4048096192385	498	0	99	0	2	499	2013	1516	Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence	blastn	36629	920	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae	Poterioochromonas	Poterioochromonas malhamensis
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
7043308	7043308	PRJNA682774_P_NODE_306_length_782_cov_2.165021_g281_i0	PRJNA682774	306	782	2.165021	16.93046422	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	640	1.32e-178	NTclustered	gi\|219111198\|ref\|XM_002177315.1\|	556484	g281	i0	81.596	66.2340153452685	777	140	99	3	6	780	1570	795	Phaeodactylum tricornutum CCAP 1055/1 protein heat shock protein Hsp70 (HSP70A), mRNA	blastn	51795	640	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
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
7552597	7552597	PRJNA682774_P_NODE_1506_length_358_cov_1.659649_g1477_i0	PRJNA682774	1506	358	1.659649	5.94154342	root	1	Root_unresolved	Root_unresolved	183	1.15e-41	NTclustered	gi\|677286256\|gb\|KF997849.1\|	2605704	g1477	i0	80.08	37.804469273743	251	46	70	4	2	250	837	589	Colpodella edax translation elongation factor 1-alpha (EF1A) mRNA, complete cds	blastn	13534	183	1	Eukaryota	Sar				Alphamonaceae	Alphamonas	Alphamonas edax
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
10868668	10868668	PRJNA682774_P_NODE_989_length_434_cov_1.639889_g960_i0	PRJNA682774	989	434	1.639889	7.11711826	Stramenopile sp. ex Nuclearia delicatula CCAP1552/1	289359	SAR_Eukaryotes	SAR_Eukaryotes	797	0	NTclustered	gi\|53829555\|gb\|AY582830.1\|	289359	g960	i0	99.77	33.6635944700461	434	1	100	0	1	434	778	1211	Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds	blastn	14610	797	1	Eukaryota	Sar						Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
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
15203378	15203378	PRJNA682774_P_NODE_1612_length_348_cov_1.661818_g1583_i0	PRJNA682774	1612	348	1.661818	5.78312664	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	638	1.99e-178	NTclustered	gi\|1134785030\|gb\|KX575709.1\|	3003	g1583	i0	99.713	100	348	1	100	0	1	348	696	1043	Bacillaria paxillifer isolate RVSN23 18S ribosomal RNA gene, partial sequence	blastn	34800	643	0.992223950233281	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Bacillaria	Bacillaria paxillifer
15967353	15967353	PRJNA682774_P_NODE_2213_length_304_cov_2.008658_g2184_i0	PRJNA682774	2213	304	2.008658	6.10632032	Actinosphaerium nucleofilum	238767	SAR_Eukaryotes	SAR_Eukaryotes	220	7.34e-53	NTclustered	gi\|33089895\|gb\|AY283757.1\|	238767	g2184	i0	79.933	95.3256578947368	299	60	98	0	6	304	391	689	Actinosphaerium nucleofilum isolate Anu4_3 actin gene, partial cds	blastn	28979	220	1	Eukaryota	Sar		Actinophryidae			Actinosphaerium	Actinosphaerium nucleofilum
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
17242572	17242572	PRJNA682774_P_NODE_2394_length_294_cov_3.208145_g2365_i0	PRJNA682774	2394	294	3.208145	9.4319463	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	377	3.96e-100	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g2365	i0	90.559	97.2925170068027	286	25	97	2	1	285	1191	1475	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	28604	377	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
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
17242615	17242615	PRJNA682774_P_NODE_5154_length_243_cov_0.917647_g5125_i0	PRJNA682774	5154	243	0.917647	2.22988221	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	246	9.36e-61	NTclustered	gi\|813170664\|ref\|XM_012348698.1\|	695850	g5125	i0	85.062	96.8395061728395	241	36	99	0	2	242	410	170	Saprolegnia parasitica CBS 223.65 tubulin alpha chain mRNA	blastn	23532	246	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
18516729	18516729	PRJNA682774_P_NODE_2315_length_299_cov_1.172566_g2286_i0	PRJNA682774	2315	299	1.172566	3.50597234	Nitzschia reversa	2675857	SAR_Eukaryotes	SAR_Eukaryotes	525	1.3599999999999994e-144	NTclustered	gi\|2862228864\|gb\|PQ645498.1\|	2675857	g2286	i0	98.328	96.9364548494983	299	5	100	0	1	299	3903	3605	Nitzschia reversa isolate AGSB0348 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	28984	525	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia reversa
22852163	22852163	PRJNA682774_P_NODE_5178_length_243_cov_0.917647_g5149_i0	PRJNA682774	5178	243	0.917647	2.22988221	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	213	9.49e-51	NTclustered	gi\|156986897\|gb\|EU080062.1\|	4788	g5149	i0	83.122	97.0452674897119	237	36	97	2	9	243	1707	1473	Phytophthora megasperma isolate PD_00017(P3136) heat shock protein 90 (HSP90) gene, partial cds	blastn	23582	213	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora megasperma
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
24890788	24890788	PRJNA682774_P_NODE_2500_length_289_cov_3.226852_g2471_i0	PRJNA682774	2500	289	3.226852	9.32560228	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	305	1.86e-78	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g2471	i0	86.159	33.8477508650519	289	33	99	6	3	289	4009	3726	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	9782	305	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
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);;