metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA915212" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA915212" and tax_phylum = "Apicomplexa"

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
895036	895036	PRJNA915212_P_NODE_12161_length_166_cov_1.290598_g12123_i0	PRJNA915212	12161	166	1.290598	2.14239268	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.014	NTclustered	gi\|1085160940\|ref\|XM_018779832.1\|	508771	g12123	i0	100	0.168674698795181	28	0	17	0	66	93	2226	2199	Toxoplasma gondii ME49 zinc finger, zz type domain-containing protein mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
7629135	7629135	PRJNA915212_P_NODE_8026_length_206_cov_0.974522_g7988_i0	PRJNA915212	8026	206	0.974522	2.00751532	root	1	Root_unresolved	Root_unresolved	65.8	2.31e-6	NTclustered	gi\|237833922\|ref\|XM_002366218.1\|	508771	g7988	i0	93.182	5.67961165048544	44	3	21	0	127	170	7459	7502	Toxoplasma gondii ME49 STE kinase partial mRNA	blastn	1170	65.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
8903864	8903864	PRJNA915212_P_NODE_12307_length_166_cov_0.871795_g12269_i0	PRJNA915212	12307	166	0.871795	1.4471797	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.001	NTclustered	gi\|1027958808\|ref\|XM_735943.2\|	31271	g12269	i0	100	4.70481927710843	30	0	18	0	25	54	234	205	Plasmodium chabaudi chabaudi casein kinase II beta chain, putative (PCHAS_1360100), partial mRNA	blastn	781	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium chabaudi
12374307	12374307	PRJNA915212_P_NODE_4750_length_276_cov_1.057269_g4712_i0	PRJNA915212	4750	276	1.057269	2.91806244	Plasmodium gaboni	647221	SAR_Eukaryotes	SAR_Eukaryotes	165	3.12e-36	NTclustered	gi\|1084839774\|ref\|XM_018785426.1\|	647221	g4712	i0	78.715	62.7173913043478	249	51	90	2	18	265	464	711	Plasmodium gaboni heat shock protein 70 partial mRNA	blastn	17310	165	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
24202610	24202610	PRJNA915212_P_NODE_13299_length_164_cov_0.886957_g13261_i0	PRJNA915212	13299	164	0.886957	1.45460948	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.014	NTclustered	gi\|2785758497\|ref\|XM_067219731.1\|	5824	g13261	i0	100	0.51219512195122	28	0	17	0	20	47	1005	1032	Plasmodium brasilianum uncharacterized protein (MKS88_001076), partial mRNA	blastn	84	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium brasilianum

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