metadata: contig_metadata: 7 rows where bioproject = "PRJNA630162" and tax

7 rows where bioproject = "PRJNA630162" 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
1877989	1877989	PRJNA630162_P_NODE_157882_length_162_cov_9.991150_g156359_i0	PRJNA630162	157882	162	9.99115	16.185663	Olpidium brassicae	70189	Fungi	Fungi	137	3.6199999999999997e-28	NTclustered	gi\|311235549\|ref\|NG_027564.1\|	70189	g156359	i0	82.5	53.8456790123457	160	25	97	2	1	157	2748	2589	Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material	blastn	8723	137	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium brassicae
8255061	8255061	PRJNA630162_P_NODE_165707_length_158_cov_3.183486_g164184_i0	PRJNA630162	165707	158	3.183486	5.02990788	Olpidium brassicae	70189	Fungi	Fungi	141	2.71e-29	NTclustered	gi\|311235549\|ref\|NG_027564.1\|	70189	g164184	i0	83.553	9.27215189873418	152	24	96	1	2	153	1984	1834	Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material	blastn	1465	141	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium brassicae
15905394	15905394	PRJNA630162_P_NODE_64753_length_220_cov_1.023392_g63230_i0	PRJNA630162	64753	220	1.023392	2.2514624	Olpidium vermicola	3036392	Fungi	Fungi	161	3.1e-35	NTclustered	gi\|2468646907\|gb\|OQ702805.1\|	3036392	g63230	i0	86.486	66.3318181818182	148	18	67	2	1	147	1588	1442	Olpidium vermicola small subunit ribosomal RNA gene, partial sequence	blastn	14593	161	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium vermicola
17180868	17180868	PRJNA630162_P_NODE_96614_length_187_cov_4.666667_g95091_i0	PRJNA630162	96614	187	4.666667	8.72666729	Olpidium brassicae	70189	Fungi	Fungi	121	4.3299999999999996e-23	NTclustered	gi\|311235549\|ref\|NG_027564.1\|	70189	g95091	i0	81.757	76.171122994652407	148	23	78	4	38	182	1779	1633	Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material	blastn	14244	121	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium brassicae
24103110	24103110	PRJNA630162_P_NODE_145299_length_165_cov_3.879310_g143776_i0	PRJNA630162	145299	165	3.87931	6.4008615	Fungi	4751	Fungi	Fungi	217	4.619999999999999e-52	NTclustered	gi\|311235549\|ref\|NG_027564.1\|	70189	g143776	i0	91.195	94.7757575757576	159	14	96	0	3	161	1802	1644	Olpidium brassicae DUKE DUH0009361 28S rRNA gene, partial sequence; from reference material	blastn	15638	219	0.990867579908676	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium brassicae
28154773	28154773	PRJNA630162_P_NODE_171285_length_153_cov_2.509615_g169762_i0	PRJNA630162	171285	153	2.509615	3.83971095	Olpidium bornovanus	278681	Fungi	Fungi	80.1	8.45e-17	NR	KAG5461027.1	278681	g169762	i0	75	9.41176470588235	48	12	94.1	0	146	3	120	167	KAG5461027.1 MAG: putative ribosomal protein L10 [Olpidium bornovanus]	diamond	1440	80.1	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
29038892	29038892	PRJNA630162_P_NODE_159088_length_162_cov_1.787611_g157565_i0	PRJNA630162	159088	162	1.787611	2.89592982	Olpidium bornovanus	278681	Fungi	Fungi	73.9	1.2e-13	NR	BAL15351.1	278681	g157565	i0	66	0.981481481481482	53	18	98.1	0	3	161	244	296	BAL15351.1 translation elongation factor 2, partial [Olpidium bornovanus]	diamond	159	73.9	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);;