metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA797655" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA797655" and tax_phylum = "Basidiomycota"

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
28190696	28190696	PRJNA797655_S_NODE_100666_length_245_cov_2.569307_g100061_i0	PRJNA797655	100666	245	2.569307	6.29480215	Rhodotorula pacifica	1495444	Fungi	Fungi	44.3	0.0063	NR	GAA5992976.1	1495444	g100061	i0	100	0.857142857142857	22	0	26.9	0	2	67	149	170	GAA5992976.1 hypothetical protein JCM10908_000780 [Rhodotorula pacifica]	diamond	210	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula pacifica
28475146	28475146	PRJNA797655_S_NODE_90906_length_255_cov_2.716981_g90301_i0	PRJNA797655	90906	255	2.716981	6.92830155	Puccinia striiformis f. sp. tritici	168172	Fungi	Fungi	42.4	0.0318	NR	KAI7939409.1	168172	g90301	i0	32.7	0.647058823529412	55	34	61.2	1	220	65	6	60	KAI7939409.1 hypothetical protein MJO29_014145 [Puccinia striiformis f. sp. tritici]	diamond	165	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia striiformis
28601483	28601483	PRJNA797655_S_NODE_191527_length_183_cov_1.028571_g190922_i0	PRJNA797655	191527	183	1.028571	1.88228493	Rhodotorula diobovata	5288	Fungi	Fungi	43.1	0.0123	NR	TNY21304.1	5288	g190922	i0	37.3	0.967213114754098	59	31	86.9	2	23	181	895	953	TNY21304.1 Proteophosphoglycan ppg4 [Rhodotorula diobovata]	diamond	177	43.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula diobovata
28980468	28980468	PRJNA797655_S_NODE_270148_length_152_cov_1.321101_g269543_i0	PRJNA797655	270148	152	1.321101	2.00807352	Papiliotrema laurentii	5418	Fungi	Fungi	41.2	0.0379	NR	KAK1920970.1	5418	g269543	i0	35.4	0.947368421052632	48	31	94.7	0	146	3	51	98	KAK1920970.1 aspartic peptidase domain-containing protein [Papiliotrema laurentii]	diamond	144	41.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Rhynchogastremaceae	Papiliotrema	Papiliotrema laurentii
29295989	29295989	PRJNA797655_S_NODE_140469_length_212_cov_2.816568_g139864_i0	PRJNA797655	140469	212	2.816568	5.97112416	Lactarius hatsudake	416442	Fungi	Fungi	42.7	0.0253	NR	KAH8994408.1	416442	g139864	i0	53.8	2.20754716981132	39	16	55.2	1	85	201	111	147	KAH8994408.1 hypothetical protein EDB86DRAFT_3064727 [Lactarius hatsudake]	diamond	468	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Lactarius	Lactarius hatsudake
29990785	29990785	PRJNA797655_S_NODE_274351_length_151_cov_1.333333_g273746_i0	PRJNA797655	274351	151	1.333333	2.01333283	Earliella scabrosa	2478900	Fungi	Fungi	43.5	0.00574	NR	KAI0744772.1	2478900	g273746	i0	42.1	0.754966887417219	38	22	75.5	0	139	26	129	166	KAI0744772.1 hypothetical protein C8Q76DRAFT_789259 [Earliella scabrosa]	diamond	114	43.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Earliella	Earliella scabrosa
30022467	30022467	PRJNA797655_S_NODE_216671_length_171_cov_2.156250_g216066_i0	PRJNA797655	216671	171	2.15625	3.6871875	Mycena venus	2733690	Fungi	Fungi	43.9	0.00577	NR	KAF7343262.1	2733690	g216066	i0	41.7	0.842105263157895	48	27	84.2	1	13	156	722	768	KAF7343262.1 hypothetical protein MVEN_01758100 [Mycena venus]	diamond	144	43.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena venus
30085407	30085407	PRJNA797655_S_NODE_60112_length_296_cov_2.446640_g59507_i0	PRJNA797655	60112	296	2.44664	7.2420544	Sporisorium reilianum f. sp. reilianum	72559	Fungi	Fungi	43.1	0.0478	NR	SJX61733.1	72559	g59507	i0	35.6	0.597972972972973	59	38	59.8	0	209	33	22	80	SJX61733.1 uncharacterized protein SRS1_12717 [Sporisorium reilianum f. sp. reilianum]	diamond	177	43.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Sporisorium	Sporisorium reilianum
30433415	30433415	PRJNA797655_S_NODE_120653_length_227_cov_3.130435_g120048_i0	PRJNA797655	120653	227	3.130435	7.10608745	Chiua virens	1914213	Fungi	Fungi	40.8	0.022	NR	KAG9308551.1	1914213	g120048	i0	42.9	0.555066079295154	42	24	55.5	0	221	96	26	67	KAG9308551.1 hypothetical protein JVU11DRAFT_11765 [Chiua virens]	diamond	126	40.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Boletaceae	Chiua	Chiua virens
30916237	30916237	PRJNA797655_S_NODE_217874_length_171_cov_1.125000_g217269_i0	PRJNA797655	217874	171	1.125	1.92375	Basidiomycota	5204	Fungi	Fungi	77.8	4.98e-16	NR	KAK0440766.1	47425	g217269	i0	78.6	2.91228070175439	56	12	98.2	0	170	3	132	187	KAK0440766.1 60S ribosomal protein L19 [Armillaria borealis]	diamond	498	77.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Armillaria	Armillaria borealis
31096457	31096457	PRJNA797655_S_NODE_175115_length_191_cov_1.945946_g174510_i0	PRJNA797655	175115	191	1.945946	3.71675686	Mycena sp. CBHHK59/15	1940295	Fungi	Fungi	41.6	0.0494	NR	KAJ6618405.1	1940295	g174510	i0	43.4	1.66492146596859	53	30	83.2	0	161	3	1535	1587	KAJ6618405.1 hypothetical protein B0H10DRAFT_2433934 [Mycena sp. CBHHK59/15]	diamond	318	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena sp. CBHHK59/15
31571070	31571070	PRJNA797655_S_NODE_204316_length_177_cov_1.074627_g203711_i0	PRJNA797655	204316	177	1.074627	1.90208979	Pleurotus pulmonarius	28995	Fungi	Fungi	74.7	2.12e-14	NR	KAF4605151.1	28995	g203711	i0	71.9	1.93220338983051	57	16	96.6	0	175	5	169	225	KAF4605151.1 60S ribosomal protein L13 [Pleurotus pulmonarius]	diamond	342	74.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus pulmonarius
31792090	31792090	PRJNA797655_S_NODE_95357_length_250_cov_4.671498_g94752_i0	PRJNA797655	95357	250	4.671498	11.678745	Thelephora terrestris	56493	Fungi	Fungi	46.6	0.00135	NR	KAF9792336.1	56493	g94752	i0	40.7	0.648	54	31	64.8	1	211	50	56	108	KAF9792336.1 hypothetical protein BJ322DRAFT_36867 [Thelephora terrestris]	diamond	162	46.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Thelephorales	Thelephoraceae	Thelephora	Thelephora terrestris
32551950	32551950	PRJNA797655_S_NODE_260399_length_154_cov_2.162162_g259794_i0	PRJNA797655	260399	154	2.162162	3.32972948	Termitomyces sp. T159_Od127	2053459	Fungi	Fungi	41.6	0.0291	NR	KAG6886118.1	2053459	g259794	i0	35.3	0.993506493506494	51	31	95.5	1	150	4	350	400	KAG6886118.1 hypothetical protein C0993_002637 [Termitomyces sp. T159_Od127]	diamond	153	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Lyophyllaceae	Termitomyces	Termitomyces sp. T159_Od127

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