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

12 rows where analysis = "blastn", bioproject = "PRJNA1253303" and tax_clade = "Sar"

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
1634194	1634194	PRJNA1253303_P_NODE_2442_length_336_cov_1.045627_g2420_i0	PRJNA1253303	2442	336	1.045627	3.51330672	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	178	5.0099999999999996e-40	NTclustered	gi\|294889482\|ref\|XM_002772789.1\|	423536	g2420	i0	91.473	38.6458333333333	129	11	38	0	206	334	270	398	Perkinsus marinus ATCC 50983 alpha-tubulin, putative, mRNA	blastn	12985	178	1	Eukaryota	Sar	Perkinsozoa		Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
8012831	8012831	PRJNA1253303_P_NODE_1607_length_398_cov_2.880000_g1585_i0	PRJNA1253303	1607	398	2.88	11.4624	Voromonas pontica	333133	SAR_Eukaryotes	SAR_Eukaryotes	287	9.6e-73	NTclustered	gi\|677286270\|gb\|KF997847.1\|	333133	g1585	i0	80.315	12.1030150753769	381	73	95	2	3	382	455	76	Colpodella pontica translation elongation factor-like protein (EFL) mRNA, complete cds	blastn	4817	287	1	Eukaryota	Sar				Colpodellaceae	Voromonas	Voromonas pontica
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
15662392	15662392	PRJNA1253303_P_NODE_7493_length_245_cov_0.906977_g7471_i0	PRJNA1253303	7493	245	0.906977	2.22209365	Stramenopile sp. ex Nuclearia delicatula CCAP1552/1	289359	SAR_Eukaryotes	SAR_Eukaryotes	255	1.57e-63	NTclustered	gi\|53829555\|gb\|AY582830.1\|	289359	g7471	i0	98.611	21.6489795918367	144	2	59	0	102	245	1238	1095	Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds	blastn	5304	255	1	Eukaryota	Sar						Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
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
20761030	20761030	PRJNA1253303_P_NODE_4777_length_256_cov_1.092896_g4755_i0	PRJNA1253303	4777	256	1.092896	2.79781376	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	230	1e-55	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g4755	i0	83.142	35.3046875	261	34	100	10	1	256	3730	3985	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	9038	230	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
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);;