metadata: contig_metadata: 9 rows where bioproject = "PRJDB14275" and tax

9 rows where bioproject = "PRJDB14275" and tax_phylum = "Ascomycota"

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
1282894	1282894	PRJDB14275_P_NODE_7002_length_170_cov_1.221374_g6943_i0	PRJDB14275	7002	170	1.221374	2.0763358	Fulvia fulva	5499	Fungi	Fungi	156	1.05e-33	NTclustered	gi\|2234843229\|ref\|XM_047906208.1\|	5499	g6943	i0	87.05	10.7058823529412	139	17	82	1	1	139	204	67	Fulvia fulva 60S ribosomal protein L39 (CLAFUR5_07060), partial mRNA	blastn	1820	156	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Fulvia	Fulvia fulva
3834817	3834817	PRJDB14275_P_NODE_7224_length_167_cov_0.929688_g7165_i0	PRJDB14275	7224	167	0.929688	1.55257896	Penicillium citrinum	5077	Fungi	Fungi	274	2.75e-69	NTclustered	gi\|2513270201\|ref\|XM_056647875.1\|	5077	g7165	i0	100	0.88622754491018	148	0	89	0	1	148	1878	1731	Penicillium citrinum uncharacterized protein (N7469_008957), partial mRNA	blastn	148	274	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium citrinum
6084307	6084307	PRJDB14275_P_NODE_7805_length_158_cov_1.226891_g7746_i0	PRJDB14275	7805	158	1.226891	1.93848778	Eurotiales	5042	Fungi	Fungi	287	3.29e-73	NTclustered	gi\|1834978349\|ref\|NC_047444.1\|	5077	g7746	i0	99.367	98.5506329113924	158	1	100	0	1	158	24078	23921	Penicillium citrinum mitochondrion, complete genome	blastn	15571	287	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium citrinum
6386902	6386902	PRJDB14275_P_NODE_5606_length_203_cov_0.975610_g5547_i0	PRJDB14275	5606	203	0.97561	1.9804883	Cladosporium halotolerans	1052096	Fungi	Fungi	276	9.64e-70	NTclustered	gi\|2837740207\|ref\|XM_069372223.1\|	1052096	g5547	i0	91.133	99.0886699507389	203	18	100	0	1	203	302	504	Cladosporium halotolerans 60S ribosomal protein uL22 (rpl17), mRNA	blastn	20115	276	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
12762160	12762160	PRJDB14275_P_NODE_5871_length_195_cov_1.192308_g5812_i0	PRJDB14275	5871	195	1.192308	2.3250006	Pseudocercospora fijiensis	1873960	Fungi	Fungi	156	1.25e-33	NTclustered	gi\|631381899\|ref\|XM_007927139.1\|	383855	g5812	i0	86.713	1.34358974358974	143	15	72	4	55	195	196	56	Pseudocercospora fijiensis CIRAD86 uncharacterized protein (MYCFIDRAFT_88568), mRNA	blastn	262	156	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Pseudocercospora	Pseudocercospora fijiensis
18832777	18832777	PRJDB14275_P_NODE_2595_length_405_cov_18.407104_g2536_i0	PRJDB14275	2595	405	18.407104	74.5487712	Ascomycota	4890	Fungi	Fungi	645	1.3999999999999996e-180	NTclustered	gi\|2217005263\|gb\|ON154509.1\|	34409	g2536	i0	99.438	87.841975308642	356	0	88	2	1	355	786	432	Colletotrichum sp. isolate PT1040 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	35576	645	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum sp.
18832857	18832857	PRJDB14275_P_NODE_5995_length_192_cov_1.196078_g5936_i0	PRJDB14275	5995	192	1.196078	2.29646976	Dothideomycetes	147541	Fungi	Fungi	213	7.17e-51	NTclustered	gi\|627802826\|ref\|XM_007676571.1\|	717646	g5936	i0	86.842	25.1666666666667	190	25	99	0	3	192	13	202	Baudoinia panamericana UAMH 10762 uncharacterized protein (BAUCODRAFT_146455), partial mRNA	blastn	4832	213	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Baudoinia	Baudoinia panamericana
19134176	19134176	PRJDB14275_P_NODE_8356_length_151_cov_1.232143_g8297_i0	PRJDB14275	8356	151	1.232143	1.86053593	Cladosporium halotolerans	1052096	Fungi	Fungi	246	5.27e-61	NTclustered	gi\|2837761510\|ref\|XM_069375299.1\|	1052096	g8297	i0	96.026	90.6158940397351	151	6	100	0	1	151	254	404	Cladosporium halotolerans 40S ribosomal protein uS15 (RPS13), mRNA	blastn	13683	246	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
21685221	21685221	PRJDB14275_P_NODE_8198_length_153_cov_1.078947_g8139_i0	PRJDB14275	8198	153	1.078947	1.65078891	Phialemonium atrogriseum	1093897	Fungi	Fungi	91.6	2.66e-14	NTclustered	gi\|2607528851\|ref\|XM_060428661.1\|	1093897	g8139	i0	83.673	0.954248366013072	98	14	63	2	44	140	192	288	Phialemonium atrogriseum ribosomal protein 60S (QBC33DRAFT_546432), mRNA	blastn	146	91.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Cephalothecales	Cephalothecaceae	Phialemonium	Phialemonium atrogriseum

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