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

5 rows where analysis = "blastn", bioproject = "PRJNA635874" 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
608157	608157	PRJNA635874_P_NODE_67261_length_243_cov_0.905882_g67114_i0	PRJNA635874	67261	243	0.905882	2.20129326	Plasmodium reichenowi	5854	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|1145263318\|ref\|XM_012909888.2\|	5854	g67114	i0	94.444	0.148148148148148	36	2	15	0	101	136	1574	1539	Plasmodium reichenowi diphthamide synthesis protein, putative partial mRNA	blastn	36	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
3158817	3158817	PRJNA635874_P_NODE_563_length_1331_cov_20.831479_g493_i0	PRJNA635874	563	1331	20.831479	277.26698549	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	1062	0	NTclustered	gi\|1624698158\|ref\|XM_029013947.1\|	189622	g493	i0	81.067	266.195341848234	1331	252	100	0	1	1331	1907	577	Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA	blastn	354306	1062	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
4435638	4435638	PRJNA635874_P_NODE_564_length_1331_cov_19.365660_g493_i1	PRJNA635874	564	1331	19.36566	257.7569346	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	1068	0	NTclustered	gi\|1624698158\|ref\|XM_029013947.1\|	189622	g493	i1	81.142	272.407212622089	1331	251	100	0	1	1331	577	1907	Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA	blastn	362574	1068	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
9536885	9536885	PRJNA635874_P_NODE_848_length_1163_cov_15.953211_g493_i2	PRJNA635874	848	1163	15.953211	185.53584393	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	867	0	NTclustered	gi\|1624698158\|ref\|XM_029013947.1\|	189622	g493	i2	80.189	274.663800515907	1161	227	99	3	5	1163	748	1907	Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA	blastn	319434	867	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
15909881	15909881	PRJNA635874_P_NODE_23813_length_330_cov_1.198444_g23666_i0	PRJNA635874	23813	330	1.198444	3.9548652	Plasmodium gaboni	647221	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.031	NTclustered	gi\|1084813209\|ref\|XM_018784818.1\|	647221	g23666	i0	100	0.0848484848484849	28	0	8	0	158	185	1644	1671	Plasmodium gaboni putative tyrosine kinase-like protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni

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