metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA290839" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA290839" and tax_kingdom = "Fungi"

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
2334743	2334743	PRJNA290839_P_NODE_922_length_265_cov_1.619792_g901_i0	PRJNA290839	922	265	1.619792	4.2924488	Aspergillus	5052	Fungi	Fungi	488	1.5599999999999996e-133	NTclustered	gi\|2588676\|dbj\|AB008407.1\|	5064	g901	i0	100	99.622641509434	264	0	99	0	2	265	325	62	Aspergillus restrictus gene for 18S rRNA, partial sequence	blastn	26400	488	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus restrictus
2923584	2923584	PRJNA290839_P_NODE_1143_length_250_cov_1.661017_g1122_i0	PRJNA290839	1143	250	1.661017	4.1525425	Ramularia collo-cygni	112498	Fungi	Fungi	267	7.43e-67	NTclustered	gi\|1338078511\|ref\|XM_023766008.1\|	112498	g1122	i0	86.056	34.64	251	32	99	1	2	249	2330	2080	Ramularia collo-cygni probable vacuolar H+-ATPase V0 sector, subunit a (RCC_00818), partial mRNA	blastn	8660	267	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Ramularia	Ramularia collo-cygni
2923588	2923588	PRJNA290839_P_NODE_1503_length_244_cov_0.912281_g1482_i0	PRJNA290839	1503	244	0.912281	2.22596564	Ramularia collo-cygni	112498	Fungi	Fungi	161	3.5e-35	NTclustered	gi\|1338080485\|ref\|XM_023766995.1\|	112498	g1482	i0	92.793	45.0409836065574	111	8	45	0	1	111	343	453	Ramularia collo-cygni probable CRP-2 40S ribosomal protein S14 (RCC_01707), partial mRNA	blastn	10990	161	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Ramularia	Ramularia collo-cygni
4887441	4887441	PRJNA290839_P_NODE_804_length_286_cov_1.460094_g783_i0	PRJNA290839	804	286	1.460094	4.17586884	Gjaerumia	272709	Fungi	Fungi	508	1.3e-139	NTclustered	gi\|979839318\|gb\|KP322989.1\|	58917	g783	i0	98.611	99.1573426573427	288	2	100	1	1	286	587	874	Gjaerumia minor strain CBS 543.50 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence	blastn	28359	508	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Georgefischeriales	Gjaerumiaceae	Gjaerumia	Gjaerumia minor
6162291	6162291	PRJNA290839_P_NODE_1345_length_247_cov_0.896552_g1324_i0	PRJNA290839	1345	247	0.896552	2.21448344	Aspergillus	5052	Fungi	Fungi	222	1.61e-53	NTclustered	gi\|2915766347\|ref\|XM_041295588.2\|	5059	g1324	i0	82.927	4.98785425101215	246	42	99	0	2	247	1056	1301	Aspergillus flavus DnaJ domain protein (F9C07_2287042), mRNA	blastn	1232	222	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus flavus
13126710	13126710	PRJNA290839_P_NODE_1051_length_252_cov_0.871508_g1030_i0	PRJNA290839	1051	252	0.871508	2.19620016	Histoplasma mississippiense (nom. inval.)	2059318	Fungi	Fungi	145	3.66e-30	NTclustered	gi\|154279747\|ref\|XM_001540637.1\|	2059318	g1030	i0	78.39	70.6507936507936	236	41	92	10	1	231	678	448	Histoplasma capsulatum NAm1 14-3-3 family protein ArtA partial mRNA	blastn	17804	145	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Onygenales	Ajellomycetaceae	Histoplasma	Histoplasma mississippiense (nom. inval.)
13126721	13126721	PRJNA290839_P_NODE_971_length_257_cov_2.532609_g950_i0	PRJNA290839	971	257	2.532609	6.50880513	Zymoseptoria tritici	1047171	Fungi	Fungi	470	5.45e-128	NTclustered	gi\|283827972\|gb\|EU019298.2\|	1047171	g950	i0	100	98.8249027237354	254	0	99	0	1	254	1846	2099	Zymoseptoria tritici strain CBS 110744 28S large subunit ribosomal RNA gene, partial sequence	blastn	25398	470	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Zymoseptoria	Zymoseptoria tritici
18224561	18224561	PRJNA290839_P_NODE_935_length_263_cov_1.210526_g914_i0	PRJNA290839	935	263	1.210526	3.18368338	Lobosporangium transversale	64571	Fungi	Fungi	217	8.05e-52	NTclustered	gi\|1227140854\|ref\|XM_022027301.1\|	64571	g914	i0	82.101	24.4334600760456	257	42	97	4	9	263	814	1068	Lobosporangium transversale P-loop containing nucleoside triphosphate hydrolase protein (BCR41DRAFT_381247), mRNA	blastn	6426	217	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
23324958	23324958	PRJNA290839_P_NODE_399_length_409_cov_1.601190_g378_i0	PRJNA290839	399	409	1.60119	6.5488671	Candida metapsilosis	273372	Fungi	Fungi	289	2.75e-73	NTclustered	gi\|2797500673\|ref\|XM_067693905.1\|	273372	g378	i0	79.612	22.0171149144254	412	76	99	8	1	408	974	1381	Candida metapsilosis EFT1 (I9W82_004797), partial mRNA	blastn	9005	289	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida metapsilosis
25285580	25285580	PRJNA290839_P_NODE_200_length_610_cov_4.033520_g179_i0	PRJNA290839	200	610	4.03352	24.604472	Ascomycota	4890	Fungi	Fungi	1112	0	NTclustered	gi\|17426671\|emb\|AJ301970.1\|	5462	g179	i0	99.671	98.3885245901639	608	2	99	0	3	610	1442	835	Glomerella lagenaria 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), internal transcribed spacer 1 (ITS1) and internal transcribed spacer 2 (ITS2), strain BBA 71047	blastn	60017	1122	0.991087344028521	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum lagenaria

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