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

8 rows where analysis = "blastn", bioproject = "PRJNA1253303" 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
8705315	8705315	PRJNA1253303_P_NODE_2667_length_325_cov_2.440476_g2645_i0	PRJNA1253303	2667	325	2.440476	7.931547	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	462	1.19e-125	NTclustered	gi\|315570298\|tpg\|BK007911.1\|	5911	g2645	i0	92.308	2	325	25	100	0	1	325	330	654	TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS4e mRNA, complete cds	blastn	650	462	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
9287731	9287731	PRJNA1253303_P_NODE_8568_length_238_cov_2.412121_g8546_i0	PRJNA1253303	8568	238	2.412121	5.74084798	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	143	1.2299999999999998e-29	NTclustered	gi\|829189752\|ref\|XM_001023391.3\|	312017	g8546	i0	94.565	0.38655462184874	92	5	39	0	147	238	1	92	Tetrahymena thermophila SB210 transmembrane protein, putative partial mRNA	blastn	92	143	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
14388536	14388536	PRJNA1253303_P_NODE_3412_length_295_cov_1.243243_g3390_i0	PRJNA1253303	3412	295	1.243243	3.66756685	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	353	6.7e-93	NTclustered	gi\|829147375\|ref\|XM_001010221.3\|	312017	g3390	i0	90.637	0.905084745762712	267	23	90	2	30	295	1	266	Tetrahymena thermophila SB210 ribosomal protein L35 partial mRNA	blastn	267	353	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
14388607	14388607	PRJNA1253303_P_NODE_6472_length_248_cov_0.891429_g6450_i0	PRJNA1253303	6472	248	0.891429	2.21074392	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	233	7.459999999999999e-57	NTclustered	gi\|829180474\|ref\|XM_001019588.3\|	312017	g6450	i0	98.485	13.1491935483871	132	2	53	0	1	132	337	468	Tetrahymena thermophila SB210 40S ribosomal protein S18, putative partial mRNA	blastn	3261	233	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
14388650	14388650	PRJNA1253303_P_NODE_7972_length_243_cov_1.811765_g7950_i0	PRJNA1253303	7972	243	1.811765	4.40258895	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	167	7.5e-37	NTclustered	gi\|829142621\|ref\|XM_001009605.3\|	312017	g7950	i0	82.234	0.810699588477366	197	31	80	4	28	222	1	195	Tetrahymena thermophila SB210 transmembrane protein, putative partial mRNA	blastn	197	167	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
17630257	17630257	PRJNA1253303_P_NODE_2054_length_362_cov_1.079585_g2032_i0	PRJNA1253303	2054	362	1.079585	3.9080977	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	156	2.54e-33	NTclustered	gi\|3366652\|gb\|AF031320.1\|AF031320	5911	g2032	i0	76.299	1.70165745856354	308	63	84	9	60	362	1105	803	Tetrahymena thermophila granule lattice protein 4 precursor (GRL4) mRNA, complete cds	blastn	616	156	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
19485467	19485467	PRJNA1253303_P_NODE_4556_length_261_cov_1.659574_g4534_i0	PRJNA1253303	4556	261	1.659574	4.33148814	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	392	1.2299999999999999e-104	NTclustered	gi\|829161113\|ref\|XM_001012665.3\|	312017	g4534	i0	93.846	4.29501915708812	260	16	99	0	2	261	500	241	Tetrahymena thermophila SB210 60S ribosomal protein L32 partial mRNA	blastn	1121	392	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
24585813	24585813	PRJNA1253303_P_NODE_7840_length_244_cov_0.912281_g7818_i0	PRJNA1253303	7840	244	0.912281	2.22596564	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	374	4.1399999999999986e-99	NTclustered	gi\|146185323\|ref\|XM_001031586.2\|	312017	g7818	i0	94.606	2.20491803278689	241	13	99	0	1	241	241	1	Tetrahymena thermophila SB210 40S ribosomal protein S13 partial mRNA	blastn	538	374	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);;