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

9 rows where analysis = "blastn", bioproject = "PRJNA222400" 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
4194352	4194352	PRJNA222400_P_NODE_9264_length_162_cov_0.920354_g9231_i0	PRJNA222400	9264	162	0.920354	1.49097348	Polychytrium aggregatum	110093	Fungi	Fungi	73.1	1.03e-8	NTclustered	gi\|2432142762\|ref\|XM_053110549.1\|	110093	g9231	i0	95.556	0.277777777777778	45	2	28	0	14	58	2506	2462	Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_500123), mRNA	blastn	45	73.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
5470520	5470520	PRJNA222400_P_NODE_205_length_1037_cov_2.325911_g189_i0	PRJNA222400	205	1037	2.325911	24.11969707	Polychytrium aggregatum	110093	Fungi	Fungi	540	1.8399999999999993e-148	NTclustered	gi\|2432130198\|ref\|XM_053115874.1\|	110093	g189	i0	77.728	70.6229508196721	889	192	85	6	152	1037	1383	498	Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_7386), mRNA	blastn	73236	540	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
8709222	8709222	PRJNA222400_P_NODE_2047_length_350_cov_1.714286_g2014_i0	PRJNA222400	2047	350	1.714286	6.000001	Fungi	4751	Fungi	Fungi	95.3	5.42e-15	NTclustered	gi\|2432165340\|ref\|XM_053112172.1\|	110093	g2014	i0	83.636	20.4542857142857	110	9	31	4	39	145	1003	900	Polychytrium aggregatum ribosomal protein L10-domain-containing protein (BJ171DRAFT_517673), mRNA	blastn	7159	95.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
13121020	13121020	PRJNA222400_P_NODE_5531_length_190_cov_1.829787_g5498_i0	PRJNA222400	5531	190	1.829787	3.4765953	Polychytrium aggregatum	110093	Fungi	Fungi	183	5.5499999999999996e-42	NTclustered	gi\|2432151540\|ref\|XM_053108788.1\|	110093	g5498	i0	84.574	9.03157894736842	188	25	98	4	2	187	733	918	Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_475566), partial mRNA	blastn	1716	183	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
18218833	18218833	PRJNA222400_P_NODE_2115_length_343_cov_16.714286_g2082_i0	PRJNA222400	2115	343	16.714286	57.33000098	Polychytrium aggregatum	110093	Fungi	Fungi	121	8.769999999999999e-23	NTclustered	gi\|2432138713\|ref\|XM_053107478.1\|	110093	g2082	i0	84.252	6.25947521865889	127	16	36	3	207	331	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
19493185	19493185	PRJNA222400_P_NODE_556_length_685_cov_10.133648_g526_i0	PRJNA222400	556	685	10.133648	69.4154888	Polychytrium aggregatum	110093	Fungi	Fungi	195	1.07e-44	NTclustered	gi\|2432162630\|ref\|XM_053112000.1\|	110093	g526	i0	76.238	20.3255474452555	404	74	58	16	218	613	523	134	Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA	blastn	13923	195	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
20182578	20182578	PRJNA222400_P_NODE_5756_length_187_cov_1.130435_g5723_i0	PRJNA222400	5756	187	1.130435	2.11391345	Fungi	4751	Fungi	Fungi	100	5.64e-17	NTclustered	gi\|1027000782\|ref\|XM_016757478.1\|	645134	g5723	i0	92.754	2.78609625668449	69	5	37	0	1	69	515	583	Spizellomyces punctatus DAOM BR117 40S ribosomal protein S12 (SPPG_09319), mRNA	blastn	521	100	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus
23319273	23319273	PRJNA222400_P_NODE_4899_length_201_cov_1.486842_g4866_i0	PRJNA222400	4899	201	1.486842	2.98855242	Fimicolochytrium jonesii	1396493	Fungi	Fungi	200	5.9e-47	NTclustered	gi\|2432092633\|ref\|XM_053073336.1\|	1396493	g4866	i0	86.022	23.4577114427861	186	26	93	0	12	197	272	457	Fimicolochytrium jonesii elongation factor alpha-like protein (EV422DRAFT_580294), partial mRNA	blastn	4715	200	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
23319276	23319276	PRJNA222400_P_NODE_5059_length_198_cov_1.832215_g5026_i0	PRJNA222400	5059	198	1.832215	3.6277857	Polychytrium aggregatum	110093	Fungi	Fungi	158	3.54e-34	NTclustered	gi\|2432131463\|ref\|XM_053113103.1\|	110093	g5026	i0	84.568	70.4242424242424	162	21	81	4	1	160	203	44	Polychytrium aggregatum translation protein SH3-like domain-containing protein (BJ171DRAFT_557634), partial mRNA	blastn	13944	158	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);;