metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA683669" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA683669" 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
4492956	4492956	PRJNA683669_P_NODE_31544_length_244_cov_0.900585_g31312_i0	PRJNA683669	31544	244	0.900585	2.1974274	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|829099169\|ref\|XM_971409.2\|	312017	g31312	i0	100	0.114754098360656	28	0	11	0	12	39	3687	3714	Tetrahymena thermophila SB210 tetratricopeptide repeat protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
5768533	5768533	PRJNA683669_P_NODE_16445_length_319_cov_3.455285_g16214_i0	PRJNA683669	16445	319	3.455285	11.02235915	Metopus es	392813	SAR_Eukaryotes	SAR_Eukaryotes	396	1.1999999999999997e-105	NTclustered	gi\|110645073\|gb\|DQ665935.1\|	392813	g16214	i0	89.062	98.7617554858934	320	33	100	2	1	319	360	678	Metopus es clone 1 actin gene, partial cds; macronuclear	blastn	31505	396	1	Eukaryota	Sar	Ciliophora	Armophorea	Metopida	Metopidae	Metopus	Metopus es
8318246	8318246	PRJNA683669_P_NODE_787_length_1360_cov_2.692308_g695_i0	PRJNA683669	787	1360	2.692308	36.6153888	Euplotes focardii	36767	SAR_Eukaryotes	SAR_Eukaryotes	909	0	NTclustered	gi\|224712110\|gb\|FJ664406.1\|	36767	g695	i0	79.098	96.5	1330	271	98	7	19	1345	1326	1	Euplotes focardii beta-tubulin T2 gene, complete cds; macronuclear	blastn	131240	909	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Euplotes	Euplotes focardii
10869084	10869084	PRJNA683669_P_NODE_8929_length_428_cov_1.915493_g8698_i0	PRJNA683669	8929	428	1.915493	8.19831004	Uroleptus gallina	57513	SAR_Eukaryotes	SAR_Eukaryotes	289	2.89e-73	NTclustered	gi\|21215215\|gb\|AF510209.1\|	57513	g8698	i0	83.387	33.5607476635514	313	50	73	2	115	426	189	500	Uroleptus gallina beta-tubulin gene, complete cds	blastn	14364	289	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Urostylida	Urostylidae	Uroleptus	Uroleptus gallina
12654215	12654215	PRJNA683669_P_NODE_10330_length_400_cov_1.370031_g10099_i0	PRJNA683669	10330	400	1.370031	5.480124	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	291	7.459999999999997e-74	NTclustered	gi\|10805\|emb\|X52242.1\|	5911	g10099	i0	83.281	16.46	317	51	79	2	7	322	345	30	T.thermophila mRNA for calmodulin	blastn	6584	291	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
24891235	24891235	PRJNA683669_P_NODE_9760_length_410_cov_1.617211_g9529_i0	PRJNA683669	9760	410	1.617211	6.6305651	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	58.4	8.46e-4	NTclustered	gi\|829195525\|ref\|XM_001025550.2\|	312017	g9529	i0	85.965	0.139024390243902	57	4	14	4	278	334	2015	1963	Tetrahymena thermophila SB210 zinc finger, C3HC4 type (RING finger) protein partial mRNA	blastn	57	58.4	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);;