metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA760904" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA760904" 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
742290	742290	PRJNA760904_P_NODE_9501_length_292_cov_1.054795_g9444_i0	PRJNA760904	9501	292	1.054795	3.0800014	Stylonychia mytilus	5950	SAR_Eukaryotes	SAR_Eukaryotes	195	4.25e-45	NTclustered	gi\|8050573\|gb\|AF213664.1\|AF213664	5950	g9444	i0	79.643	0.958904109589041	280	49	95	8	16	291	2235	1960	Stylonychia mytilus elongation factor 2 (EF2) gene, partial cds	blastn	280	195	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia mytilus
8858080	8858080	PRJNA760904_P_NODE_19927_length_242_cov_0.911243_g19870_i0	PRJNA760904	19927	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	213	9.45e-51	NTclustered	gi\|92790175\|emb\|AJ965273.1\|	47894	g19870	i0	83.478	98.8884297520661	230	36	95	2	5	233	301	73	Polyplastron multivesiculatum partial mRNA for Polyubiqutin 4 (polyubiqutin 4 gene)	blastn	23931	215	0.990697674418605	Eukaryota	Sar	Ciliophora	Litostomatea	Entodiniomorphida	Ophryoscolecidae	Polyplastron	Polyplastron multivesiculatum
9670723	9670723	PRJNA760904_P_NODE_9808_length_289_cov_1.277778_g9751_i0	PRJNA760904	9808	289	1.277778	3.69277842	Metopus es	392813	SAR_Eukaryotes	SAR_Eukaryotes	267	8.77e-67	NTclustered	gi\|110645073\|gb\|DQ665935.1\|	392813	g9751	i0	83.333	60.318339100346	288	48	99	0	2	289	473	760	Metopus es clone 1 actin gene, partial cds; macronuclear	blastn	17432	267	1	Eukaryota	Sar	Ciliophora	Armophorea	Metopida	Metopidae	Metopus	Metopus es
11408753	11408753	PRJNA760904_P_NODE_18569_length_244_cov_2.637427_g18512_i0	PRJNA760904	18569	244	2.637427	6.43532188	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	217	7.38e-52	NTclustered	gi\|4107500\|gb\|AF056104.1\|AF056104	35110	g18512	i0	87.047	13.2418032786885	193	23	79	2	12	203	192	1	Spathidium sp. translation elongation factor 1-alpha (TEF1) gene, partial cds	blastn	3231	219	0.990867579908676	Eukaryota	Sar	Ciliophora	Litostomatea	Haptorida	Spathidiidae	Spathidium	Spathidium sp.
12221907	12221907	PRJNA760904_P_NODE_5210_length_374_cov_2.192691_g5153_i0	PRJNA760904	5210	374	2.192691	8.20066434	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	619	7.78e-173	NTclustered	gi\|110645063\|gb\|DQ665311.1\|	151077	g5153	i0	96.524	50.3716577540107	374	13	100	0	1	374	1083	710	Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear	blastn	18839	619	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
16044910	16044910	PRJNA760904_P_NODE_20773_length_241_cov_0.916667_g20716_i0	PRJNA760904	20773	241	0.916667	2.20916747	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	390	4.05e-104	NTclustered	gi\|300676719\|gb\|GQ377693.1\|	151077	g20716	i0	95.851	4.42323651452282	241	10	100	0	1	241	38	278	Chilodonella uncinata gcr5-like mRNA, partial sequence	blastn	1066	390	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
17320523	17320523	PRJNA760904_P_NODE_14454_length_252_cov_1.413408_g14397_i0	PRJNA760904	14454	252	1.413408	3.56178816	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	283	7.44e-72	NTclustered	gi\|10790\|emb\|X12767.1\|	5908	g14397	i0	87.654	43.3055555555556	243	30	96	0	5	247	579	337	Tetrahymena pyriformis alpha-tubulin gene	blastn	10913	283	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
21144817	21144817	PRJNA760904_P_NODE_4037_length_415_cov_27.269006_g3980_i0	PRJNA760904	4037	415	27.269006	113.1663749	Tetrahymena vorax	5919	SAR_Eukaryotes	SAR_Eukaryotes	372	2.6999999999999995e-98	NTclustered	gi\|2209090\|gb\|AF003089.1\|AF003089	5919	g3980	i0	83.979	141.730120481928	387	62	93	0	4	390	495	109	Tetrahymena vorax ubiquitin mRNA, complete cds	blastn	58818	372	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena vorax

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