metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJEB12237" and tax

4 rows where analysis = "blastn", bioproject = "PRJEB12237" 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
20709	20709	PRJEB12237_P_NODE_7101_length_212_cov_2.175141_g6905_i0	PRJEB12237	7101	212	2.175141	4.61129892	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	58.4	4.01e-4	NTclustered	gi\|915125688\|ref\|XM_013478654.1\|	5804	g6905	i0	100	2.64622641509434	31	0	15	0	61	91	565	535	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	561	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
5123031	5123031	PRJEB12237_P_NODE_10945_length_160_cov_0.952000_g10749_i0	PRJEB12237	10945	160	0.952	1.5232	Nephromyces sp. ex Molgula occidentalis	2544991	SAR_Eukaryotes	SAR_Eukaryotes	62.1	2.2e-5	NTclustered	gi\|1735073328\|gb\|MK573206.1\|	2544991	g10749	i0	97.297	1.65625	37	0	23	1	2	38	29789	29824	Nephromyces sp. ex Molgula occidentalis isolate 656 apicoplast, complete genome	blastn	265	62.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Nephromyces	Nephromyces sp. ex Molgula occidentalis
5123092	5123092	PRJEB12237_P_NODE_7765_length_199_cov_1.463415_g7569_i0	PRJEB12237	7765	199	1.463415	2.91219585	Plasmodium chabaudi	5825	SAR_Eukaryotes	SAR_Eukaryotes	69.4	1.71e-7	NTclustered	gi\|1027955205\|ref\|XM_730772.2\|	31271	g7569	i0	100	15.1708542713568	37	0	19	0	91	127	13327	13363	Plasmodium chabaudi chabaudi HECT-like E3 ubiquitin ligase, putative (PCHAS_0933500), partial mRNA	blastn	3019	69.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium chabaudi
22972692	22972692	PRJEB12237_P_NODE_8699_length_184_cov_2.986577_g8503_i0	PRJEB12237	8699	184	2.986577	5.49530168	Gregarina sp. Phaedon/Daegwallyeong/2010	1049247	SAR_Eukaryotes	SAR_Eukaryotes	268	1.43e-67	NTclustered	gi\|339715944\|gb\|JF412715.1\|	1049247	g8503	i0	92.935	96.3804347826087	184	13	100	0	1	184	4507	4324	Gregarina sp. Phaedon/Daegwallyeong/2010 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and 28S-18S intergenic spacer, partial sequence	blastn	17734	268	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina sp. Phaedon/Daegwallyeong/2010

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