metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA642647" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA642647" 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
26764717	26764717	PRJNA642647_P_NODE_481_length_500_cov_11.840173_g432_i0	PRJNA642647	481	500	11.840173	59.200865	Thoreauomyces humboldtii	1396496	Fungi	Fungi	94.7	3.59e-19	NR	KAJ3008852.1	1396496	g432	i0	42.6	0.774	129	73	76.8	1	7	390	137	265	KAJ3008852.1 hypothetical protein HKX48_008314 [Thoreauomyces humboldtii]	diamond	387	94.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Thoreauomyces	Thoreauomyces humboldtii
27776394	27776394	PRJNA642647_P_NODE_1424_length_292_cov_2.890196_g1374_i0	PRJNA642647	1424	292	2.890196	8.43937232	Brugia pahangi	6280	Nematoda	Nematoda	46.6	0.0028	NR	VDN81525.1	6280	g1374	i0	48.3	2.20890410958904	60	25	60.6	2	285	109	278	332	VDN81525.1 unnamed protein product [Brugia pahangi]	diamond	645	46.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia pahangi
28028932	28028932	PRJNA642647_P_NODE_4465_length_172_cov_1.103704_g4415_i0	PRJNA642647	4465	172	1.103704	1.89837088	Podila horticola	311239	Fungi	Fungi	77.8	1.41e-15	NR	KAF9306318.1	311239	g4415	i0	58.9	1.93604651162791	56	23	97.7	0	4	171	188	243	KAF9306318.1 hypothetical protein BG003_001055, partial [Podila horticola]	diamond	333	77.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Podila	Podila horticola
28186440	28186440	PRJNA642647_P_NODE_986_length_356_cov_2.053292_g936_i0	PRJNA642647	986	356	2.053292	7.30971952	Chlorociboria aeruginascens	296797	Fungi	Fungi	47.4	0.00336	NR	TAQ83163.1	296797	g936	i0	65.6	0.497191011235955	32	11	27	0	322	227	2215	2246	TAQ83163.1 hypothetical protein B7494_g8512 [Chlorociboria aeruginascens]	diamond	177	47.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Chlorociboriaceae	Chlorociboria	Chlorociboria aeruginascens
28407769	28407769	PRJNA642647_P_NODE_5966_length_156_cov_1.747899_g5916_i0	PRJNA642647	5966	156	1.747899	2.72672244	[Candida] jaroonii	467808	Fungi	Fungi	42.7	0.00429	NR	CAH6723999.1	467808	g5916	i0	68.6	0.673076923076923	35	6	57.7	1	33	122	14	48	CAH6723999.1 protein Tar1p [[Candida] jaroonii]	diamond	105	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Yamadazyma	[Candida] jaroonii
28483182	28483182	PRJNA642647_P_NODE_1426_length_292_cov_2.180392_g1376_i0	PRJNA642647	1426	292	2.180392	6.36674464	Ascomycota	4890	Fungi	Fungi	47.8	5.41e-4	NR	KAL2011645.1	5088	g1376	i0	43	2.57876712328767	79	36	71.9	3	214	5	73	151	KAL2011645.1 hypothetical protein VTN00DRAFT_4363 [Thermoascus crustaceus]	diamond	753	48.1	0.993762993762994	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Thermoascaceae	Thermoascus	Thermoascus crustaceus
28483184	28483184	PRJNA642647_P_NODE_6306_length_152_cov_2.591304_g6256_i0	PRJNA642647	6306	152	2.591304	3.93878208	root	1	Root_unresolved	Root_unresolved	48.9	7.12e-5	NR	QKY88654.1	271932	g6256	i0	46	8.23026315789474	50	23	90.8	1	7	144	231	280	QKY88654.1 matrix metalloprotease 13 [Tetracapsuloides bryosalmonae]	diamond	1251	49.3	0.991886409736308	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Malacovalvulida	Saccosporidae	Tetracapsuloides	Tetracapsuloides bryosalmonae
28597274	28597274	PRJNA642647_P_NODE_4507_length_171_cov_1.902985_g4457_i0	PRJNA642647	4507	171	1.902985	3.25410435	Aspergillus steynii IBT 23	306088	Fungi	Fungi	55.1	9.04e-8	NR	PLB42753.1	1392250	g4457	i0	69.7	4.63157894736842	33	10	57.9	0	128	30	29	61	PLB42753.1 hypothetical protein P170DRAFT_493811 [Aspergillus steynii IBT 23096]	diamond	792	55.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus steynii
29146566	29146566	PRJNA642647_P_NODE_6429_length_151_cov_3.350877_g6379_i0	PRJNA642647	6429	151	3.350877	5.05982427	Rodentia	9989	Chordata	Chordata	53.9	1.21e-6	NR	EGW07491.1	10029	g6379	i0	85.7	7.47019867549669	28	4	55.6	0	5	88	406	433	EGW07491.1 Inositol 1,4,5-trisphosphate receptor type 2 [Cricetulus griseus]	diamond	1128	53.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Cricetulus	Cricetulus griseus
30997625	30997625	PRJNA642647_P_NODE_5334_length_165_cov_1.054688_g5284_i0	PRJNA642647	5334	165	1.054688	1.7402352	Pseudogymnoascus sp. VKM F-4281 (FW-2241)	1420906	Fungi	Fungi	50.4	2.55e-5	NR	KFY19110.1	1420906	g5284	i0	44.2	1.38181818181818	43	24	78.2	0	4	132	1454	1496	KFY19110.1 hypothetical protein V493_08138, partial [Pseudogymnoascus sp. VKM F-4281 (FW-2241)]	diamond	228	50.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Thelebolales	Thelebolaceae	Pseudogymnoascus	Pseudogymnoascus sp. VKM F-4281 (FW-2241)
31060984	31060984	PRJNA642647_P_NODE_4255_length_175_cov_2.210145_g4205_i0	PRJNA642647	4255	175	2.210145	3.86775375	Actinostola sp. cb2	3060491	Cnidaria	other_Eukaryota	47.4	3.37e-4	NR	KAK3748527.1	3060491	g4205	i0	56.3	0.548571428571429	32	14	54.9	0	3	98	474	505	KAK3748527.1 hypothetical protein QZH41_012374 [Actinostola sp. cb2023]	diamond	96	47.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actinostolidae	Actinostola	Actinostola sp. cb2023
31389314	31389314	PRJNA642647_P_NODE_1236_length_315_cov_2.996403_g1186_i0	PRJNA642647	1236	315	2.996403	9.43866945	Metazoa	33208	Arthropoda	Arthropoda	45.8	0.00668	NR	XP_050359582.1	171585	g1186	i0	28.6	4.22857142857143	91	40	71.4	4	296	72	214	295	XP_050359582.1 myoneurin-like isoform X2 [Nymphalis io]	diamond	1332	46.2	0.991341991341991	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Nymphalis	Nymphalis io
31389315	31389315	PRJNA642647_P_NODE_5056_length_166_cov_2.914729_g5006_i0	PRJNA642647	5056	166	2.914729	4.83845014	Agaricales	5338	Fungi	Fungi	49.7	4.56e-5	NR	KAJ7601139.1	1033242	g5006	i0	84	1.35542168674699	25	4	45.2	0	164	90	495	519	KAJ7601139.1 thiamine diphosphate-binding protein [Mycena floridula]	diamond	225	50.1	0.992015968063872	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena floridula
31452574	31452574	PRJNA642647_P_NODE_3156_length_198_cov_1.583851_g3106_i0	PRJNA642647	3156	198	1.583851	3.13602498	Sordariomycetes	147550	Fungi	Fungi	61.6	4.38e-9	NR	KAL2268291.1	72144	g3106	i0	54.5	5	55	25	83.3	0	12	176	371	425	KAL2268291.1 hypothetical protein VTJ83DRAFT_3137 [Remersonia thermophila]	diamond	990	61.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales		Remersonia	Remersonia thermophila
32736580	32736580	PRJNA642647_P_NODE_2520_length_218_cov_1.259669_g2470_i0	PRJNA642647	2520	218	1.259669	2.74607842	Phenoliferia sp. Uapishka_3	3038894	Fungi	Fungi	42.4	0.0364	NR	KAK4701127.1	3038894	g2470	i0	52.2	0.63302752293578	46	17	63.3	1	197	60	234	274	KAK4701127.1 hypothetical protein P7C70_g5108, partial [Phenoliferia sp. Uapishka_3]	diamond	138	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Kriegeriales	Kriegeriaceae	Phenoliferia	Phenoliferia sp. Uapishka_3

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