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

5 rows where analysis = "blastn", bioproject = "PRJNA1186363" and tax_phylum = "Ciliophora"

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
5422782	5422782	PRJNA1186363_P_NODE_1885_length_1406_cov_1.943736_g1548_i0	PRJNA1186363	1885	1406	1.943736	27.32892816	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	763	0	NTclustered	gi\|3550265\|gb\|AF079840.1\|AF079840	5963	g1548	i0	97.968	3.88122332859175	443	4	31	4	357	795	1	442	Stentor coeruleus G protein alpha GS-like subunit mRNA, partial cds	blastn	5457	763	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
5422964	5422964	PRJNA1186363_P_NODE_5505_length_906_cov_2.511405_g4816_i0	PRJNA1186363	5505	906	2.511405	22.7533293	Lamtostyla sp. LPJ-2005	331616	SAR_Eukaryotes	SAR_Eukaryotes	726	0	NTclustered	gi\|67462297\|gb\|DQ062090.1\|	331616	g4816	i0	82.277	91.7880794701987	852	140	94	11	3	850	851	7	Lamtostyla sp. LPJ-2005 heta shock protein 70 mRNA, partial cds; macronuclear	blastn	83160	726	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Stichotrichida	Amphisiellidae	Lamtostyla	Lamtostyla sp. LPJ-2005
11798265	11798265	PRJNA1186363_P_NODE_12990_length_561_cov_1.235656_g12107_i0	PRJNA1186363	12990	561	1.235656	6.93203016	Oxytricha sp. LPJ-2005	329142	SAR_Eukaryotes	SAR_Eukaryotes	383	1.7299999999999994e-101	NTclustered	gi\|67462291\|gb\|DQ062087.1\|	329142	g12107	i0	81.316	50.1497326203209	471	88	84	0	91	561	1090	620	Oxytricha sp. LPJ-2005 heat shock protein 70 mRNA, partial cds; macronuclear	blastn	28134	383	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Oxytricha	Oxytricha sp. LPJ-2005
11798509	11798509	PRJNA1186363_P_NODE_7450_length_773_cov_16.184286_g6645_i0	PRJNA1186363	7450	773	16.184286	125.10453078	Lamtostyla sp. LPJ-2005	331616	SAR_Eukaryotes	SAR_Eukaryotes	676	0	NTclustered	gi\|67462297\|gb\|DQ062090.1\|	331616	g6645	i0	84.593	89.6261319534282	688	99	89	7	88	773	6	688	Lamtostyla sp. LPJ-2005 heta shock protein 70 mRNA, partial cds; macronuclear	blastn	69281	676	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Stichotrichida	Amphisiellidae	Lamtostyla	Lamtostyla sp. LPJ-2005
15622582	15622582	PRJNA1186363_P_NODE_40333_length_249_cov_0.886364_g39445_i0	PRJNA1186363	40333	249	0.886364	2.20704636	Euplotes octocarinatus	2716877	SAR_Eukaryotes	SAR_Eukaryotes	326	1.2e-84	NTclustered	gi\|9306\|emb\|X69466.1\|	2716877	g39445	i0	90.65	72.0562248995984	246	21	98	2	3	247	387	143	E.octocarinatus gene for alpha-tubulin	blastn	17942	326	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Euplotes	Euplotes octocarinatus

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