metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA986481" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA986481" 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
973307	973307	PRJNA986481_P_NODE_20021_length_366_cov_2.189274_g19496_i0	PRJNA986481	20021	366	2.189274	8.01274284	Polychytrium aggregatum	110093	Fungi	Fungi	178	5.49e-40	NTclustered	gi\|2432132579\|ref\|XM_053106383.1\|	110093	g19496	i0	79.389	45.2950819672131	262	46	70	8	108	365	1761	1504	Polychytrium aggregatum heat shock protein 70 family (BJ171DRAFT_212372), mRNA	blastn	16578	178	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
973690	973690	PRJNA986481_P_NODE_43501_length_260_cov_0.957346_g42976_i0	PRJNA986481	43501	260	0.957346	2.4890996	Synchytrium microbalum	1806994	Fungi	Fungi	154	6.31e-33	NTclustered	gi\|1759154818\|ref\|XM_031169817.1\|	1806994	g42976	i0	80.808	71.8807692307692	198	36	76	2	64	260	692	496	Synchytrium microbalum uncharacterized protein (SmJEL517_g03889), partial mRNA	blastn	18689	154	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium microbalum
973988	973988	PRJNA986481_P_NODE_61481_length_234_cov_2.918919_g60956_i0	PRJNA986481	61481	234	2.918919	6.83027046	Polychytrium aggregatum	110093	Fungi	Fungi	200	7.07e-47	NTclustered	gi\|2432157214\|ref\|XM_053108825.1\|	110093	g60956	i0	82.128	15.8461538461538	235	40	100	2	1	234	539	306	Polychytrium aggregatum ATP-utilizing phosphoenolpyruvate carboxykinase (BJ171DRAFT_476303), partial mRNA	blastn	3708	200	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
11177069	11177069	PRJNA986481_P_NODE_4429_length_743_cov_1.560519_g4016_i0	PRJNA986481	4429	743	1.560519	11.59465617	Polychytrium aggregatum	110093	Fungi	Fungi	483	2.23e-131	NTclustered	gi\|2432130198\|ref\|XM_053115874.1\|	110093	g4016	i0	79.79	79.9730820995962	668	131	90	4	78	743	1383	718	Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_7386), mRNA	blastn	59420	483	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
12751419	12751419	PRJNA986481_P_NODE_5450_length_682_cov_3.146919_g5009_i0	PRJNA986481	5450	682	3.146919	21.46198758	Fungi	4751	Fungi	Fungi	244	1.05e-59	NTclustered	gi\|2432145256\|ref\|XM_053110808.1\|	110093	g5009	i0	82.23	42.9398826979472	287	47	42	4	398	682	1800	1516	Polychytrium aggregatum hsp71-like protein (BJ171DRAFT_502900), mRNA	blastn	29285	244	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
13727090	13727090	PRJNA986481_P_NODE_30351_length_297_cov_1.229839_g29826_i0	PRJNA986481	30351	297	1.229839	3.65262183	Polychytrium aggregatum	110093	Fungi	Fungi	239	1.97e-58	NTclustered	gi\|2432150000\|ref\|XM_053114178.1\|	110093	g29826	i0	81.443	39.9057239057239	291	54	98	0	1	291	259	549	Polychytrium aggregatum ribosomal protein S2, flavodoxin-like domain-containing protein (BJ171DRAFT_582387), partial mRNA	blastn	11852	239	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
21375618	21375618	PRJNA986481_P_NODE_29697_length_300_cov_2.462151_g29172_i0	PRJNA986481	29697	300	2.462151	7.386453	Rhizophydium sp. JEL138	139068	Fungi	Fungi	276	1.52e-69	NTclustered	gi\|30088555\|gb\|AY138786.1\|	139068	g29172	i0	83.389	96.58	301	46	99	3	1	299	476	178	Rhizophydium sp. JEL138 alpha-tubulin (atub) gene, partial cds	blastn	28974	276	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales	Rhizophydiaceae	Rhizophydium	Rhizophydium sp. JEL138
21376149	21376149	PRJNA986481_P_NODE_6417_length_634_cov_3.970940_g5940_i0	PRJNA986481	6417	634	3.97094	25.1757596	Spizellomyces punctatus	109760	Fungi	Fungi	252	5.78e-62	NTclustered	gi\|1026980085\|ref\|XM_016752373.1\|	645134	g5940	i0	80.606	6.11041009463722	330	61	52	3	108	436	508	181	Spizellomyces punctatus DAOM BR117 40S ribosomal protein S15 (SPPG_04127), mRNA	blastn	3874	252	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus
22651133	22651133	PRJNA986481_P_NODE_9698_length_525_cov_2.880252_g9179_i0	PRJNA986481	9698	525	2.880252	15.121323	Spizellomyces punctatus	109760	Fungi	Fungi	296	2.15e-75	NTclustered	gi\|1026953358\|ref\|XM_016749715.1\|	645134	g9179	i0	80.402	18.8419047619048	398	70	75	7	10	403	535	142	Spizellomyces punctatus DAOM BR117 40S ribosomal protein S14 (SPPG_01396), mRNA	blastn	9892	296	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus

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