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

10 rows where analysis = "diamond", bioproject = "PRJEB82358" and tax_clade = "Opisthokonta"

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
26590833	26590833	PRJEB82358_P_NODE_19561_length_235_cov_13.839506_g19550_i0	PRJEB82358	19561	235	13.839506	32.5228391	Botrytis porri	87229	Fungi	Fungi	43.1	0.0144	NR	XP_038771599.1	87229	g19550	i0	42.1	0.485106382978723	38	22	48.5	0	151	38	93	130	XP_038771599.1 uncharacterized protein EAF01_005258 [Botrytis porri]	diamond	114	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Sclerotiniaceae	Botrytis	Botrytis porri
27792591	27792591	PRJEB82358_P_NODE_18164_length_244_cov_1.666667_g18153_i0	PRJEB82358	18164	244	1.666667	4.06666748	Regulus satrapa	13245	Chordata	Chordata	43.9	0.00205	NR	NWR48587.1	13245	g18153	i0	72.7	0.55327868852459	22	6	27	0	48	113	57	78	NWR48587.1 GAK5 protein [Regulus satrapa]	diamond	135	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Regulidae	Regulus	Regulus satrapa
28164076	28164076	PRJEB82358_P_NODE_22765_length_208_cov_4.288889_g22754_i0	PRJEB82358	22765	208	4.288889	8.92088912	Trametes	5324	Fungi	Fungi	45.8	0.00192	NR	KAI8982906.1	571087	g22754	i0	71.4	0.9375	21	6	30.3	0	166	104	159	179	KAI8982906.1 hypothetical protein BD414DRAFT_523443 [Trametes punicea]	diamond	195	46.2	0.991341991341991	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Trametes	Trametes punicea
29781578	29781578	PRJEB82358_P_NODE_12251_length_287_cov_1.327103_g12240_i0	PRJEB82358	12251	287	1.327103	3.80878561	Fonticula alba	691883	Root_unresolved	Root_unresolved	45.4	0.00163	NR	XP_009498235.1	691883	g12240	i0	39.8	0.867595818815331	83	42	86.8	2	260	12	21	95	XP_009498235.1 hypothetical protein H696_06214 [Fonticula alba]	diamond	249	45.4	1	Eukaryota	Opisthokonta				Rotosphaerida	Fonticulaceae	Fonticula	Fonticula alba
29932428	29932428	PRJEB82358_P_NODE_20451_length_230_cov_2.942675_g20440_i0	PRJEB82358	20451	230	2.942675	6.7681525	Hypocreales	5125	Fungi	Fungi	57.8	3.75e-8	NR	KAG8422704.1	92637	g20440	i0	79.4	4.25217391304348	34	7	44.3	0	113	12	20	53	KAG8422704.1 hypothetical protein J3459_010130 [Metarhizium acridum]	diamond	978	58.2	0.993127147766323	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Clavicipitaceae	Metarhizium	Metarhizium acridum
31202893	31202893	PRJEB82358_P_NODE_23995_length_196_cov_5.821138_g23984_i0	PRJEB82358	23995	196	5.821138	11.40943048	Paraphaeosphaeria sporulosa	1460663	Fungi	Fungi	58.5	5.46e-8	NR	KAK7177432.1	1460663	g23984	i0	53.8	0.795918367346939	52	24	79.6	0	2	157	423	474	KAK7177432.1 reverse transcriptase domain protein [Paraphaeosphaeria sporulosa]	diamond	156	58.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymosphaeriaceae	Paraphaeosphaeria	Paraphaeosphaeria sporulosa
31512499	31512499	PRJEB82358_P_NODE_17076_length_249_cov_1.272727_g17065_i0	PRJEB82358	17076	249	1.272727	3.16909023	Mycena	41247	Fungi	Fungi	130	1.99e-35	NR	KAJ7926712.1	230808	g17065	i0	73.2	2.95180722891566	82	22	98.8	0	249	4	136	217	KAJ7926712.1 (S)-2-haloacid dehalogenase IVA [Mycena leptocephala]	diamond	735	131	0.99236641221374	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena leptocephala
31583075	31583075	PRJEB82358_P_NODE_23036_length_205_cov_4.621212_g23025_i0	PRJEB82358	23036	205	4.621212	9.4734846	Smittium megazygosporum	133381	Fungi	Fungi	42.4	0.0319	NR	PVU88519.1	133381	g23025	i0	43.6	0.804878048780488	55	30	80.5	1	37	201	178	231	PVU88519.1 hypothetical protein BB560_006365 [Smittium megazygosporum]	diamond	165	42.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium megazygosporum
32025831	32025831	PRJEB82358_P_NODE_20778_length_228_cov_2.200000_g20767_i0	PRJEB82358	20778	228	2.2	5.016	Staurois parvus	386267	Chordata	Chordata	43.9	0.00152	NR	CAI9587448.1	386267	g20767	i0	59.4	0.421052631578947	32	13	42.1	0	48	143	18	49	CAI9587448.1 unnamed protein product, partial [Staurois parvus]	diamond	96	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
32532246	32532246	PRJEB82358_P_NODE_9539_length_320_cov_1.878543_g9528_i0	PRJEB82358	9539	320	1.878543	6.0113376	Erpetoichthys calabaricus	27687	Chordata	Chordata	70.5	1.18e-11	NR	XP_051791274.1	27687	g9528	i0	73.5	2.8125	49	12	45	1	254	111	156	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	900	70.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus

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