metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA407886" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA407886" 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
2968461	2968461	PRJNA407886_P_NODE_58063_length_279_cov_4.223301_g56369_i0	PRJNA407886	58063	279	4.223301	11.78300979	Polychytrium aggregatum	110093	Fungi	Fungi	121	6.94e-23	NTclustered	gi\|2432138713\|ref\|XM_053107478.1\|	110093	g56369	i0	84.252	7.69534050179211	127	16	45	3	147	271	148	24	Polychytrium aggregatum large subunit ribosomal protein 29 (BJ171DRAFT_421272), partial mRNA	blastn	2147	121	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
9345923	9345923	PRJNA407886_P_NODE_60988_length_271_cov_7.181818_g59294_i0	PRJNA407886	60988	271	7.181818	19.46272678	Spizellomyces punctatus	109760	Fungi	Fungi	143	1.43e-29	NTclustered	gi\|1026990807\|ref\|XM_016753365.1\|	645134	g59294	i0	94.565	30.8228782287823	92	5	34	0	1	92	1387	1478	Spizellomyces punctatus DAOM BR117 tubulin alpha chain (SPPG_05136), mRNA	blastn	8353	143	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus
10621767	10621767	PRJNA407886_P_NODE_64469_length_263_cov_1.210526_g62775_i0	PRJNA407886	64469	263	1.210526	3.18368338	uncultured Chytridiomycota	175247	Fungi	Fungi	69.4	2.38e-7	NTclustered	gi\|262235206\|gb\|GQ995417.1\|	175247	g62775	i0	83.333	16.2509505703422	78	9	29	3	1	77	904	830	Uncultured Chytridiomycota clone T1P1AeC08 18S ribosomal RNA gene, partial sequence	blastn	4274	69.4	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota					uncultured Chytridiomycota
11285384	11285384	PRJNA407886_P_NODE_35409_length_374_cov_1.797342_g33715_i0	PRJNA407886	35409	374	1.797342	6.72205908	Batrachochytrium	100474	Fungi	Fungi	63.9	1.64e-5	NTclustered	gi\|2897840458\|gb\|CP161934.1\|	109871	g33715	i0	91.304	0.245989304812834	46	4	12	0	177	222	805156	805111	Batrachochytrium dendrobatidis strain JEL423 chromosome 12	blastn	92	63.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium dendrobatidis
24644144	24644144	PRJNA407886_P_NODE_60620_length_272_cov_3.854271_g58926_i0	PRJNA407886	60620	272	3.854271	10.48361712	Fimicolochytrium jonesii	1396493	Fungi	Fungi	143	1.44e-29	NTclustered	gi\|2432051426\|ref\|XM_053072055.1\|	1396493	g58926	i0	76.557	7.86397058823529	273	56	99	8	1	269	584	316	Fimicolochytrium jonesii ribosomal family S4e-domain-containing protein (EV422DRAFT_563332), partial mRNA	blastn	2139	143	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii

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