metadata: contig_metadata: 12 rows where bioproject = "PRJNA734313" and tax

12 rows where bioproject = "PRJNA734313" and tax_phylum = "Ascomycota"

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
9645180	9645180	PRJNA734313_S_NODE_21468_length_201_cov_1.564935_g21355_i0	PRJNA734313	21468	201	1.564935	3.14551935	Trichoderma atroviride	63577	Fungi	Fungi	86.1	1.72e-12	NTclustered	gi\|2749703766\|ref\|XM_014090103.2\|	63577	g21355	i0	88	2.19402985074627	75	6	37	1	126	200	2269	2198	Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA	blastn	441	86.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae	Trichoderma	Trichoderma atroviride
12676353	12676353	PRJNA734313_S_NODE_16350_length_232_cov_1.832432_g16237_i0	PRJNA734313	16350	232	1.832432	4.25124224	Ascomycota	4890	Fungi	Fungi	424	3.82e-114	NTclustered	gi\|1050550576\|gb\|KX664397.1\|	29917	g16237	i0	99.569	100	232	1	100	0	1	232	770	539	Cladosporium cladosporioides isolate F42-01 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	23200	424	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium cladosporioides
12676362	12676362	PRJNA734313_S_NODE_36550_length_157_cov_1326.381818_g36437_i0	PRJNA734313	36550	157	1326.381818	2082.41945426	root	1	Root_unresolved	Root_unresolved	106	9.8e-19	NTclustered	gi\|193072614\|dbj\|AB293446.1\|	4932	g36437	i0	98.333	73.0700636942675	60	1	38	0	98	157	44098	44039	Saccharomyces cerevisiae gene for aquaporin Aqy1, complete cds, clone: COS5	blastn	11472	106	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
17774528	17774528	PRJNA734313_S_NODE_2154_length_512_cov_42.748387_g2046_i0	PRJNA734313	2154	512	42.748387	218.87174144	root	1	Root_unresolved	Root_unresolved	627	6.55e-175	NTclustered	gi\|193072614\|dbj\|AB293446.1\|	4932	g2046	i0	88.824	101.609375	510	57	99	0	3	512	42758	42249	Saccharomyces cerevisiae gene for aquaporin Aqy1, complete cds, clone: COS5	blastn	52024	632	0.992088607594937	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
23669736	23669736	PRJNA734313_S_NODE_12899_length_262_cov_1.353488_g12786_i0	PRJNA734313	12899	262	1.353488	3.54613856	Ramularia collo-cygni	112498	Fungi	Fungi	73.1	1.83e-8	NTclustered	gi\|1338077479\|ref\|XM_023765492.1\|	112498	g12786	i0	93.75	0.183206106870229	48	3	18	0	193	240	144	97	Ramularia collo-cygni uncharacterized protein (RCC_00340), partial mRNA	blastn	48	73.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Ramularia	Ramularia collo-cygni
24148389	24148389	PRJNA734313_S_NODE_28239_length_174_cov_1.433071_g28126_i0	PRJNA734313	28239	174	1.433071	2.49354354	root	1	Root_unresolved	Root_unresolved	322	1.01e-83	NTclustered	gi\|2612872\|gb\|AF010303.1\|	63354	g28126	i0	100	100	174	0	100	0	1	174	842	669	Sclerotium sp. BSC-97 18S ribosomal RNA gene, partial sequence	blastn	17400	322	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Sclerotiniaceae		Sclerotiniaceae sp. BSC-97
26619405	26619405	PRJNA734313_S_NODE_29301_length_170_cov_3.357724_g29188_i0	PRJNA734313	29301	170	3.357724	5.7081308	root	1	Root_unresolved	Root_unresolved	43.5	0.00759	NR	XP_062756889.1	173218	g29188	i0	54.3	1.18235294117647	35	16	61.8	0	7	111	1097	1131	XP_062756889.1 uncharacterized protein Triagg1_4382 [Trichoderma aggressivum f. europaeum]	diamond	201	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae	Trichoderma	Trichoderma aggressivum
26650847	26650847	PRJNA734313_S_NODE_6481_length_359_cov_1.839744_g6368_i0	PRJNA734313	6481	359	1.839744	6.60468096	root	1	Root_unresolved	Root_unresolved	52.4	6.05e-5	NR	KUI67785.1	578113	g6368	i0	42.4	6.5933147632312	59	34	49.3	0	339	163	994	1052	KUI67785.1 Protein MGA2 [Cytospora mali]	diamond	2367	52.8	0.992424242424242	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Diaporthales	Cytosporaceae	Cytospora	Cytospora mali
29936360	29936360	PRJNA734313_S_NODE_27811_length_175_cov_2.414062_g27698_i0	PRJNA734313	27811	175	2.414062	4.2246085	Eukaryota	2759	Fungi	Fungi	79	2.59e-15	NR	QID88496.1	27292	g27698	i0	66.1	3.87428571428571	56	19	96	0	4	171	537	592	QID88496.1 glycyl-tRNA synthase [Saccharomyces pastorianus]	diamond	678	79.7	0.991217063989962	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces pastorianus
29989248	29989248	PRJNA734313_S_NODE_9631_length_303_cov_1.578125_g9518_i0	PRJNA734313	9631	303	1.578125	4.78171875	Dissoconium aciculare CBS 342.82	1314786	Fungi	Fungi	110	1.31e-28	NR	XP_033454825.1	1314786	g9518	i0	65.6	0.920792079207921	93	32	92.1	0	2	280	28	120	XP_033454825.1 uncharacterized protein K489DRAFT_385514 [Dissoconium aciculare CBS 342.82]	diamond	279	110	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Dissoconiaceae	Dissoconium	Dissoconium aciculare
31885626	31885626	PRJNA734313_S_NODE_7857_length_331_cov_1.257042_g7744_i0	PRJNA734313	7857	331	1.257042	4.16080902	Cercospora kikuchii	84275	Fungi	Fungi	165	3.61e-46	NR	XP_044652522.1	84275	g7744	i0	88	0.75226586102719	83	10	75.2	0	330	82	409	491	XP_044652522.1 uncharacterized protein CKM354_000146200 [Cercospora kikuchii]	diamond	249	165	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Cercospora	Cercospora kikuchii
32613172	32613172	PRJNA734313_S_NODE_34640_length_160_cov_1.353982_g34527_i0	PRJNA734313	34640	160	1.353982	2.1663712	Monosporozyma servazzii	27293	Fungi	Fungi	54.7	6.57e-7	NR	CAL9733221.1	27293	g34527	i0	50	0.975	52	26	97.5	0	158	3	120	171	CAL9733221.1 ras-like protein 2 [Monosporozyma servazzii]	diamond	156	54.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Monosporozyma	Monosporozyma servazzii

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