metadata: contig_metadata: 8 rows where bioproject = "PRJNA1237347" and tax

8 rows where bioproject = "PRJNA1237347" 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
13090103	13090103	PRJNA1237347_P_NODE_108491_length_647_cov_1.451220_g102033_i0	PRJNA1237347	108491	647	1.45122	9.3893934	Eukaryota	2759	Fungi	Fungi	311	1.07e-99	NR	BAL15351.1	278681	g102033	i0	68.4	24.9227202472952	215	68	99.7	0	645	1	188	402	BAL15351.1 translation elongation factor 2, partial [Olpidium bornovanus]	diamond	16125	311	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
14375572	14375572	PRJNA1237347_P_NODE_96372_length_697_cov_20.415064_g90032_i0	PRJNA1237347	96372	697	20.415064	142.29299608	Olpidium brassicae	70189	Fungi	Fungi	339	4.769999999999999e-88	NTclustered	gi\|311235549\|ref\|NG_027564.1\|	70189	g90032	i0	83.508	48.7690100430416	382	44	54	16	196	570	2093	1724	Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material	blastn	33992	339	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium brassicae
18194289	18194289	PRJNA1237347_P_NODE_410775_length_275_cov_1.465347_g404202_i0	PRJNA1237347	410775	275	1.465347	4.02970425	Fungi	4751	Fungi	Fungi	159	1.6e-43	NR	BAL15352.1	70189	g404202	i0	82.4	22.7236363636364	91	16	99.3	0	1	273	282	372	BAL15352.1 translation elongation factor 2, partial [Olpidium brassicae]	diamond	6249	159	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium brassicae
20740161	20740161	PRJNA1237347_P_NODE_209017_length_421_cov_1.635057_g202445_i0	PRJNA1237347	209017	421	1.635057	6.88358997	Olpidium brassicae	70189	Fungi	Fungi	333	1.29e-86	NTclustered	gi\|358030887\|dbj\|AB609177.1\|	70189	g202445	i0	81.509	50.7197149643705	411	70	97	6	1	408	1482	1075	Olpidium brassicae EF2 mRNA for translation elongation factor 2, partial cds, specimen_voucher: UBC:UBC F19784, clone: 2	blastn	21353	333	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium brassicae
26996567	26996567	PRJNA1237347_P_NODE_550662_length_241_cov_1.815476_g544089_i0	PRJNA1237347	550662	241	1.815476	4.37529716	Fungi	4751	Fungi	Fungi	92.8	4.980000000000001e-21	NR	KAG5460468.1	278681	g544089	i0	63.8	5.37759336099585	69	24	85.9	1	207	1	52	119	KAG5460468.1 MAG: flavoprotein-like protein [Olpidium bornovanus]	diamond	1296	92.8	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
27420834	27420834	PRJNA1237347_P_NODE_220743_length_406_cov_1.873874_g214171_i0	PRJNA1237347	220743	406	1.873874	7.60792844	Olpidium bornovanus	278681	Fungi	Fungi	87.8	5.56e-19	NR	KAG5463124.1	278681	g214171	i0	42.9	3.76108374384236	98	56	72.4	0	342	49	1	98	KAG5463124.1 MAG: guanine nucleotide binding protein, alpha subunit [Olpidium bornovanus]	diamond	1527	87.8	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
30799399	30799399	PRJNA1237347_P_NODE_168314_length_486_cov_1.820823_g161746_i0	PRJNA1237347	168314	486	1.820823	8.84919978	Olpidium bornovanus	278681	Fungi	Fungi	113	2.61e-27	NR	KAG5461465.1	278681	g161746	i0	45	1.74074074074074	129	62	74.1	1	125	484	16	144	KAG5461465.1 MAG: hypothetical protein BJ554DRAFT_6337, partial [Olpidium bornovanus]	diamond	846	113	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
31021191	31021191	PRJNA1237347_P_NODE_489815_length_249_cov_0.875000_g483242_i0	PRJNA1237347	489815	249	0.875	2.17875	Olpidium bornovanus	278681	Fungi	Fungi	75.1	1.6e-14	NR	KAG5456574.1	278681	g483242	i0	47.6	1.93975903614458	82	38	98.8	1	2	247	56	132	KAG5456574.1 MAG: CBF/Mak21 family-domain-containing protein [Olpidium bornovanus]	diamond	483	75.1	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);;