metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA339266" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA339266" 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
17647469	17647469	PRJNA339266_S_NODE_1274_length_300_cov_13.205323_g1263_i0	PRJNA339266	1274	300	13.205323	39.615969	Cylindrobasidium torrendii FP15	394432	Fungi	Fungi	152	3.22e-42	NR	KIY64996.1	1314674	g1263	i0	93.8	0.8	80	5	80	0	300	61	315	394	KIY64996.1 DnaJ-domain-containing protein [Cylindrobasidium torrendii FP15055 ss-10]	diamond	240	152	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Cylindrobasidium	Cylindrobasidium torrendii
27534314	27534314	PRJNA339266_S_NODE_19703_length_150_cov_5.115044_g19692_i0	PRJNA339266	19703	150	5.115044	7.672566	Agaricomycetes	155619	Fungi	Fungi	51.6	1.9e-6	NR	XP_007395572.1	650164	g19692	i0	85.7	2.96	28	4	56	0	1	84	48	75	XP_007395572.1 uncharacterized protein PHACADRAFT_208754 [Phanerochaete carnosa HHB-10118-sp]	diamond	444	52	0.992307692307692	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Phanerochaetaceae	Phanerochaete	Phanerochaete carnosa
29348442	29348442	PRJNA339266_S_NODE_15909_length_159_cov_2.377049_g15898_i0	PRJNA339266	15909	159	2.377049	3.77950791	Candolleomyces aberdarensis	2316362	Fungi	Fungi	68.6	9.14e-12	NR	RXW16985.1	2316362	g15898	i0	70.7	3.20754716981132	41	12	77.4	0	11	133	397	437	RXW16985.1 hypothetical protein EST38_g8869 [Candolleomyces aberdarensis]	diamond	510	68.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Psathyrellaceae	Candolleomyces	Candolleomyces aberdarensis
30137481	30137481	PRJNA339266_P_NODE_3472_length_199_cov_84.049383_g3442_i0	PRJNA339266	3472	199	84.049383	167.25827217	Phaffia rhodozyma	264483	Fungi	Fungi	62.8	1.79e-9	NR	CED82426.1	264483	g3442	i0	67.7	5.23115577889447	62	15	85.9	1	172	2	313	374	CED82426.1 agc ndr protein kinase [Phaffia rhodozyma]	diamond	1041	62.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
31148480	31148480	PRJNA339266_S_NODE_10875_length_175_cov_7.731884_g10864_i0	PRJNA339266	10875	175	7.731884	13.530797	Austropuccinia psidii	181123	Fungi	Fungi	43.1	0.00449	NR	MBW0562822.1	1389203	g10864	i0	40	0.685714285714286	40	24	68.6	0	124	5	55	94	MBW0562822.1 hypothetical protein [Austropuccinia psidii MF-1]	diamond	120	43.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Sphaerophragmiaceae	Austropuccinia	Austropuccinia psidii
31939498	31939498	PRJNA339266_S_NODE_5037_length_214_cov_2.615819_g5026_i0	PRJNA339266	5037	214	2.615819	5.59785266	Lentinula raphanica	153919	Fungi	Fungi	44.3	0.00714	NR	KAJ3827713.1	153919	g5026	i0	58.5	1.06542056074766	41	16	56.1	1	72	191	37	77	KAJ3827713.1 acyltransferase ChoActase/COT/CPT [Lentinula raphanica]	diamond	228	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Lentinula	Lentinula raphanica
32034577	32034577	PRJNA339266_S_NODE_6838_length_198_cov_2.012422_g6827_i0	PRJNA339266	6838	198	2.012422	3.98459556	Coprinopsis cinerea AmutBmut pab1-1	1132390	Fungi	Fungi	88.6	1.45e-18	NR	KAG2023262.1	1132390	g6827	i0	66.2	0.984848484848485	65	22	98.5	0	197	3	632	696	KAG2023262.1 hypothetical protein CC2G_000935 [Coprinopsis cinerea AmutBmut pab1-1]	diamond	195	88.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Psathyrellaceae	Coprinopsis	Coprinopsis cinerea
32178571	32178571	PRJNA339266_S_NODE_14998_length_161_cov_7.943548_g14987_i0	PRJNA339266	14998	161	7.943548	12.78911228	Sporobolomyces	5429	Fungi	Fungi	50.8	2.2e-6	NR	GAA6021474.1	183961	g14987	i0	77.8	1.04347826086957	27	6	50.3	0	161	81	69	95	GAA6021474.1 hypothetical protein JCM11491_006508 [Sporobolomyces phaffii]	diamond	168	51.2	0.9921875	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces phaffii
32319650	32319650	PRJNA339266_P_NODE_4179_length_191_cov_4.493506_g4149_i0	PRJNA339266	4179	191	4.493506	8.58259646	Rhodotorula sp. JG-1b	1305733	Fungi	Fungi	70.5	1.6e-12	NR	KWU46170.1	1305733	g4149	i0	94.6	0.581151832460733	37	2	58.1	0	3	113	49	85	KWU46170.1 hypothetical protein RHOSPDRAFT_32162 [Rhodotorula sp. JG-1b]	diamond	111	70.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula sp. JG-1b

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