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

7 rows where analysis = "diamond", bioproject = "PRJNA807836" and tax_phylum = "Ascomycota"

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
7185617	7185617	PRJNA807836_S_NODE_546_length_1833_cov_10.002841_g503_i0	PRJNA807836	546	1833	10.002841	183.35207553	Lambiella insularis	1397036	Fungi	Fungi	447	2.36e-149	NR	MCJ1475766.1	1397036	g503	i0	56.2	1.33387888707038	411	170	66	5	1668	460	14	422	MCJ1475766.1 hypothetical protein [Lambiella insularis]	diamond	2445	447	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Baeomycetales	Xylographaceae	Lambiella	Lambiella insularis
28917178	28917178	PRJNA807836_S_NODE_28308_length_248_cov_0.880000_g28032_i0	PRJNA807836	28308	248	0.88	2.1824	Ophiocordyceps sinensis	72228	Fungi	Fungi	71.2	3.46e-12	NR	KAF4509781.1	72228	g28032	i0	88.9	0.435483870967742	36	4	43.5	0	141	34	1	36	KAF4509781.1 hypothetical protein G6O67_003919 [Ophiocordyceps sinensis]	diamond	108	71.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Ophiocordyceps	Ophiocordyceps sinensis
28949228	28949228	PRJNA807836_S_NODE_28128_length_249_cov_0.869318_g27852_i0	PRJNA807836	28128	249	0.869318	2.16460182	Cladosporium halotolerans	1052096	Fungi	Fungi	171	5.74e-50	NR	XP_069229731.1	1052096	g27852	i0	95.1	0.987951807228916	82	4	98.8	0	3	248	60	141	XP_069229731.1 uncharacterized protein WHR41_04503 [Cladosporium halotolerans]	diamond	246	171	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
29043882	29043882	PRJNA807836_S_NODE_20768_length_299_cov_1.159292_g20492_i0	PRJNA807836	20768	299	1.159292	3.46628308	Ophiocordyceps sinensis	72228	Fungi	Fungi	141	1.3899999999999999e-40	NR	KAF4504440.1	72228	g20492	i0	96.1	0.762541806020067	76	3	76.3	0	230	3	1	76	KAF4504440.1 hypothetical protein G6O67_007890 [Ophiocordyceps sinensis]	diamond	228	141	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Ophiocordyceps	Ophiocordyceps sinensis
29264561	29264561	PRJNA807836_S_NODE_3449_length_930_cov_4.801634_g3257_i0	PRJNA807836	3449	930	4.801634	44.6551962	Ptychographa xylographoides	223409	Fungi	Fungi	285	3.6599999999999997e-90	NR	MCJ1409372.1	223409	g3257	i0	53.2	6.12903225806452	278	117	85.8	7	3	800	138	414	MCJ1409372.1 hypothetical protein [Ptychographa xylographoides]	diamond	5700	285	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Baeomycetales	Xylographaceae	Ptychographa	Ptychographa xylographoides
29738080	29738080	PRJNA807836_S_NODE_29590_length_245_cov_0.895349_g29314_i0	PRJNA807836	29590	245	0.895349	2.19360505	Ophiocordyceps sinensis	72228	Fungi	Fungi	174	1.4e-50	NR	KAF4509043.1	72228	g29314	i0	100	0.991836734693878	81	0	99.2	0	243	1	129	209	KAF4509043.1 hypothetical protein G6O67_005353 [Ophiocordyceps sinensis]	diamond	243	174	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Ophiocordyceps	Ophiocordyceps sinensis
30812442	30812442	PRJNA807836_S_NODE_27774_length_250_cov_0.870056_g27498_i0	PRJNA807836	27774	250	0.870056	2.17514	Ophiocordyceps sinensis	72228	Fungi	Fungi	131	1.71e-33	NR	KAF4510699.1	72228	g27498	i0	74.7	0.996	83	3	99.6	1	249	1	244	308	KAF4510699.1 hypothetical protein G6O67_002573 [Ophiocordyceps sinensis]	diamond	249	131	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Ophiocordyceps	Ophiocordyceps sinensis

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