metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJEB75230" and tax

7 rows where analysis = "blastn", bioproject = "PRJEB75230" 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
1411445	1411445	PRJEB75230_P_NODE_19422_length_387_cov_1.464968_g19240_i0	PRJEB75230	19422	387	1.464968	5.66942616	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	649	0	NTclustered	gi\|110645063\|gb\|DQ665311.1\|	151077	g19240	i0	96.899	29.5555555555556	387	12	100	0	1	387	867	481	Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear	blastn	11438	649	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
3962111	3962111	PRJEB75230_P_NODE_119444_length_251_cov_0.865169_g119262_i0	PRJEB75230	119444	251	0.865169	2.17157419	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	158	4.69e-34	NTclustered	gi\|2386243051\|ref\|XM_001445424.2\|	5888	g119262	i0	78.367	0.97609561752988	245	51	97	2	1	244	285	42	Paramecium tetraurelia uncharacterized protein (GSPATT00013511001), mRNA	blastn	245	158	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
14164222	14164222	PRJEB75230_P_NODE_111012_length_255_cov_1.692308_g110830_i0	PRJEB75230	111012	255	1.692308	4.3153854	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	115	2.91e-21	NTclustered	gi\|829192014\|ref\|XM_012799966.1\|	312017	g110830	i0	88.421	1.65490196078431	95	11	37	0	114	208	219	125	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	422	115	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
16298599	16298599	PRJEB75230_P_NODE_171853_length_242_cov_1.822485_g171671_i0	PRJEB75230	171853	242	1.822485	4.4104137	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	448	2.3799999999999995e-121	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g171671	i0	100	9.85950413223141	242	0	100	0	1	242	1830	1589	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	2386	448	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
21398256	21398256	PRJEB75230_P_NODE_38617_length_330_cov_2.377432_g38435_i0	PRJEB75230	38617	330	2.377432	7.8455256	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	508	1.53e-139	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g38435	i0	94.545	81.9454545454546	330	16	99	2	1	329	1990	2318	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	27042	508	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
21812603	21812603	PRJEB75230_P_NODE_109898_length_256_cov_1.398907_g109716_i0	PRJEB75230	109898	256	1.398907	3.58120192	Dasytricha ruminantium	40806	SAR_Eukaryotes	SAR_Eukaryotes	303	5.82e-78	NTclustered	gi\|92790147\|emb\|AJ965259.1\|	40806	g109716	i0	88.71	189.60546875	248	28	97	0	1	248	650	403	Dasytricha ruminantium partial mRNA for Polyubiqutin 3 (polyubiqutin 3 gene)	blastn	48539	303	1	Eukaryota	Sar	Ciliophora	Litostomatea	Vestibuliferida	Isotrichidae	Dasytricha	Dasytricha ruminantium
24363746	24363746	PRJEB75230_P_NODE_8960_length_489_cov_1.250000_g8778_i0	PRJEB75230	8960	489	1.25	6.1125	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	599	1.36e-166	NTclustered	gi\|300676719\|gb\|GQ377693.1\|	151077	g8778	i0	88.753	1	489	55	100	0	1	489	581	93	Chilodonella uncinata gcr5-like mRNA, partial sequence	blastn	489	599	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);;