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

8 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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
5390924	5390924	PRJNA1144090_P_NODE_81365_length_279_cov_1.980583_g80830_i0	PRJNA1144090	81365	279	1.980583	5.52582657	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	76.8	1.52e-9	NTclustered	gi\|471223905\|ref\|XM_004030669.1\|	5932	g80830	i0	82.759	2.93189964157706	87	13	31	2	133	218	35	120	Ichthyophthirius multifiliis hypothetical protein (IMG5_154640) mRNA, complete cds	blastn	818	76.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
15590221	15590221	PRJNA1144090_P_NODE_44633_length_384_cov_1.826367_g44098_i0	PRJNA1144090	44633	384	1.826367	7.01324928	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	95.3	6e-15	NTclustered	gi\|471222578\|ref\|XM_004030039.1\|	5932	g44098	i0	89.333	1.88802083333333	75	8	20	0	4	78	175	101	Ichthyophthirius multifiliis hypothetical protein (IMG5_167600) mRNA, complete cds	blastn	725	95.3	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
18138748	18138748	PRJNA1144090_P_NODE_120775_length_226_cov_2.006536_g120240_i0	PRJNA1144090	120775	226	2.006536	4.53477136	Lamtostyla sp. LPJ-2005	331616	SAR_Eukaryotes	SAR_Eukaryotes	278	3.05e-70	NTclustered	gi\|67462297\|gb\|DQ062090.1\|	331616	g120240	i0	89.189	61.2389380530973	222	24	98	0	5	226	897	676	Lamtostyla sp. LPJ-2005 heta shock protein 70 mRNA, partial cds; macronuclear	blastn	13840	278	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Stichotrichida	Amphisiellidae	Lamtostyla	Lamtostyla sp. LPJ-2005
19413528	19413528	PRJNA1144090_P_NODE_62376_length_321_cov_2.000000_g61841_i0	PRJNA1144090	62376	321	2	6.42	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	67.6	1.08e-6	NTclustered	gi\|829185214\|ref\|XM_001032921.3\|	312017	g61841	i0	93.333	0.538940809968847	45	3	14	0	248	292	90	46	Tetrahymena thermophila SB210 fructose-bisphosphate aldolase partial mRNA	blastn	173	67.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
20159401	20159401	PRJNA1144090_P_NODE_24396_length_542_cov_3.756930_g23866_i0	PRJNA1144090	24396	542	3.75693	20.3625606	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	316	1.71e-81	NTclustered	gi\|10805\|emb\|X52242.1\|	5911	g23866	i0	80.093	44.6014760147601	432	80	79	6	110	538	471	43	T.thermophila mRNA for calmodulin	blastn	24174	316	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
21434974	21434974	PRJNA1144090_P_NODE_8337_length_982_cov_6.920792_g7961_i0	PRJNA1144090	8337	982	6.920792	67.96217744	Ophryoscolecidae	47890	SAR_Eukaryotes	SAR_Eukaryotes	178	1.57e-39	NTclustered	gi\|92790165\|emb\|AJ965268.1\|	47892	g7961	i0	80.519	8.9979633401222	231	45	24	0	378	608	91	321	Eudiplodinium maggii partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene)	blastn	8836	178	1	Eukaryota	Sar	Ciliophora	Litostomatea	Entodiniomorphida	Ophryoscolecidae	Eudiplodinium	Eudiplodinium maggii
21964064	21964064	PRJNA1144090_P_NODE_41438_length_400_cov_2.550459_g40903_i0	PRJNA1144090	41438	400	2.550459	10.201836	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.038	NTclustered	gi\|829191702\|ref\|XM_001023866.2\|	312017	g40903	i0	100	0.07	28	0	7	0	197	224	2263	2290	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
23239546	23239546	PRJNA1144090_P_NODE_28579_length_494_cov_2.567696_g28045_i0	PRJNA1144090	28579	494	2.567696	12.68441824	Colpoda magna	459253	SAR_Eukaryotes	SAR_Eukaryotes	63.9	2.23e-5	NTclustered	gi\|296939564\|gb\|HM246410.1\|	459253	g28045	i0	83.824	0.291497975708502	68	10	14	1	41	108	484	550	Colpoda magna isolate Coma1 small subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	144	63.9	1	Eukaryota	Sar	Ciliophora	Colpodea	Colpodida	Colpodidae	Colpoda	Colpoda magna

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