metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA560029" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA560029" 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
18396192	18396192	PRJNA560029_S_NODE_9775_length_369_cov_2.550676_g9551_i0	PRJNA560029	9775	369	2.550676	9.41199444	Agaricales	5338	Fungi	Fungi	105	2.4e-26	NR	KAJ7900010.1	230810	g9551	i0	73.8	10.5609756097561	65	17	52.8	0	3	197	55	119	KAJ7900010.1 ribosomal protein S27-domain-containing protein [Mycena olivaceomarginata]	diamond	3897	105	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena olivaceomarginata
22220941	22220941	PRJNA560029_S_NODE_20718_length_299_cov_2.615044_g20494_i0	PRJNA560029	20718	299	2.615044	7.81898156	Rhodotorula	5533	Fungi	Fungi	185	1.5099999999999998e-57	NR	GAA5881713.1	86832	g20494	i0	98.9	1.80602006688963	90	1	90.3	0	298	29	104	193	GAA5881713.1 hypothetical protein JCM3774_005965 [Rhodotorula dairenensis]	diamond	540	185	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula dairenensis
27187609	27187609	PRJNA560029_S_NODE_20122_length_302_cov_2.384279_g19898_i0	PRJNA560029	20122	302	2.384279	7.20052258	Eukaryota	2759	Fungi	Fungi	122	7.97e-33	NR	EJD46811.1	717982	g19898	i0	86.6	37.2715231788079	67	9	66.6	0	300	100	100	166	EJD46811.1 hypothetical protein AURDEDRAFT_87123 [Auricularia subglabra TFB-10046 SS5]	diamond	11256	122	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Auriculariales	Auriculariaceae	Auricularia	Auricularia subglabra
27598668	27598668	PRJNA560029_S_NODE_8324_length_384_cov_2.154341_g8100_i0	PRJNA560029	8324	384	2.154341	8.27266944	Panaeolus	71684	Fungi	Fungi	118	1.97e-31	NR	PPQ64359.1	181874	g8100	i0	61.9	3.046875	97	36	75	1	378	91	28	124	PPQ64359.1 hypothetical protein CVT24_008428 [Panaeolus cyanescens]	diamond	1170	119	0.991596638655462	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Galeropsidaceae	Panaeolus	Panaeolus cyanescens
28373755	28373755	PRJNA560029_S_NODE_12906_length_344_cov_3.464945_g12682_i0	PRJNA560029	12906	344	3.464945	11.9194108	Abortiporus biennis	137743	Fungi	Fungi	119	1.9000000000000003e-28	NR	KAI0784117.1	137743	g12682	i0	59.4	14.2325581395349	96	37	83.7	1	57	344	82	175	KAI0784117.1 serine/threonine protein phosphatase 2B [Abortiporus biennis]	diamond	4896	119	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Podoscyphaceae	Abortiporus	Abortiporus biennis
29131782	29131782	PRJNA560029_S_NODE_6669_length_405_cov_3.069277_g6445_i0	PRJNA560029	6669	405	3.069277	12.43057185	Collybia nuda	64659	Fungi	Fungi	134	1.89e-36	NR	KAF9464520.1	64659	g6445	i0	72.3	0.614814814814815	83	23	61.5	0	25	273	136	218	KAF9464520.1 hypothetical protein BDZ94DRAFT_1320909 [Collybia nuda]	diamond	249	134	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Clitocybaceae	Collybia	Collybia nuda
31027000	31027000	PRJNA560029_S_NODE_19555_length_305_cov_2.323276_g19331_i0	PRJNA560029	19555	305	2.323276	7.0859918	Flagelloscypha sp. PMI_526	1485228	Fungi	Fungi	85.5	6.81e-17	NR	KAH8822332.1	1485228	g19331	i0	56.6	0.973770491803279	99	29	94.4	5	3	290	403	490	KAH8822332.1 hypothetical protein DL96DRAFT_1714664 [Flagelloscypha sp. PMI_526]	diamond	297	85.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Tricholomataceae	Flagelloscypha	Flagelloscypha sp. PMI_526
31041115	31041115	PRJNA560029_S_NODE_2615_length_537_cov_6.056034_g2394_i0	PRJNA560029	2615	537	6.056034	32.52090258	Agaricales	5338	Fungi	Fungi	87.8	1.63e-16	NR	KAF8625928.1	1457513	g2394	i0	48.6	4.36871508379888	72	37	40.2	0	3	218	651	722	KAF8625928.1 hypothetical protein AX17_006654 [Amanita inopinata Kibby_2008]	diamond	2346	87.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Amanitaceae	Amanita	Amanita inopinata
32102106	32102106	PRJNA560029_S_NODE_16398_length_322_cov_1.815261_g16174_i0	PRJNA560029	16398	322	1.815261	5.84514042	Pleurotus cornucopiae	5321	Fungi	Fungi	46.2	0.00531	NR	KAG9221411.1	5321	g16174	i0	42.6	0.56832298136646	61	28	50.3	1	230	69	423	483	KAG9221411.1 hypothetical protein CCMSSC00406_0008333 [Pleurotus cornucopiae]	diamond	183	46.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus cornucopiae
32905415	32905415	PRJNA560029_S_NODE_21960_length_293_cov_3.240909_g21736_i0	PRJNA560029	21960	293	3.240909	9.49586337	Polyporaceae	5317	Fungi	Fungi	144	5.93e-39	NR	TFK91595.1	1314778	g21736	i0	69.2	6.5221843003413	91	28	93.2	0	291	19	337	427	TFK91595.1 acid protease [Polyporus arcularius HHB13444]	diamond	1911	144	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Polyporus	Polyporus arcularius

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