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

7 rows where analysis = "blastn", bioproject = "PRJNA971676" 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
1266295	1266295	PRJNA971676_P_NODE_10961_length_277_cov_1.132353_g10872_i0	PRJNA971676	10961	277	1.132353	3.13661781	Oligohymenophorea	6020	SAR_Eukaryotes	SAR_Eukaryotes	379	1.03e-100	NTclustered	gi\|74829873\|emb\|CR932119.1\|	5888	g10872	i0	91.336	97.0397111913357	277	24	100	0	1	277	5195	4919	Paramecium tetraurelia macronuclear, alpha-tubulin-related protein gene	blastn	26880	379	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
2220129	2220129	PRJNA971676_P_NODE_5782_length_350_cov_1.667870_g5693_i0	PRJNA971676	5782	350	1.66787	5.837545	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	460	4.64e-125	NTclustered	gi\|5701724\|dbj\|AB024694.1\|	5908	g5693	i0	90.251	2.40857142857143	359	25	99	6	1	349	360	2	Tetrahymena pyriformis mRNA for 14-3-3 protein, complete cds	blastn	843	460	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
7644422	7644422	PRJNA971676_P_NODE_14826_length_250_cov_0.870056_g14737_i0	PRJNA971676	14826	250	0.870056	2.17514	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	329	9.34e-86	NTclustered	gi\|10812\|emb\|X05543.1\|	5911	g14737	i0	91.02	5.848	245	20	98	2	6	249	304	547	Tetrahymena thermophila gene for histone H2B-1 from macronucleus	blastn	1462	329	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
8597480	8597480	PRJNA971676_P_NODE_13267_length_255_cov_2.010989_g13178_i0	PRJNA971676	13267	255	2.010989	5.12802195	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	333	7.3899999999999995e-87	NTclustered	gi\|829157134\|ref\|XM_001011598.2\|	312017	g13178	i0	90.196	1	255	25	100	0	1	255	590	844	Tetrahymena thermophila SB210 60S ribosomal protein L5 partial mRNA	blastn	255	333	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
8919415	8919415	PRJNA971676_P_NODE_7367_length_322_cov_1.236948_g7278_i0	PRJNA971676	7367	322	1.236948	3.98297256	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	512	1.1499999999999998e-140	NTclustered	gi\|10935\|emb\|X56693.1\|	5908	g7278	i0	95.342	145.130434782609	322	15	100	0	1	322	645	324	Tetrahymena pyriformis TUF11 gene for ubiquitin-ribosomal protein fusion protein	blastn	46732	516	0.992248062015504	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
8919442	8919442	PRJNA971676_P_NODE_9467_length_292_cov_1.141553_g9378_i0	PRJNA971676	9467	292	1.141553	3.33333476	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	390	5.049999999999999e-104	NTclustered	gi\|161789\|gb\|M87504.1\|TETHIS32A	5911	g9378	i0	93.511	35.8801369863014	262	17	90	0	4	265	471	210	Tetrahymena thermophila histone H3 (HHT2) gene, complete cds	blastn	10477	390	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
20071151	20071151	PRJNA971676_P_NODE_10536_length_281_cov_1.764423_g10447_i0	PRJNA971676	10536	281	1.764423	4.95802863	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	342	1.3699999999999997e-89	NTclustered	gi\|829164475\|ref\|XM_971965.3\|	312017	g10447	i0	88.849	1.62277580071174	278	31	99	0	4	281	1049	772	Tetrahymena thermophila SB210 protein transporter Sec61 alpha subunit partial mRNA	blastn	456	342	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila

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