metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA825466" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA825466" 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
2096007	2096007	PRJNA825466_P_NODE_462_length_962_cov_9.204724_g387_i0	PRJNA825466	462	962	9.204724	88.54944488	Cryptocaryon irritans	153251	SAR_Eukaryotes	SAR_Eukaryotes	580	9.999999999999997e-161	NTclustered	gi\|118596715\|dbj\|AB275856.1\|	153251	g387	i0	82.655	51.3139293139293	663	107	69	7	304	962	740	82	Cryptocaryon irritans EF-1 alpha mRNA for elongation factor-1 alpha isoform-2, partial cds, lab strain 1	blastn	49364	580	1	Eukaryota	Sar	Ciliophora				Cryptocaryon	Cryptocaryon irritans
5923709	5923709	PRJNA825466_P_NODE_9725_length_290_cov_1.792627_g9624_i0	PRJNA825466	9725	290	1.792627	5.1986183	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	178	4.25e-40	NTclustered	gi\|2149885\|gb\|U93852.1\|ECU93852	5936	g9624	i0	79.07	41.8137931034483	258	54	89	0	18	275	1147	890	Euplotes crassus histone H2B (H2B(1)) gene, complete cds	blastn	12126	178	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
8473380	8473380	PRJNA825466_P_NODE_8287_length_304_cov_1.666667_g8186_i0	PRJNA825466	8287	304	1.666667	5.06666768	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	335	2.5099999999999993e-87	NTclustered	gi\|217404\|dbj\|D10521.1\|TETCALW	5908	g8186	i0	86.513	97.8717105263158	304	41	100	0	1	304	159	462	Tetrahymena pyriformis mRNA for calmodulin, complete cds	blastn	29753	335	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
11024095	11024095	PRJNA825466_P_NODE_1029_length_676_cov_2.409619_g934_i0	PRJNA825466	1029	676	2.409619	16.28902444	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	865	0	NTclustered	gi\|110644972\|gb\|DQ665918.1\|	151077	g934	i0	90.196	95.9585798816568	663	65	98	0	13	675	1	663	Chilodonella uncinata clone 1 beta-tubulin gene, partial cds	blastn	64868	865	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
11431948	11431948	PRJNA825466_P_NODE_609_length_855_cov_4.135550_g529_i0	PRJNA825466	609	855	4.13555	35.3589525	Spirotrichea	33829	SAR_Eukaryotes	SAR_Eukaryotes	896	0	NTclustered	gi\|10138\|emb\|X01746.1\|	5949	g529	i0	87.121	86.1087719298246	792	100	93	2	55	845	1003	213	Stylonychia lemnae gene for alpha-tubulin	blastn	73623	896	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
14848496	14848496	PRJNA825466_P_NODE_23232_length_245_cov_2.691860_g23131_i0	PRJNA825466	23232	245	2.69186	6.595057	Planilamina ovata	2684848	SAR_Eukaryotes	SAR_Eukaryotes	276	1.21e-69	NTclustered	gi\|1784308423\|gb\|MN830171.1\|	2684848	g23131	i0	93.548	71.5020408163265	186	10	76	2	1	185	1588	1772	Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence	blastn	17518	276	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Dysteriida	Kyaroikeidae	Planilamina	Planilamina ovata
15256152	15256152	PRJNA825466_P_NODE_14412_length_261_cov_1.595745_g14311_i0	PRJNA825466	14412	261	1.595745	4.16489445	Kyaroikeidae	2684845	SAR_Eukaryotes	SAR_Eukaryotes	224	4.77e-54	NTclustered	gi\|1784308423\|gb\|MN830171.1\|	2684848	g14311	i0	84.362	41.6551724137931	243	23	89	9	18	249	668	430	Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence	blastn	10872	224	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Dysteriida	Kyaroikeidae	Planilamina	Planilamina ovata
17805696	17805696	PRJNA825466_P_NODE_3594_length_396_cov_1.191950_g3493_i0	PRJNA825466	3594	396	1.19195	4.720122	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	183	1.29e-41	NTclustered	gi\|584458848\|gb\|KJ159074.1\|	5949	g3493	i0	79.478	69.239898989899	268	47	67	8	20	283	1117	854	Stylonychia lemnae histone variant H3.1 (HIS31) gene, complete cds; macronuclear	blastn	27419	183	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
22497211	22497211	PRJNA825466_P_NODE_6338_length_328_cov_1.717647_g6237_i0	PRJNA825466	6338	328	1.717647	5.63388216	Planilamina ovata	2684848	SAR_Eukaryotes	SAR_Eukaryotes	326	1.65e-84	NTclustered	gi\|1784308423\|gb\|MN830171.1\|	2684848	g6237	i0	85.761	58.7713414634146	309	42	94	2	19	326	414	107	Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence	blastn	19277	326	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Dysteriida	Kyaroikeidae	Planilamina	Planilamina ovata

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