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

7 rows where analysis = "diamond", bioproject = "PRJNA641991" and tax_phylum = "Mucoromycota"

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
17195726	17195726	PRJNA641991_S_NODE_4254_length_259_cov_1.457143_g4135_i0	PRJNA641991	4254	259	1.457143	3.77400037	Fungi	4751	Fungi	Fungi	132	6.13e-34	NR	KAG2183399.1	91625	g4135	i0	81	18.9498069498069	79	15	91.5	0	1	237	488	566	KAG2183399.1 hypothetical protein INT43_006405 [Umbelopsis isabellina]	diamond	4908	132	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis isabellina
27030250	27030250	PRJNA641991_P_NODE_2962_length_175_cov_1.619048_g2921_i0	PRJNA641991	2962	175	1.619048	2.833334	Eukaryota	2759	Fungi	Fungi	94	2.45e-21	NR	KAG9295965.1	50956	g2921	i0	82.1	29.5371428571429	56	10	96	0	1	168	161	216	KAG9295965.1 hypothetical protein G9A89_011817 [Geosiphon pyriformis]	diamond	5169	94.7	0.992608236536431	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Geosiphonaceae	Geosiphon	Geosiphon pyriformis
27429149	27429149	PRJNA641991_S_NODE_13963_length_163_cov_0.894737_g13844_i0	PRJNA641991	13963	163	0.894737	1.45842131	Jimgerdemannia flammicorona	994334	Fungi	Fungi	53.9	1.44e-6	NR	RUP51149.1	994334	g13844	i0	58.5	1.50920245398773	41	17	75.5	0	1	123	456	496	RUP51149.1 glucose-6-phosphate 1-dehydrogenase [Jimgerdemannia flammicorona]	diamond	246	53.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales	Endogonaceae	Jimgerdemannia	Jimgerdemannia flammicorona
28798670	28798670	PRJNA641991_S_NODE_9907_length_181_cov_0.954545_g9788_i0	PRJNA641991	9907	181	0.954545	1.72772645	Fungi	4751	Fungi	Fungi	58.2	4.57e-8	NR	KAF9934996.1	979765	g9788	i0	55.9	12.8453038674033	59	21	92.8	2	14	181	92	148	KAF9934996.1 hypothetical protein FBU30_009419 [Linnemannia zychae]	diamond	2325	58.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Linnemannia	Linnemannia zychae
28956968	28956968	PRJNA641991_S_NODE_7128_length_207_cov_1.291139_g7009_i0	PRJNA641991	7128	207	1.291139	2.67265773	Fungi	4751	Fungi	Fungi	99	2.12e-24	NR	KAG2171704.1	91625	g7009	i0	71.9	6.85507246376812	57	16	82.6	0	201	31	93	149	KAG2171704.1 hypothetical protein INT43_008084 [Umbelopsis isabellina]	diamond	1419	99	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis isabellina
29197176	29197176	PRJNA641991_S_NODE_11749_length_168_cov_1.285714_g11630_i0	PRJNA641991	11749	168	1.285714	2.15999952	Acaulospora colombiana	27376	Fungi	Fungi	41.6	0.0116	NR	CAG8500109.1	27376	g11630	i0	51.3	1.5	39	19	69.6	0	166	50	64	102	CAG8500109.1 10032_t:CDS:2 [Acaulospora colombiana]	diamond	252	41.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Acaulosporaceae	Acaulospora	Acaulospora colombiana
32559995	32559995	PRJNA641991_S_NODE_5339_length_234_cov_1.027027_g5220_i0	PRJNA641991	5339	234	1.027027	2.40324318	Fungi	4751	Fungi	Fungi	47.8	4.66e-4	NR	CAG8621826.1	60492	g5220	i0	40.4	3.53846153846154	52	31	66.7	0	234	79	53	104	CAG8621826.1 5098_t:CDS:2 [Racocetra fulgida]	diamond	828	47.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Racocetra	Racocetra fulgida

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