metadata: contig_metadata: 5 rows where bioproject = "PRJNA801875", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJNA801875", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"

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
8874900	8874900	PRJNA801875_P_NODE_727_length_500_cov_2.963441_g625_i0	PRJNA801875	727	500	2.963441	14.817205	Eukaryota	2759	Fungi	Fungi	213	1.55e-66	NR	KAJ3366916.1	64504	g625	i0	72.8	4.794	147	40	88.2	0	496	56	45	191	KAJ3366916.1 40S ribosomal protein S6 [Allomyces arbusculus]	diamond	2397	213	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
26873490	26873490	PRJNA801875_P_NODE_861_length_450_cov_2.409639_g759_i0	PRJNA801875	861	450	2.409639	10.8433755	Fungi	4751	Fungi	Fungi	146	9.619999999999998e-42	NR	KAI9159512.1	1313167	g759	i0	57	6.57333333333333	149	57	96	2	449	18	1	147	KAI9159512.1 60S ribosomal protein L24 [Blastocladiella emersonii ATCC 22665]	diamond	2958	146	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
30022728	30022728	PRJNA801875_P_NODE_1031_length_403_cov_2.964674_g928_i0	PRJNA801875	1031	403	2.964674	11.94763622	Allomyces javanicus	64505	Fungi	Fungi	87.4	4.91e-17	NR	KAJ3366950.1	64505	g928	i0	42.5	1.8833746898263	87	42	64.8	1	401	141	85	163	KAJ3366950.1 Strongly-conserved Zn-finger binding protein (TFIIIA) [Allomyces javanicus]	diamond	759	87.4	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces javanicus
31168654	31168654	PRJNA801875_P_NODE_635_length_543_cov_1.940945_g533_i0	PRJNA801875	635	543	1.940945	10.53933135	Fungi	4751	Fungi	Fungi	126	9.31e-31	NR	KAI9137536.1	1500003	g533	i0	52.6	3.21546961325967	133	59	71.3	1	539	153	275	407	KAI9137536.1 hypothetical protein BKA69DRAFT_1097502 [Paraphysoderma sedebokerense]	diamond	1746	126	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
31286300	31286300	PRJNA801875_P_NODE_2115_length_245_cov_1.823810_g2012_i0	PRJNA801875	2115	245	1.82381	4.4683345	Allomyces macrogynus ATCC 38327	578462	Fungi	Fungi	113	8.139999999999998e-30	NR	KNE63417.1	578462	g2012	i0	72.6	4.54285714285714	73	20	89.4	0	242	24	1	73	KNE63417.1 hypothetical protein AMAG_08547 [Allomyces macrogynus ATCC 38327]	diamond	1113	113	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus

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