metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA385396" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA385396" 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
10610926	10610926	PRJNA385396_P_NODE_6609_length_331_cov_1.193798_g6517_i0	PRJNA385396	6609	331	1.193798	3.95147138	Fungi	4751	Fungi	Fungi	149	2.02e-43	NR	KAF0441187.1	4874	g6517	i0	70.4	93.1722054380665	108	31	97.9	1	8	331	6	112	KAF0441187.1 60S ribosomal protein L11 [Gigaspora margarita]	diamond	30840	149	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
13160767	13160767	PRJNA385396_P_NODE_2631_length_466_cov_1.106870_g2539_i0	PRJNA385396	2631	466	1.10687	5.1580142	Fungi	4751	Fungi	Fungi	70.5	1.82e-12	NR	XP_051400205.1	101107	g2539	i0	61.5	2.9549356223176	65	24	41.2	1	423	232	1	65	XP_051400205.1 60S acidic ribosomal protein P2 [Halteromyces radiatus]	diamond	1377	70.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
14435908	14435908	PRJNA385396_P_NODE_5772_length_347_cov_0.843066_g5680_i0	PRJNA385396	5772	347	0.843066	2.92543902	Fungi	4751	Fungi	Fungi	190	1.22e-57	NR	RCH85568.1	4846	g5680	i0	81.7	60.5014409221902	115	21	99.4	0	347	3	156	270	RCH85568.1 atp2, beta subunit of the F1 sector of mitochondrial F1F0 ATP synthase, partial [Rhizopus stolonifer]	diamond	20994	191	0.994764397905759	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus stolonifer
17654124	17654124	PRJNA385396_P_NODE_15174_length_249_cov_0.875000_g15082_i0	PRJNA385396	15174	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	92.8	5.99e-20	NR	CAG8432841.1	1213867	g15082	i0	63.1	15.9518072289157	65	24	78.3	0	216	22	325	389	CAG8432841.1 7329_t:CDS:2 [Diversispora eburnea]	diamond	3972	93.2	0.995708154506438	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Diversisporaceae	Diversispora	Diversispora eburnea
19532687	19532687	PRJNA385396_P_NODE_14836_length_249_cov_1.556818_g14744_i0	PRJNA385396	14836	249	1.556818	3.87647682	Fungi	4751	Fungi	Fungi	171	1.5699999999999998e-47	NR	CAG8503170.1	94023	g14744	i0	93.9	54.3373493975904	82	5	98.8	0	3	248	603	684	CAG8503170.1 5634_t:CDS:10 [Acaulospora morrowiae]	diamond	13530	172	0.994186046511628	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Acaulosporaceae	Acaulospora	Acaulospora morrowiae
27201443	27201443	PRJNA385396_P_NODE_21182_length_241_cov_0.916667_g21090_i0	PRJNA385396	21182	241	0.916667	2.20916747	Calcarisporiella thermophila	911321	Fungi	Fungi	68.2	4.06e-11	NR	XP_069250811.1	911321	g21090	i0	40	1.9792531120332	80	40	97.1	2	7	240	722	795	XP_069250811.1 uncharacterized protein VTP21DRAFT_2234 [Calcarisporiella thermophila]	diamond	477	68.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
27534471	27534471	PRJNA385396_P_NODE_13883_length_251_cov_0.865169_g13791_i0	PRJNA385396	13883	251	0.865169	2.17157419	Mucoromycota	1913637	Fungi	Fungi	90.1	2.79e-19	NR	KAF9387825.1	78898	g13791	i0	58.6	12.5139442231076	70	29	83.7	0	212	3	153	222	KAF9387825.1 Nucleolar GTP-binding protein 1 [Podila verticillata]	diamond	3141	90.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Podila	Podila verticillata
29018713	29018713	PRJNA385396_P_NODE_5208_length_359_cov_1.045455_g5116_i0	PRJNA385396	5208	359	1.045455	3.75318345	Opisthokonta	33154	Fungi	Fungi	49.3	1.57e-4	NR	ORZ04275.1	90262	g5116	i0	41.4	3.01671309192201	70	36	58.5	2	4	213	2	66	ORZ04275.1 ribosomal protein L28e [Absidia repens]	diamond	1083	49.7	0.991951710261569	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia repens
30959968	30959968	PRJNA385396_P_NODE_18434_length_245_cov_0.895349_g18342_i0	PRJNA385396	18434	245	0.895349	2.19360505	Rhizophagus irregularis DAOM 197198w	1432141	Fungi	Fungi	46.2	0.00223	NR	EXX70516.1	1432141	g18342	i0	40.8	1.40816326530612	49	28	60	1	194	48	327	374	EXX70516.1 Cdc15p [Rhizophagus irregularis DAOM 197198w]	diamond	345	46.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
32431749	32431749	PRJNA385396_P_NODE_9959_length_285_cov_1.132075_g9867_i0	PRJNA385396	9959	285	1.132075	3.22641375	root	1	Root_unresolved	Root_unresolved	112	1.24e-27	NR	XP_021882283.1	64571	g9867	i0	58.2	8.77894736842105	91	31	95.8	2	1	273	3	86	XP_021882283.1 glyceraldehyde 3-phosphate dehydrogenase [Lobosporangium transversale]	diamond	2502	112	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale

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