metadata: contig_metadata: 9 rows where bioproject = "PRJNA774958", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA774958", tax_clade = "Sar" 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
752663	752663	PRJNA774958_P_NODE_25421_length_306_cov_1.652361_g25174_i0	PRJNA774958	25421	306	1.652361	5.05622466	Chilodonella piscicola	1654720	SAR_Eukaryotes	SAR_Eukaryotes	483	8.539999999999998e-132	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g25174	i0	95.098	33.7058823529412	306	15	100	0	1	306	633	328	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	10314	483	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
6312240	6312240	PRJNA774958_P_NODE_27925_length_287_cov_1.313084_g27678_i0	PRJNA774958	27925	287	1.313084	3.76855108	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	250	8.77e-62	NTclustered	gi\|161734\|gb\|L01415.1\|TETBTUBUA	5911	g27678	i0	85.957	75.7665505226481	235	31	82	2	3	236	366	133	Tetrahymena thermophila beta-tubulin (BTU1) gene, complete cds	blastn	21745	250	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
8405848	8405848	PRJNA774958_P_NODE_33327_length_251_cov_0.865169_g33080_i0	PRJNA774958	33327	251	0.865169	2.17157419	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	154	7.15e-43	NR	XP_001021714.2	312017	g33080	i0	86.7	1.9840637450199201	83	11	99.2	0	2	250	99	181	XP_001021714.2 elongation factor Tu protein [Tetrahymena thermophila SB210]	diamond	498	154	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
21155288	21155288	PRJNA774958_P_NODE_30457_length_269_cov_1.816327_g30210_i0	PRJNA774958	30457	269	1.816327	4.88591963	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	123	1.76e-30	NR	CAI2364221.1	5936	g30210	i0	70.8	15.9144981412639	89	25	99.3	1	269	3	31	118	CAI2364221.1 unnamed protein product [Moneuplotes crassus]	diamond	4281	123	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
27432893	27432893	PRJNA774958_P_NODE_34223_length_249_cov_1.647727_g33976_i0	PRJNA774958	34223	249	1.647727	4.10284023	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	73.2	3.2e-13	NR	KRX05222.1	266149	g33976	i0	45.7	5.8433734939759	81	39	97.6	1	7	249	183	258	KRX05222.1 hypothetical protein PPERSA_06856 [Pseudocohnilembus persalinus]	diamond	1455	73.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
28758644	28758644	PRJNA774958_P_NODE_13407_length_445_cov_1.215054_g13160_i0	PRJNA774958	13407	445	1.215054	5.4069903	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	48.1	0.00376	NR	OMJ82135.1	5963	g13160	i0	33.8	1.55730337078652	71	44	47.9	2	168	380	191	258	OMJ82135.1 hypothetical protein SteCoe_17254 [Stentor coeruleus]	diamond	693	48.1	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
30147928	30147928	PRJNA774958_P_NODE_16872_length_395_cov_0.956522_g16625_i0	PRJNA774958	16872	395	0.956522	3.7782619	Halteria grandinella	5974	SAR_Eukaryotes	SAR_Eukaryotes	60.1	1.75e-7	NR	TNV83586.1	5974	g16625	i0	36.4	2.30126582278481	77	49	58.5	0	31	261	418	494	TNV83586.1 hypothetical protein FGO68_gene12417 [Halteria grandinella]	diamond	909	60.1	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Halteriidae	Halteria	Halteria grandinella
30527218	30527218	PRJNA774958_P_NODE_12013_length_470_cov_9.521411_g11766_i0	PRJNA774958	12013	470	9.521411	44.7506317	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	63.2	1.73e-9	NR	XP_001444855.1	5888	g11766	i0	41.2	0.727659574468085	114	57	71.5	3	389	54	17	122	XP_001444855.1 uncharacterized protein GSPATT00012943001 [Paramecium tetraurelia]	diamond	342	63.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
30558712	30558712	PRJNA774958_P_NODE_6373_length_650_cov_2.421144_g6145_i0	PRJNA774958	6373	650	2.421144	15.737436	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	136	7.36e-33	NR	OMJ95327.1	5963	g6145	i0	40.3	6.80307692307692	211	109	96	6	1	624	630	826	OMJ95327.1 hypothetical protein SteCoe_1390 [Stentor coeruleus]	diamond	4422	136	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus

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