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

9 rows where analysis = "blastn", bioproject = "PRJNA793147" 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
4606563	4606563	PRJNA793147_P_NODE_56844_length_230_cov_0.894410_g56578_i0	PRJNA793147	56844	230	0.89441	2.057143	Symbiodinium kawagutii	104179	SAR_Eukaryotes	SAR_Eukaryotes	158	4.23e-34	NTclustered	gi\|512780726\|gb\|KC937348.1\|	104179	g56578	i0	79.31	1.29130434782609	232	42	99	5	1	229	475	703	Symbiodinium kawagutii strain CCMP2468 clone SymkaSLLR3-277, partial sequence	blastn	297	158	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium kawagutii
5044026	5044026	PRJNA793147_P_NODE_27104_length_320_cov_1.147410_g26838_i0	PRJNA793147	27104	320	1.14741	3.671712	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	65.8	3.85e-6	NTclustered	gi\|2785767768\|ref\|XM_067219082.1\|	5824	g26838	i0	97.368	7.834375	38	1	12	0	28	65	14517	14554	Plasmodium brasilianum uncharacterized protein (MKS88_005788), partial mRNA	blastn	2507	65.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium brasilianum
9706448	9706448	PRJNA793147_P_NODE_57768_length_229_cov_1.393750_g57502_i0	PRJNA793147	57768	229	1.39375	3.1916875	Symbiodinium sp. ex Tridacna maxima MM-2013	1300008	SAR_Eukaryotes	SAR_Eukaryotes	156	1.51e-33	NTclustered	gi\|516324015\|gb\|JX465539.1\|	1300008	g57502	i0	79.372	12.9912663755459	223	44	97	2	1	222	229	8	Symbiodinium sp. ex Tridacna maxima MM-2013 clone 12h/RUB/1 ribulose 1,5-bisphosphate carboxylase oxygenase large subunit mRNA, partial cds	blastn	2975	156	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium sp. ex Tridacna maxima MM-2013
14806500	14806500	PRJNA793147_P_NODE_43892_length_254_cov_1.945946_g43626_i0	PRJNA793147	43892	254	1.945946	4.94270284	Poteriospumella sp.	2003111	SAR_Eukaryotes	SAR_Eukaryotes	470	5.37e-128	NTclustered	gi\|1209404931\|gb\|KX442736.1\|	2003111	g43626	i0	100	80.1377952755905	254	0	100	0	1	254	1126	1379	Poteriospumella sp. strain JBAS36 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	20355	470	1	Eukaryota	Sar		Chrysophyceae	Chromulinales	Dinobryaceae	Poteriospumella	Poteriospumella sp.
21180683	21180683	PRJNA793147_P_NODE_55957_length_231_cov_0.888889_g55691_i0	PRJNA793147	55957	231	0.888889	2.05333359	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.021	NTclustered	gi\|145490735\|ref\|XM_001431331.1\|	5888	g55691	i0	100	0.121212121212121	28	0	12	0	204	231	885	912	Paramecium tetraurelia uncharacterized protein (GSPATT00033823001), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
23730539	23730539	PRJNA793147_P_NODE_31359_length_299_cov_1.252174_g31093_i0	PRJNA793147	31359	299	1.252174	3.74400026	Yihiella yeosuensis	1744892	SAR_Eukaryotes	SAR_Eukaryotes	396	1.11e-105	NTclustered	gi\|2303466649\|gb\|OM453930.1\|	1744892	g31093	i0	94.208	87.247491638796	259	15	100	0	1	259	246	504	Yihiella yeosuensis strain YYYS1405 cytochrome c oxidase subunit 1 (cox1) gene, partial cds; mitochondrial	blastn	26087	396	1	Eukaryota	Sar		Dinophyceae	Suessiales	Suessiaceae	Yihiella	Yihiella yeosuensis
23730644	23730644	PRJNA793147_P_NODE_37539_length_274_cov_2.107317_g37273_i0	PRJNA793147	37539	274	2.107317	5.77404858	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.025	NTclustered	gi\|2795627486\|ref\|XM_068067773.1\|	483139	g37273	i0	100	0.102189781021898	28	0	10	0	123	150	4330	4357	Cystoisospora suis dynamin-related protein drpa (CSUI_007628), mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
24167429	24167429	PRJNA793147_P_NODE_24159_length_339_cov_1.003704_g23893_i0	PRJNA793147	24159	339	1.003704	3.40255656	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.032	NTclustered	gi\|1084801553\|ref\|XM_018784548.1\|	647221	g23893	i0	100	0.176991150442478	28	0	8	0	212	239	1108	1081	Plasmodium gaboni hypothetical protein partial mRNA	blastn	60	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
25004751	25004751	PRJNA793147_P_NODE_7980_length_625_cov_3.658273_g7723_i0	PRJNA793147	7980	625	3.658273	22.86420625	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.017	NTclustered	gi\|829186935\|ref\|XM_001022570.3\|	312017	g7723	i0	100	0.0464	29	0	5	0	196	224	1636	1608	Tetrahymena thermophila SB210 Serine/Threonine kinase domain protein partial mRNA	blastn	29	54.7	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);;