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

5 rows where analysis = "blastn", bioproject = "PRJNA1139127" 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
4111990	4111990	PRJNA1139127_P_NODE_13984_length_546_cov_1.564482_g13503_i0	PRJNA1139127	13984	546	1.564482	8.54207172	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	662	0	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g13503	i0	89.655	1.5952380952381	522	50	95	3	1	520	1531	1012	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	871	662	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
13785624	13785624	PRJNA1139127_P_NODE_26251_length_351_cov_1.111511_g25759_i0	PRJNA1139127	26251	351	1.111511	3.90140361	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.98e-4	NTclustered	gi\|915002776\|ref\|XM_013393443.1\|	5801	g25759	i0	94.872	9.49287749287749	39	1	11	1	286	323	11084	11046	Eimeria acervulina UBA/TS-N domain-containing protein, putative partial mRNA	blastn	3332	60.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
15060003	15060003	PRJNA1139127_P_NODE_43732_length_250_cov_0.875706_g43239_i0	PRJNA1139127	43732	250	0.875706	2.189265	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	451	1.91e-122	NTclustered	gi\|1837628855\|gb\|MN158348.1\|	5909	g43239	i0	99.2	92.464	250	2	100	0	1	250	2607	2856	Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	23116	451	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena rostrata
15588214	15588214	PRJNA1139127_P_NODE_47213_length_245_cov_0.889535_g46720_i0	PRJNA1139127	47213	245	0.889535	2.17936075	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	355	1.51e-93	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g46720	i0	93.004	42.8	243	17	99	0	3	245	116359	116601	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	10486	355	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
18137056	18137056	PRJNA1139127_P_NODE_46555_length_245_cov_2.482558_g46062_i0	PRJNA1139127	46555	245	2.482558	6.0822671	Synura synuroidea	47573	SAR_Eukaryotes	SAR_Eukaryotes	189	1.62e-43	NTclustered	gi\|11466457\|ref\|NC_002174.1\|	47573	g46062	i0	82.87	21.9632653061224	216	32	87	5	22	235	815	1027	Chrysodidymus synuroideus mitochondrion, complete genome	blastn	5381	189	1	Eukaryota	Sar		Synurophyceae	Synurales	Mallomonadaceae	Synura	Synura synuroidea

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