metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA657860" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA657860" and tax_kingdom = "Fungi"

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
27460733	27460733	PRJNA657860_P_NODE_3503_length_157_cov_1.541667_g3447_i0	PRJNA657860	3503	157	1.541667	2.42041719	Testicularia cyperi	1882483	Fungi	Fungi	42.4	0.00997	NR	PWZ00696.1	1882483	g3447	i0	41.2	0.974522292993631	51	30	97.5	0	1	153	80	130	PWZ00696.1 hypothetical protein BCV70DRAFT_99658 [Testicularia cyperi]	diamond	153	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Anthracoideaceae	Testicularia	Testicularia cyperi
28092021	28092021	PRJNA657860_P_NODE_1545_length_259_cov_2.567568_g1489_i0	PRJNA657860	1545	259	2.567568	6.65000112	Kappamyces sp. JEL	2040833	Fungi	Fungi	99	7.83e-22	NR	KAJ3301963.1	2724216	g1489	i0	66.2	0.752895752895753	65	22	75.3	0	256	62	513	577	KAJ3301963.1 Mitochondrial 10-formyltetrahydrofolate dehydrogenase [Kappamyces sp. JEL0829]	diamond	195	99	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales	Kappamycetaceae	Kappamyces	Kappamyces sp. JEL0829
29335690	29335690	PRJNA657860_P_NODE_489_length_498_cov_1.661605_g434_i0	PRJNA657860	489	498	1.661605	8.2747929	root	1	Root_unresolved	Root_unresolved	269	6.37e-88	NR	KAI9026238.1	82268	g434	i0	80.5	3.71084337349398	154	30	92.8	0	5	466	154	307	KAI9026238.1 putative mitochondrial ADP/ATP translocase [Hyaloraphidium curvatum]	diamond	1848	271	0.992619926199262	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum
30492168	30492168	PRJNA657860_P_NODE_3273_length_163_cov_1.182540_g3217_i0	PRJNA657860	3273	163	1.18254	1.9275402	Malassezia arunalokei	1514897	Fungi	Fungi	96.7	1.24e-21	NR	WFD16437.1	1514897	g3217	i0	98.1	0.975460122699387	53	1	97.5	0	3	161	2519	2571	WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei]	diamond	159	96.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
30934555	30934555	PRJNA657860_P_NODE_2074_length_211_cov_1.270115_g2018_i0	PRJNA657860	2074	211	1.270115	2.67994265	Malassezia arunalokei	1514897	Fungi	Fungi	91.7	1.44e-19	NR	WFD16437.1	1514897	g2018	i0	71	0.981042654028436	69	20	98.1	0	209	3	935	1003	WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei]	diamond	207	91.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
31452600	31452600	PRJNA657860_P_NODE_516_length_486_cov_1.966592_g460_i0	PRJNA657860	516	486	1.966592	9.55763712	Chytridiomycetes	451435	Fungi	Fungi	203	6.63e-62	NR	KAI8811600.1	109936	g460	i0	75.8	2.42592592592593	128	30	79	1	102	485	7	133	KAI8811600.1 putative mitochondrial ADP/ATP translocase [Cladochytrium replicatum]	diamond	1179	203	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Cladochytriales	Cladochytriaceae	Cladochytrium	Cladochytrium replicatum
32168019	32168019	PRJNA657860_P_NODE_1378_length_278_cov_1.535270_g1322_i0	PRJNA657860	1378	278	1.53527	4.2680506	Lentinus brumalis	2498619	Fungi	Fungi	41.6	0.0194	NR	RDX47954.1	2498619	g1322	i0	44.1	0.636690647482014	59	32	62.6	1	272	99	4	62	RDX47954.1 hypothetical protein OH76DRAFT_1327085, partial [Lentinus brumalis]	diamond	177	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Lentinus	Lentinus brumalis

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