metadata: contig_metadata: 6 rows where bioproject = "PRJNA849822" and tax

6 rows where bioproject = "PRJNA849822" and tax_phylum = "Olpidiomycota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
22515541	22515541	PRJNA849822_P_NODE_7698_length_550_cov_2.085954_g7526_i0	PRJNA849822	7698	550	2.085954	11.472747	Olpidium bornovanus	278681	Fungi	Fungi	311	8.09e-80	NTclustered	gi\|358030883\|dbj\|AB609175.1\|	278681	g7526	i0	80.094	28.2654545454545	427	78	77	7	125	546	1607	1183	Olpidium bornovanus EF2 mRNA for translation elongation factor 2, partial cds, specimen_voucher: UBC:UBC F19785, clone: 2	blastn	15546	311	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
22515567	22515567	PRJNA849822_P_NODE_998_length_1583_cov_2.431788_g918_i0	PRJNA849822	998	1583	2.431788	38.49520404	Eukaryota	2759	Fungi	Fungi	812	1.15e-291	NR	BAL15351.1	278681	g918	i0	76	8.04864181933038	529	123	99.9	3	1581	1	24	550	BAL15351.1 translation elongation factor 2, partial [Olpidium bornovanus]	diamond	12741	819	0.991452991452991	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
31043018	31043018	PRJNA849822_P_NODE_12335_length_419_cov_2.708092_g12161_i0	PRJNA849822	12335	419	2.708092	11.34690548	Eukaryota	2759	Fungi	Fungi	142	3.76e-41	NR	KAG5461717.1	278681	g12161	i0	63.5	5.34128878281623	104	38	74.5	0	371	60	3	106	KAG5461717.1 MAG: 60S ribosomal protein L33-A-like protein [Olpidium bornovanus]	diamond	2238	143	0.993006993006993	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
31128861	31128861	PRJNA849822_P_NODE_9495_length_487_cov_1.528986_g9322_i0	PRJNA849822	9495	487	1.528986	7.44616182	Olpidium bornovanus	278681	Fungi	Fungi	55.8	1.11e-5	NR	KAG5462489.1	278681	g9322	i0	29.9	2.11909650924025	127	82	74.5	4	429	67	154	279	KAG5462489.1 MAG: hypothetical protein BJ554DRAFT_4920, partial [Olpidium bornovanus]	diamond	1032	55.8	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
31350599	31350599	PRJNA849822_P_NODE_17916_length_342_cov_1.513011_g17742_i0	PRJNA849822	17916	342	1.513011	5.17449762	Olpidium bornovanus	278681	Fungi	Fungi	58.2	3.83e-7	NR	KAG5462938.1	278681	g17742	i0	38.1	1.69298245614035	97	59	84.2	1	35	322	233	329	KAG5462938.1 MAG: KA1 domain/Ssp2 C-terminal domain-containing protein [Olpidium bornovanus]	diamond	579	58.2	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
31477227	31477227	PRJNA849822_P_NODE_33536_length_253_cov_0.866667_g33362_i0	PRJNA849822	33536	253	0.866667	2.19266751	Olpidium bornovanus	278681	Fungi	Fungi	58.5	1.16e-7	NR	KAG5463706.1	278681	g33362	i0	37.8	1.06719367588933	90	43	92.5	2	235	2	391	479	KAG5463706.1 MAG: Nrap protein, partial [Olpidium bornovanus]	diamond	270	58.5	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus

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