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

7 rows where analysis = "blastn", bioproject = "PRJNA1196438" 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
1598181	1598181	PRJNA1196438_P_NODE_73902_length_244_cov_0.912281_g73475_i0	PRJNA1196438	73902	244	0.912281	2.22596564	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	111	3.58e-20	NTclustered	gi\|471227796\|ref\|XM_004034752.1\|	5932	g73475	i0	86.408	0.422131147540984	103	12	41	2	1	101	469	367	Ichthyophthirius multifiliis ku p70 DNA helicase, putative (IMG5_113130) mRNA, complete cds	blastn	103	111	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
2874439	2874439	PRJNA1196438_P_NODE_82783_length_228_cov_2.567742_g82356_i0	PRJNA1196438	82783	228	2.567742	5.85445176	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	255	1.44e-63	NTclustered	gi\|471228778\|ref\|XM_004035212.1\|	5932	g82356	i0	87.387	0.973684210526316	222	28	97	0	5	226	635	856	Ichthyophthirius multifiliis swirm domain protein (IMG5_102740) mRNA, complete cds	blastn	222	255	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
4149952	4149952	PRJNA1196438_P_NODE_37204_length_293_cov_2.468182_g36778_i0	PRJNA1196438	37204	293	2.468182	7.23177326	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	165	3.34e-36	NTclustered	gi\|471221682\|ref\|XM_004029611.1\|	5932	g36778	i0	85.625	0.641638225255973	160	19	54	4	16	172	691	533	Ichthyophthirius multifiliis hypothetical protein (IMG5_176090) mRNA, complete cds	blastn	188	165	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
5426227	5426227	PRJNA1196438_P_NODE_3885_length_495_cov_2.902844_g3472_i0	PRJNA1196438	3885	495	2.902844	14.3690778	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.013	NTclustered	gi\|829186935\|ref\|XM_001022570.3\|	312017	g3472	i0	100	0.0585858585858586	29	0	6	0	167	195	1608	1636	Tetrahymena thermophila SB210 Serine/Threonine kinase domain protein partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
5426799	5426799	PRJNA1196438_P_NODE_77525_length_239_cov_2.813253_g77098_i0	PRJNA1196438	77525	239	2.813253	6.72367467	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	99	2.72e-16	NTclustered	gi\|471219214\|ref\|XM_004024088.1\|	5932	g77098	i0	89.024	0.343096234309623	82	5	33	3	3	82	408	487	Ichthyophthirius multifiliis hypothetical protein (IMG5_199330) mRNA, complete cds	blastn	82	99	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
12522011	12522011	PRJNA1196438_P_NODE_47670_length_277_cov_1.446078_g47243_i0	PRJNA1196438	47670	277	1.446078	4.00563606	Tetrahymenidae	291294	SAR_Eukaryotes	SAR_Eukaryotes	324	4.89e-84	NTclustered	gi\|114329902\|ref\|NC_008339.1\|	5907	g47243	i0	89.453	4.66425992779783	256	27	92	0	22	277	27206	26951	Tetrahymena pigmentosa mitochondrion, complete genome	blastn	1292	324	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pigmentosa
20724922	20724922	PRJNA1196438_P_NODE_76557_length_241_cov_3.660714_g76130_i0	PRJNA1196438	76557	241	3.660714	8.82232074	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	117	7.58e-22	NTclustered	gi\|471226651\|ref\|XM_004032309.1\|	5932	g76130	i0	90.805	0.360995850622407	87	8	36	0	1	87	544	630	Ichthyophthirius multifiliis tubulin-tyrosine ligase family protein, putative (IMG5_124010) mRNA, complete cds	blastn	87	117	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis

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