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

8 rows where bioproject = "PRJNA690592" 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
3730947	3730947	PRJNA690592_S_NODE_99243_length_328_cov_3.235294_g98229_i0	PRJNA690592	99243	328	3.235294	10.61176432	Fungi	4751	Fungi	Fungi	313	1.28e-80	NTclustered	gi\|298363345\|gb\|HM117713.1\|	70189	g98229	i0	86.364	88.3262195121951	286	39	87	0	7	292	599	314	Olpidium brassicae voucher UBC F19784 actin-like protein 1 mRNA, partial cds	blastn	28971	315	0.993650793650794	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium brassicae
10875424	10875424	PRJNA690592_S_NODE_193849_length_248_cov_1.640000_g192835_i0	PRJNA690592	193849	248	1.64	4.0672	Fungi	4751	Fungi	Fungi	121	2.1399999999999997e-31	NR	KAG5459033.1	278681	g192835	i0	68.3	4.95967741935484	82	26	99.2	0	2	247	178	259	KAG5459033.1 MAG: Dihydrolipoyl dehydrogenase mitochondrial precursor [Olpidium bornovanus]	diamond	1230	121	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
12150012	12150012	PRJNA690592_S_NODE_104910_length_321_cov_2.189516_g103896_i0	PRJNA690592	104910	321	2.189516	7.02834636	Fungi	4751	Fungi	Fungi	129	8.84e-35	NR	KAG5461676.1	278681	g103896	i0	57.7	1.94392523364486	104	40	97.2	1	319	8	28	127	KAG5461676.1 MAG: coronin 6, isoform CRA_a, partial [Olpidium bornovanus]	diamond	624	129	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
21073298	21073298	PRJNA690592_S_NODE_129997_length_294_cov_2.090498_g128983_i0	PRJNA690592	129997	294	2.090498	6.14606412	Olpidium bornovanus	278681	Fungi	Fungi	155	2.3299999999999993e-42	NR	KAG5457965.1	278681	g128983	i0	79.4	23.7244897959184	97	20	99	0	2	292	243	339	KAG5457965.1 MAG: eukaryotic translation initiation factor 2 alpha subunit-domain-containing protein [Olpidium bornovanus]	diamond	6975	155	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
24897891	24897891	PRJNA690592_S_NODE_29460_length_557_cov_1.113636_g28460_i0	PRJNA690592	29460	557	1.113636	6.20295252	Olpidium brassicae	70189	Fungi	Fungi	396	2.199999999999999e-105	NTclustered	gi\|358030887\|dbj\|AB609177.1\|	70189	g28460	i0	79.927	71.3770197486535	548	102	98	6	11	554	1003	1546	Olpidium brassicae EF2 mRNA for translation elongation factor 2, partial cds, specimen_voucher: UBC:UBC F19784, clone: 2	blastn	39757	396	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium brassicae
27019239	27019239	PRJNA690592_S_NODE_28522_length_565_cov_1.506098_g27524_i0	PRJNA690592	28522	565	1.506098	8.5094537	Olpidium bornovanus	278681	Fungi	Fungi	49.7	0.00229	NR	KAG5455635.1	278681	g27524	i0	25.8	0.945132743362832	178	116	89.7	6	36	542	178	348	KAG5455635.1 MAG: Metalloenzyme, LuxS/M16 peptidase-like protein, partial [Olpidium bornovanus]	diamond	534	49.7	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
29304336	29304336	PRJNA690592_S_NODE_63109_length_397_cov_1.879630_g62095_i0	PRJNA690592	63109	397	1.87963	7.4621311	Eukaryota	2759	Fungi	Fungi	80.5	2.39e-15	NR	KAG5456975.1	278681	g62095	i0	60.4	0.846347607052897	53	21	40.1	0	390	232	1	53	KAG5456975.1 MAG: WD40-repeat-containing domain protein, partial [Olpidium bornovanus]	diamond	336	80.5	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
32642872	32642872	PRJNA690592_S_NODE_195900_length_248_cov_0.880000_g194886_i0	PRJNA690592	195900	248	0.88	2.1824	Olpidium bornovanus	278681	Fungi	Fungi	70.5	1.87e-12	NR	KAG5460451.1	278681	g194886	i0	59.6	1.83870967741935	52	21	62.9	0	3	158	110	161	KAG5460451.1 MAG: armadillo-type protein, partial [Olpidium bornovanus]	diamond	456	70.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);;