metadata: contig_metadata: 14 rows where bioproject = "PRJNA1247234" and tax

14 rows where bioproject = "PRJNA1247234" 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
351153	351153	PRJNA1247234_P_NODE_13841_length_300_cov_1.374449_g13685_i0	PRJNA1247234	13841	300	1.374449	4.123347	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	521	1.7699999999999996e-143	NTclustered	gi\|325194684\|emb\|FR825494.1\|	890382	g13685	i0	98	76.9933333333333	300	6	100	0	1	300	94	393	Albugo laibachii Nc14, genomic contig CONTIG_2365_NC14_v4_847_33331	blastn	23098	521	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
4178671	4178671	PRJNA1247234_P_NODE_22264_length_250_cov_0.881356_g22108_i0	PRJNA1247234	22264	250	0.881356	2.20339	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|345894117\|ref\|NC_015981.1\|	5932	g22108	i0	100	0.112	28	0	11	0	195	222	25570	25597	Ichthyophthirius multifiliis mitochondrion, complete genome	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
10555544	10555544	PRJNA1247234_P_NODE_2249_length_637_cov_2.895390_g2103_i0	PRJNA1247234	2249	637	2.89539	18.4436343	Opercularia sp. ZhW-2019a	2582953	SAR_Eukaryotes	SAR_Eukaryotes	1051	0	NTclustered	gi\|2304601486\|gb\|OP458307.1\|	2582953	g2103	i0	97.115	87.4897959183673	624	16	98	2	15	637	1	623	Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence	blastn	55731	1051	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Operculariidae	Opercularia	Opercularia sp. ZhW-2019a
18203146	18203146	PRJNA1247234_P_NODE_20895_length_252_cov_0.871508_g20739_i0	PRJNA1247234	20895	252	0.871508	2.19620016	Phytophthora sansomeana	555429	SAR_Eukaryotes	SAR_Eukaryotes	368	2e-97	NTclustered	gi\|1770692515\|ref\|NC_045089.1\|	555429	g20739	i0	93.548	99.1150793650794	248	15	98	1	4	250	187	434	Phytophthora sansomeana mitochondrion, complete genome	blastn	24977	368	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sansomeana
20753165	20753165	PRJNA1247234_P_NODE_7517_length_383_cov_1.006452_g7361_i0	PRJNA1247234	7517	383	1.006452	3.85471116	Rosculus sp.	2231160	SAR_Eukaryotes	SAR_Eukaryotes	708	0	NTclustered	gi\|1402550473\|gb\|MH488759.1\|	2231160	g7361	i0	100	3.16187989556136	383	0	100	0	1	383	452	70	Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence	blastn	1211	708	1	Eukaryota	Sar	Cercozoa			Guttulinopsidae	Rosculus	Rosculus sp.
21453573	21453573	PRJNA1247234_P_NODE_24357_length_247_cov_0.896552_g24201_i0	PRJNA1247234	24357	247	0.896552	2.21448344	Glissomonadida	1238681	SAR_Eukaryotes	SAR_Eukaryotes	455	1.4600000000000002e-123	NTclustered	gi\|2030163897\|gb\|MZ044034.1\|	1808984	g24201	i0	100	19.7773279352227	246	0	99	0	1	246	756	511	Rosculus terrestris isolate S14D1 small subunit ribosomal RNA gene, partial sequence	blastn	4885	455	1	Eukaryota	Sar	Cercozoa			Guttulinopsidae	Rosculus	Rosculus terrestris
22028053	22028053	PRJNA1247234_P_NODE_15238_length_288_cov_1.595349_g15082_i0	PRJNA1247234	15238	288	1.595349	4.59460512	Synura truttae	1285454	SAR_Eukaryotes	SAR_Eukaryotes	333	8.5e-87	NTclustered	gi\|859809655\|gb\|KM590756.1\|	1285454	g15082	i0	89.961	133.03125	259	24	90	2	31	288	2217	1960	Synura truttae strain Hanjeong080611J 23S ribosomal RNA gene, partial sequence; plastid	blastn	38313	333	1	Eukaryota	Sar		Synurophyceae	Synurales	Mallomonadaceae	Synura	Synura truttae
23303601	23303601	PRJNA1247234_P_NODE_10559_length_335_cov_1.095420_g10403_i0	PRJNA1247234	10559	335	1.09542	3.669657	Hyaloperonospora parasitica	123356	SAR_Eukaryotes	SAR_Eukaryotes	614	3.209999999999999e-171	NTclustered	gi\|33520224\|gb\|AY273969.1\|	123356	g10403	i0	99.701	100.002985074627	335	1	100	0	1	335	208	542	Hyaloperonospora parasitica large subunit ribosomal RNA gene, partial sequence	blastn	33501	614	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora parasitica
27863194	27863194	PRJNA1247234_P_NODE_18985_length_260_cov_1.668449_g18829_i0	PRJNA1247234	18985	260	1.668449	4.3379674	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	75.9	1.12e-15	NR	XP_004031317.1	5932	g18829	i0	47.4	0.876923076923077	76	40	87.7	0	241	14	21	96	XP_004031317.1 hypothetical protein IMG5_142740, partial [Ichthyophthirius multifiliis]	diamond	228	75.9	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
27894745	27894745	PRJNA1247234_P_NODE_27245_length_243_cov_0.917647_g27089_i0	PRJNA1247234	27245	243	0.917647	2.22988221	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	87	1.17e-18	NR	XP_004036924.1	5932	g27089	i0	49.4	0.975308641975309	79	40	97.5	0	1	237	45	123	XP_004036924.1 proteasome subunit alpha type 3, putative [Ichthyophthirius multifiliis]	diamond	237	87	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
28178763	28178763	PRJNA1247234_P_NODE_27646_length_242_cov_0.923077_g27490_i0	PRJNA1247234	27646	242	0.923077	2.23384634	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	87.4	2.63e-18	NR	KRX02208.1	266149	g27490	i0	52.5	0.991735537190083	80	38	99.2	0	3	242	5	84	KRX02208.1 hypothetical protein PPERSA_04830 [Pseudocohnilembus persalinus]	diamond	240	87.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
28684357	28684357	PRJNA1247234_P_NODE_15147_length_289_cov_1.097222_g14991_i0	PRJNA1247234	15147	289	1.097222	3.17097158	Paramecium sonneborni	65129	SAR_Eukaryotes	SAR_Eukaryotes	58.2	2.51e-7	NR	CAD8118289.1	65129	g14991	i0	39.7	1.51557093425606	73	43	74.7	1	218	3	3144	3216	CAD8118289.1 unnamed protein product [Paramecium sonneborni]	diamond	438	58.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
28891527	28891527	PRJNA1247234_P_NODE_27068_length_243_cov_0.917647_g26912_i0	PRJNA1247234	27068	243	0.917647	2.22988221	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	57	3.53e-7	NR	KAL4440863.1	5901	g26912	i0	42.6	2	54	31	66.7	0	3	164	388	441	KAL4440863.1 hypothetical protein ABPG74_013844 [Tetrahymena malaccensis]	diamond	486	57	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
30863396	30863396	PRJNA1247234_P_NODE_12634_length_311_cov_3.184874_g12478_i0	PRJNA1247234	12634	311	3.184874	9.90495814	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	113	2.2399999999999993e-28	NR	XP_001018798.2	312017	g12478	i0	54.4	1.98713826366559	103	46	98.4	1	1	306	43	145	XP_001018798.2 glutathione S-transferase, amine-terminal domain protein [Tetrahymena thermophila SB210]	diamond	618	113	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);;