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

5 rows where analysis = "blastn", bioproject = "PRJNA1061474" 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
7830352	7830352	PRJNA1061474_P_NODE_14147_length_545_cov_0.788136_g13903_i0	PRJNA1061474	14147	545	0.788136	4.2953412	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	784	0	NTclustered	gi\|300676719\|gb\|GQ377693.1\|	151077	g13903	i0	92.791	10.6788990825688	541	39	99	0	5	545	558	18	Chilodonella uncinata gcr5-like mRNA, partial sequence	blastn	5820	784	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
9939825	9939825	PRJNA1061474_P_NODE_41848_length_269_cov_1.964286_g41602_i0	PRJNA1061474	41848	269	1.964286	5.28392934	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	337	6.069999999999998e-88	NTclustered	gi\|21215206\|gb\|AF510205.1\|	5947	g41602	i0	89.513	95.9739776951673	267	27	99	1	1	267	1274	1009	Oxytricha granulifera beta-tubulin gene, complete cds	blastn	25817	337	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Oxytricha	Oxytricha granulifera
14207234	14207234	PRJNA1061474_P_NODE_37592_length_293_cov_0.900000_g37346_i0	PRJNA1061474	37592	293	0.9	2.637	Opisthonecta henneguyi	6026	SAR_Eukaryotes	SAR_Eukaryotes	267	8.909999999999999e-67	NTclustered	gi\|4063597\|gb\|AF056109.1\|	6026	g37346	i0	85.714	74.4232081911263	252	36	86	0	42	293	1	252	Telotrochidium henneguyii translation elongation factor 1-alpha (TEF1) gene, partial cds	blastn	21806	267	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Opisthonectidae	Opisthonecta	Opisthonecta henneguyi
15481232	15481232	PRJNA1061474_P_NODE_33533_length_316_cov_1.502058_g33287_i0	PRJNA1061474	33533	316	1.502058	4.74650328	Opisthonecta henneguyi	6026	SAR_Eukaryotes	SAR_Eukaryotes	333	9.439999999999998e-87	NTclustered	gi\|21429687\|gb\|AY101352.1\|	6026	g33287	i0	86.084	97.1867088607595	309	43	98	0	8	316	994	686	Opisthonecta henneguyi alpha-tubulin gene, partial cds	blastn	30711	333	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Opisthonectidae	Opisthonecta	Opisthonecta henneguyi
21855426	21855426	PRJNA1061474_P_NODE_38838_length_286_cov_1.244131_g38592_i0	PRJNA1061474	38838	286	1.244131	3.55821466	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	451	2.23e-122	NTclustered	gi\|110645063\|gb\|DQ665311.1\|	151077	g38592	i0	98.438	95.8321678321678	256	4	90	0	1	256	256	1	Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear	blastn	27408	451	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata

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