metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJEB14664" and tax

10 rows where analysis = "blastn", bioproject = "PRJEB14664" and tax_phylum = "Blastocladiomycota"

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
7673370	7673370	PRJEB14664_P_NODE_13587_length_195_cov_1.743750_g13457_i0	PRJEB14664	13587	195	1.74375	3.4003125	Catenaria sp.	2420186	Fungi	Fungi	165	2.07e-36	NTclustered	gi\|1866582684\|gb\|MT730859.1\|	2420186	g13457	i0	82.412	37.2102564102564	199	25	100	6	1	195	4136	4328	Catenaria sp. isolate JEL0871 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	7256	165	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria sp.
9913930	9913930	PRJEB14664_P_NODE_20028_length_151_cov_2.068966_g19898_i0	PRJEB14664	20028	151	2.068966	3.12413866	Blastocladiales	4805	Fungi	Fungi	196	5.38e-46	NTclustered	gi\|1866582512\|gb\|MT730687.1\|	109876	g19898	i0	90.132	79.4039735099338	152	14	100	1	1	151	3951	4102	Catenaria anguillulae isolate JEL0194 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	11990	196	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae
12464890	12464890	PRJEB14664_P_NODE_16370_length_172_cov_2.043796_g16240_i0	PRJEB14664	16370	172	2.043796	3.51532912	Blastocladiomycota	451459	Fungi	Fungi	243	7.979999999999999e-60	NTclustered	gi\|117422543\|gb\|EF064248.1\|	4808	g16240	i0	92.814	95.9767441860465	167	12	97	0	2	168	234	400	Blastocladiella emersonii beta-tubulin mRNA, complete cds	blastn	16508	244	0.995901639344262	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
15323461	15323461	PRJEB14664_P_NODE_7653_length_290_cov_1.525490_g7523_i0	PRJEB14664	7653	290	1.52549	4.423921	Blastocladiella emersonii	4808	Fungi	Fungi	379	1.08e-100	NTclustered	gi\|117422539\|gb\|EF064246.1\|	4808	g7523	i0	91.606	42.1586206896552	274	23	94	0	17	290	78	351	Blastocladiella emersonii elongation factor alpha-like protein mRNA, complete cds	blastn	12226	379	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
16598054	16598054	PRJEB14664_P_NODE_19734_length_153_cov_1.016949_g19604_i0	PRJEB14664	19734	153	1.016949	1.55593197	Catenophlyctis variabilis	945688	Fungi	Fungi	207	2.53e-49	NTclustered	gi\|82592737\|gb\|DQ275345.1\|	945688	g19604	i0	91.892	31.5228758169935	148	12	97	0	1	148	193	340	Catenophlyctis variabilis isolate AFTOL-ID 36 elongation factor 1-alpha-like protein (EFL) gene, partial cds	blastn	4823	207	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenophlyctis	Catenophlyctis variabilis
16598055	16598055	PRJEB14664_P_NODE_1974_length_655_cov_1.332258_g1866_i0	PRJEB14664	1974	655	1.332258	8.7262899	Blastocladiella emersonii	4808	Fungi	Fungi	701	0	NTclustered	gi\|684989\|gb\|L22497.1\|BSIAHSP70X	4808	g1866	i0	86.233	86.7022900763359	661	73	99	13	10	655	2769	2112	Blastocladiella emersonii heat shock protein (hsp70) gene, complete cds	blastn	56790	701	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
17872758	17872758	PRJEB14664_P_NODE_12075_length_212_cov_1.146893_g11945_i0	PRJEB14664	12075	212	1.146893	2.43141316	Blastocladiella emersonii	4808	Fungi	Fungi	320	4.63e-83	NTclustered	gi\|117422539\|gb\|EF064246.1\|	4808	g11945	i0	93.868	75.2783018867924	212	13	100	0	1	212	353	564	Blastocladiella emersonii elongation factor alpha-like protein mRNA, complete cds	blastn	15959	320	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
20421834	20421834	PRJEB14664_P_NODE_12797_length_203_cov_2.619048_g12667_i0	PRJEB14664	12797	203	2.619048	5.31666744	Allomyces arbusculus	64504	Fungi	Fungi	243	9.78e-60	NTclustered	gi\|298363363\|gb\|HM117708.1\|	64504	g12667	i0	88.177	49.2758620689655	203	24	100	0	1	203	170	372	Allomyces arbuscula voucher BL002 actin gene, partial cds	blastn	10003	243	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
21697897	21697897	PRJEB14664_P_NODE_16218_length_173_cov_1.739130_g16088_i0	PRJEB14664	16218	173	1.73913	3.0086949	Blastocladiella emersonii	4808	Fungi	Fungi	270	3.69e-68	NTclustered	gi\|117422539\|gb\|EF064246.1\|	4808	g16088	i0	94.798	27.5895953757225	173	9	100	0	1	173	1093	921	Blastocladiella emersonii elongation factor alpha-like protein mRNA, complete cds	blastn	4773	270	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
23938090	23938090	PRJEB14664_P_NODE_13359_length_197_cov_2.222222_g13229_i0	PRJEB14664	13359	197	2.222222	4.37777734	Blastocladiaceae	4806	Fungi	Fungi	211	2.66e-50	NTclustered	gi\|2440036\|emb\|X90411.1\|	4808	g13229	i0	86.07	70.8477157360406	201	23	100	5	1	197	2164	1965	B.emersonii DNA for 28S ribosomal RNA gene	blastn	13957	213	0.990610328638498	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii

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