metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA743294" 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
1997991	1997991	PRJNA743294_P_NODE_25042_length_329_cov_1.667969_g24586_i0	PRJNA743294	25042	329	1.667969	5.48761801	Spizellomyces punctatus	109760	Fungi	Fungi	143	1.79e-29	NTclustered	gi\|1027008842\|ref\|XM_016754984.1\|	645134	g24586	i0	79.5	0.60790273556231	200	41	61	0	129	328	320	519	Spizellomyces punctatus DAOM BR117 small GTP-binding protein domain (SPPG_06785), mRNA	blastn	200	143	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus
4550383	4550383	PRJNA743294_P_NODE_12504_length_450_cov_5.877984_g12048_i0	PRJNA743294	12504	450	5.877984	26.450928	Polychytrium aggregatum	110093	Fungi	Fungi	159	2.5e-34	NTclustered	gi\|2432130120\|ref\|XM_053107963.1\|	110093	g12048	i0	76.471	58.7577777777778	323	58	70	15	136	449	2432	2119	Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_436912), mRNA	blastn	26441	159	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
4550535	4550535	PRJNA743294_P_NODE_32004_length_295_cov_2.108108_g31548_i0	PRJNA743294	32004	295	2.108108	6.2189186	Polychytrium aggregatum	110093	Fungi	Fungi	250	9.05e-62	NTclustered	gi\|2432130078\|ref\|XM_053109045.1\|	110093	g31548	i0	81.973	10.2610169491525	294	53	99	0	2	295	883	1176	Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_484843), mRNA	blastn	3027	250	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
4550716	4550716	PRJNA743294_P_NODE_5444_length_655_cov_5.154639_g4997_i0	PRJNA743294	5444	655	5.154639	33.76288545	Synchytrium microbalum	1806994	Fungi	Fungi	56.5	0.005	NTclustered	gi\|1759143465\|ref\|XM_031167116.1\|	1806994	g4997	i0	81.818	0.100763358778626	66	12	10	0	284	349	439	504	Synchytrium microbalum uncharacterized protein (SmJEL517_g01188), partial mRNA	blastn	66	56.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium microbalum
7100625	7100625	PRJNA743294_P_NODE_17626_length_384_cov_2.221865_g17170_i0	PRJNA743294	17626	384	2.221865	8.5319616	Spizellomyces punctatus	109760	Fungi	Fungi	60.2	2.19e-4	NTclustered	gi\|1027020323\|ref\|XM_016756024.1\|	645134	g17170	i0	91.111	1.31510416666667	45	2	11	2	262	304	180	224	Spizellomyces punctatus DAOM BR117 rRNA 2'-O-methyltransferase fibrillarin (SPPG_07874), mRNA	blastn	505	60.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus
7100682	7100682	PRJNA743294_P_NODE_25666_length_325_cov_7.507937_g25210_i0	PRJNA743294	25666	325	7.507937	24.40079525	Polychytrium aggregatum	110093	Fungi	Fungi	159	1.75e-34	NTclustered	gi\|2432134999\|ref\|XM_053114679.1\|	110093	g25210	i0	77.947	0.809230769230769	263	52	80	6	17	276	376	117	Polychytrium aggregatum Glyoxalase/Bleomycin resistance protein/Dihydroxybiphenyl dioxygenase (BJ171DRAFT_596423), mRNA	blastn	263	159	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
7100898	7100898	PRJNA743294_P_NODE_54386_length_244_cov_0.912281_g53930_i0	PRJNA743294	54386	244	0.912281	2.22596564	Synchytrium microbalum	1806994	Fungi	Fungi	228	3.409999999999999e-55	NTclustered	gi\|1759154564\|ref\|XM_031169821.1\|	1806994	g53930	i0	87.692	39.5737704918033	195	24	80	0	14	208	213	19	Synchytrium microbalum uncharacterized protein (SmJEL517_g03893), partial mRNA	blastn	9656	228	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium microbalum
9650663	9650663	PRJNA743294_P_NODE_55988_length_242_cov_1.846154_g55532_i0	PRJNA743294	55988	242	1.846154	4.46769268	Polychytrium aggregatum	110093	Fungi	Fungi	124	4.55e-24	NTclustered	gi\|2432159776\|ref\|XM_053111801.1\|	110093	g55532	i0	89.691	24.3471074380165	97	10	40	0	124	220	388	292	Polychytrium aggregatum ribosomal protein S8e/ribosomal biogenesis NSA2 (BJ171DRAFT_514033), mRNA	blastn	5892	124	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
12677899	12677899	PRJNA743294_P_NODE_16050_length_401_cov_11.030488_g15594_i0	PRJNA743294	16050	401	11.030488	44.23225688	Opisthokonta	33154	Fungi	Fungi	167	1.32e-36	NTclustered	gi\|2432095963\|ref\|XM_053071178.1\|	1396493	g15594	i0	78.682	27.8927680798005	258	49	64	6	70	324	214	468	Fimicolochytrium jonesii ribosomal protein S10 domain-containing protein (EV422DRAFT_541037), mRNA	blastn	11185	167	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
12677905	12677905	PRJNA743294_P_NODE_19010_length_371_cov_4.332215_g18554_i0	PRJNA743294	19010	371	4.332215	16.07251765	Eukaryota	2759	Fungi	Fungi	246	1.51e-60	NTclustered	gi\|189909135\|gb\|DQ273836.2\|	4814	g18554	i0	79.133	88.9946091644205	369	68	99	6	1	366	2868	2506	Chytriomyces hyalinus isolate AFTOL-ID 1537 28S ribosomal RNA gene, partial sequence	blastn	33017	248	0.991935483870968	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Chytriomyces	Chytriomyces hyalinus
15226892	15226892	PRJNA743294_P_NODE_4392_length_723_cov_3.470769_g3982_i0	PRJNA743294	4392	723	3.470769	25.09365987	Fungi	4751	Fungi	Fungi	327	1.0699999999999999e-84	NTclustered	gi\|2432145256\|ref\|XM_053110808.1\|	110093	g3982	i0	83.287	50.118948824343	359	56	49	4	2	358	1444	1800	Polychytrium aggregatum hsp71-like protein (BJ171DRAFT_502900), mRNA	blastn	36236	327	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
16501294	16501294	PRJNA743294_P_NODE_22293_length_346_cov_1.816850_g21837_i0	PRJNA743294	22293	346	1.81685	6.286301	Spizellomycetales	34478	Fungi	Fungi	219	3.0499999999999992e-52	NTclustered	gi\|1027025955\|ref\|XM_016756565.1\|	645134	g21837	i0	80.903	5.22254335260116	288	45	82	8	37	319	1142	860	Spizellomyces punctatus DAOM BR117 translation elongation factor Tu (SPPG_08407), mRNA	blastn	1807	219	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus
18573684	18573684	PRJNA743294_P_NODE_22055_length_348_cov_1.123636_g21599_i0	PRJNA743294	22055	348	1.123636	3.91025328	Neocallimastix frontalis	4757	Fungi	Fungi	213	1.43e-50	NTclustered	gi\|387233100\|gb\|JN033860.1\|	4757	g21599	i0	79.114	91.5201149425287	316	61	90	5	15	328	1672	1984	Neocallimastix frontalis strain PMA02 aconitate hydratase (AH1) mRNA, complete cds	blastn	31849	213	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Neocallimastix	Neocallimastix frontalis
18573964	18573964	PRJNA743294_P_NODE_8495_length_539_cov_12.690987_g8039_i0	PRJNA743294	8495	539	12.690987	68.40441993	Polychytrium aggregatum	110093	Fungi	Fungi	470	1.23e-127	NTclustered	gi\|2432131711\|ref\|XM_053109357.1\|	110093	g8039	i0	88.773	70.4155844155844	383	43	71	0	1	383	196	578	Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA	blastn	37954	470	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
22399727	22399727	PRJNA743294_P_NODE_6558_length_607_cov_5.488764_g6107_i0	PRJNA743294	6558	607	5.488764	33.31679748	Polychytrium aggregatum	110093	Fungi	Fungi	211	9.37e-50	NTclustered	gi\|2432162630\|ref\|XM_053112000.1\|	110093	g6107	i0	76.923	24.7314662273476	403	73	65	15	67	462	134	523	Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA	blastn	15012	211	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
23674939	23674939	PRJNA743294_P_NODE_19979_length_363_cov_2.689655_g19523_i0	PRJNA743294	19979	363	2.689655	9.76344765	Polychytrium aggregatum	110093	Fungi	Fungi	231	4.1199999999999985e-56	NTclustered	gi\|2432138599\|ref\|XM_053113968.1\|	110093	g19523	i0	79.155	75.9641873278237	355	59	95	13	3	348	401	749	Polychytrium aggregatum serine hydroxymethyltransferase (BJ171DRAFT_579433), partial mRNA	blastn	27575	231	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
23675009	23675009	PRJNA743294_P_NODE_28579_length_310_cov_2.894515_g28123_i0	PRJNA743294	28579	310	2.894515	8.9729965	Gromochytrium mamkaevae	1486924	Fungi	Fungi	298	3.37e-76	NTclustered	gi\|612507318\|gb\|KF586842.1\|	1486924	g28123	i0	86.022	83.0129032258065	279	37	89	2	1	277	3813	3535	Gromochytrium mamkaevae strain CALU x-51 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	25734	298	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Gromochytriales	Gromochytriaceae	Gromochytrium	Gromochytrium mamkaevae
24948600	24948600	PRJNA743294_P_NODE_4400_length_722_cov_20.813559_g3990_i0	PRJNA743294	4400	722	20.813559	150.27389598	Polychytrium aggregatum	110093	Fungi	Fungi	307	1.4e-78	NTclustered	gi\|2432170888\|ref\|XM_053112523.1\|	110093	g3990	i0	77.087	31.3296398891967	563	109	77	18	44	596	49	601	Polychytrium aggregatum putative 40S ribosomal protein S3 (BJ171DRAFT_522887), mRNA	blastn	22620	307	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
25424914	25424914	PRJNA743294_P_NODE_22460_length_345_cov_1.430147_g22004_i0	PRJNA743294	22460	345	1.430147	4.93400715	Fungi	4751	Fungi	Fungi	274	6.4e-69	NTclustered	gi\|575472981\|ref\|XM_006675721.1\|	684364	g22004	i0	85.496	76.0115942028986	262	38	76	0	28	289	345	84	Batrachochytrium dendrobatidis JAM81 70 kDa heat shock protein 3 (BATDEDRAFT_34196), mRNA	blastn	26224	274	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium dendrobatidis

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