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

9 rows where analysis = "blastn", bioproject = "PRJNA438111" 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
2366326	2366326	PRJNA438111_P_NODE_9722_length_327_cov_3.942953_g9102_i0	PRJNA438111	9722	327	3.942953	12.89345631	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	195	4.83e-45	NTclustered	gi\|1510132\|dbj\|D86573.1\|	5833	g9102	i0	84.08	16.394495412844	201	32	61	0	4	204	765	565	Plasmodium falciparum gene for flavoprotein subunit of succinate dehydrogenase, complete cds	blastn	5361	195	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
8087199	8087199	PRJNA438111_P_NODE_25327_length_216_cov_6.935829_g24702_i0	PRJNA438111	25327	216	6.935829	14.98139064	Plasmodium gallinaceum	5849	SAR_Eukaryotes	SAR_Eukaryotes	172	1.4e-38	NTclustered	gi\|1620122260\|ref\|XM_028671860.1\|	5849	g24702	i0	85.455	11.6666666666667	165	24	76	0	7	171	718	882	Plasmodium gallinaceum serine/threonine protein phosphatase PP1, putative (PGAL8A_00286000), partial mRNA	blastn	2520	172	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
10018572	10018572	PRJNA438111_P_NODE_17648_length_252_cov_12.385650_g17023_i0	PRJNA438111	17648	252	12.38565	31.211838	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	117	7.99e-22	NTclustered	gi\|1960721530\|gb\|MW521827.1\|	2805721	g17023	i0	94.667	31.0357142857143	75	4	30	0	3	77	5062	4988	Stramenopiles sp. MAST-3A-sp1 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	7821	117	1	Eukaryota	Sar						Stramenopiles sp. MAST-3A-sp1
11293594	11293594	PRJNA438111_P_NODE_17209_length_255_cov_6.039823_g16584_i0	PRJNA438111	17209	255	6.039823	15.40154865	Poteriospumella	1117026	SAR_Eukaryotes	SAR_Eukaryotes	416	7.129999999999998e-112	NTclustered	gi\|685431582\|gb\|KF697341.1\|	1117027	g16584	i0	97.917	59.4078431372549	240	5	94	0	16	255	243	4	Poteriospumella lacustris strain JBC07 28S ribosomal RNA gene, partial sequence	blastn	15149	416	1	Eukaryota	Sar		Chrysophyceae	Chromulinales	Dinobryaceae	Poteriospumella	Poteriospumella lacustris
18285735	18285735	PRJNA438111_P_NODE_3615_length_515_cov_135.339506_g3102_i0	PRJNA438111	3615	515	135.339506	696.9984559	Plasmodium sp. gorilla clade G2	880535	SAR_Eukaryotes	SAR_Eukaryotes	320	1.25e-82	NTclustered	gi\|1620166031\|ref\|XM_028680891.1\|	880535	g3102	i0	81.265	30.4504854368932	411	63	78	12	112	515	411	8	Plasmodium sp. gorilla clade G2 histone H3 variant, putative (PADL01_0615900), partial mRNA	blastn	15682	320	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium sp. gorilla clade G2
19560161	19560161	PRJNA438111_P_NODE_47916_length_184_cov_2.477419_g47291_i0	PRJNA438111	47916	184	2.477419	4.55845096	Plasmodium malariae	5858	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.004	NTclustered	gi\|379988059\|dbj\|AB649418.1\|	5858	g47291	i0	96.875	0.173913043478261	32	1	17	0	103	134	2336	2367	Plasmodium malariae apicoplast DNA, partial sequence, strain: Kisii67	blastn	32	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae
22110953	22110953	PRJNA438111_P_NODE_53118_length_178_cov_3.510067_g52493_i0	PRJNA438111	53118	178	3.510067	6.24791926	Plasmodium berghei	5821	SAR_Eukaryotes	SAR_Eukaryotes	104	4.1e-18	NTclustered	gi\|1843576031\|ref\|XM_034568020.1\|	5823	g52493	i0	81.203	12.3426966292135	133	22	74	3	6	136	606	475	Plasmodium berghei ANKA vacuolar protein sorting-associated protein 26, putative (PBANKA_1463200), partial mRNA	blastn	2197	104	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
23386444	23386444	PRJNA438111_P_NODE_48019_length_184_cov_1.832258_g47394_i0	PRJNA438111	48019	184	1.832258	3.37135472	Plasmodium berghei	5821	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.016	NTclustered	gi\|1843573176\|ref\|XM_034566437.1\|	5823	g47394	i0	100	0.152173913043478	28	0	15	0	29	56	2212	2185	Plasmodium berghei ANKA conserved Plasmodium protein, unknown function (PBANKA_1235700), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
24660533	24660533	PRJNA438111_P_NODE_49000_length_182_cov_8.915033_g48375_i0	PRJNA438111	49000	182	8.915033	16.22536006	Spumella-like flagellate JBNZ41	293189	SAR_Eukaryotes	SAR_Eukaryotes	292	8.38e-75	NTclustered	gi\|161015620\|gb\|EF577220.1\|	293189	g48375	i0	98.78	98	164	2	90	0	1	164	953	1116	Spumella-like flagellate JBNZ41 alpha-tubulin gene, partial cds	blastn	17836	292	1	Eukaryota	Sar		Chrysophyceae				Spumella-like flagellate JBNZ41

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