metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA849822" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA849822" and tax_phylum = "Chytridiomycota"

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
838657	838657	PRJNA849822_P_NODE_35341_length_251_cov_0.876404_g35167_i0	PRJNA849822	35341	251	0.876404	2.19977404	Polychytrium aggregatum	110093	Fungi	Fungi	126	1.32e-24	NTclustered	gi\|2432145248\|ref\|XM_053115910.1\|	110093	g35167	i0	80.588	1.14741035856574	170	28	67	5	6	172	10120	9953	Polychytrium aggregatum fatty acid synthase (BJ171DRAFT_82549), mRNA	blastn	288	126	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
838703	838703	PRJNA849822_P_NODE_40821_length_245_cov_0.872093_g40647_i0	PRJNA849822	40821	245	0.872093	2.13662785	Fimicolochytrium jonesii	1396493	Fungi	Fungi	54.7	0.006	NTclustered	gi\|2432086769\|ref\|XM_053073324.1\|	1396493	g40647	i0	96.875	0.587755102040816	32	1	13	0	1	32	2782	2813	Fimicolochytrium jonesii uncharacterized protein (EV422DRAFT_579699), mRNA	blastn	144	54.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
2114082	2114082	PRJNA849822_P_NODE_3442_length_874_cov_2.660424_g3286_i0	PRJNA849822	3442	874	2.660424	23.25210576	Polychytrium aggregatum	110093	Fungi	Fungi	414	9.76e-111	NTclustered	gi\|2432158824\|ref\|XM_053111736.1\|	110093	g3286	i0	79.965	60.0091533180778	579	102	65	12	251	822	745	174	Polychytrium aggregatum inorganic pyrophosphatase (BJ171DRAFT_513126), mRNA	blastn	52448	414	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
2114115	2114115	PRJNA849822_P_NODE_3862_length_818_cov_3.175839_g3703_i0	PRJNA849822	3862	818	3.175839	25.97836302	Polychytrium aggregatum	110093	Fungi	Fungi	435	6.99e-117	NTclustered	gi\|2432156890\|ref\|XM_053107738.1\|	110093	g3703	i0	77.628	70.421760391198	742	148	90	18	81	813	733	1	Polychytrium aggregatum 60S ribosomal protein L2 (BJ171DRAFT_425809), partial mRNA	blastn	57605	435	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
3389491	3389491	PRJNA849822_P_NODE_6223_length_623_cov_5.912727_g6054_i0	PRJNA849822	6223	623	5.912727	36.83628921	Spizellomyces punctatus	109760	Fungi	Fungi	252	5.68e-62	NTclustered	gi\|1026980085\|ref\|XM_016752373.1\|	645134	g6054	i0	80.606	6.17174959871589	330	61	53	3	184	512	181	508	Spizellomyces punctatus DAOM BR117 40S ribosomal protein S15 (SPPG_04127), mRNA	blastn	3845	252	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus
4667250	4667250	PRJNA849822_P_NODE_864_length_1671_cov_4.030038_g791_i0	PRJNA849822	864	1671	4.030038	67.34193498	Polychytrium aggregatum	110093	Fungi	Fungi	719	0	NTclustered	gi\|2432171462\|ref\|XM_053112561.1\|	110093	g791	i0	75.878	86.2728904847397	1480	317	88	29	209	1671	2129	673	Polychytrium aggregatum heat shock protein 90 kDa (BJ171DRAFT_524257), mRNA	blastn	144162	719	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
7611529	7611529	PRJNA849822_P_NODE_17326_length_348_cov_2.418182_g17152_i0	PRJNA849822	17326	348	2.418182	8.41527336	Eukaryota	2759	Fungi	Fungi	228	5.0999999999999985e-55	NTclustered	gi\|2432152064\|ref\|XM_053105682.1\|	110093	g17152	i0	79.228	63.1781609195402	337	62	96	7	16	348	115	447	Polychytrium aggregatum ribosomal protein L10e/L16 (BJ171DRAFT_137240), mRNA	blastn	21986	228	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
9766744	9766744	PRJNA849822_P_NODE_35568_length_251_cov_0.876404_g35394_i0	PRJNA849822	35568	251	0.876404	2.19977404	Polychytrium aggregatum	110093	Fungi	Fungi	171	6.02e-38	NTclustered	gi\|2432131152\|ref\|XM_053108251.1\|	110093	g35394	i0	78.968	98.4581673306773	252	51	100	2	1	251	675	925	Polychytrium aggregatum putative succinyl-CoA synthetase alpha chain, gdp-forming (BJ171DRAFT_454445), mRNA	blastn	24713	171	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
12317652	12317652	PRJNA849822_P_NODE_10390_length_462_cov_3.043702_g10217_i0	PRJNA849822	10390	462	3.043702	14.06190324	Polychytrium aggregatum	110093	Fungi	Fungi	357	8.489999999999997e-94	NTclustered	gi\|2432146664\|ref\|XM_053113161.1\|	110093	g10217	i0	83.206	81.517316017316	393	62	85	4	58	448	391	1	Polychytrium aggregatum 40S ribosomal protein S22-A (BJ171DRAFT_558627), partial mRNA	blastn	37661	357	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
12317821	12317821	PRJNA849822_P_NODE_32250_length_257_cov_2.728261_g32076_i0	PRJNA849822	32250	257	2.728261	7.01163077	Synchytrium sp.	1971732	Fungi	Fungi	93.5	1.38e-14	NTclustered	gi\|1168020523\|gb\|KY800404.1\|	1971732	g32076	i0	83.168	0.392996108949416	101	17	39	0	155	255	906	1006	Synchytrium sp. voucher BPI 893319 large subunit ribosomal RNA gene, partial sequence	blastn	101	93.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium sp.
16141251	16141251	PRJNA849822_P_NODE_14713_length_380_cov_1.198697_g14539_i0	PRJNA849822	14713	380	1.198697	4.5550486	Neocallimastix frontalis	4757	Fungi	Fungi	206	2.63e-48	NTclustered	gi\|387233100\|gb\|JN033860.1\|	4757	g14539	i0	80.576	21.1842105263158	278	45	72	8	8	282	673	944	Neocallimastix frontalis strain PMA02 aconitate hydratase (AH1) mRNA, complete cds	blastn	8050	206	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Neocallimastix	Neocallimastix frontalis
17810980	17810980	PRJNA849822_P_NODE_40674_length_245_cov_0.906977_g40500_i0	PRJNA849822	40674	245	0.906977	2.22209365	Fungi	4751	Fungi	Fungi	171	5.85e-38	NTclustered	gi\|2432172390\|ref\|XM_053112626.1\|	110093	g40500	i0	90.076	32.9020408163265	131	13	53	0	115	245	1393	1263	Polychytrium aggregatum chaperonin Cpn60/TCP-1 family (BJ171DRAFT_525041), mRNA	blastn	8061	172	0.994186046511628	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
21240532	21240532	PRJNA849822_P_NODE_10077_length_471_cov_2.208543_g9904_i0	PRJNA849822	10077	471	2.208543	10.40223753	Polychytrium aggregatum	110093	Fungi	Fungi	357	8.669999999999997e-94	NTclustered	gi\|2432155690\|ref\|XM_053111537.1\|	110093	g9904	i0	80.819	17.2845010615711	464	81	98	8	9	468	765	1224	Polychytrium aggregatum mitochondrial carrier domain-containing protein (BJ171DRAFT_511047), mRNA	blastn	8141	357	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum

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