metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1120586" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1120586" 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
2826642	2826642	PRJNA1120586_P_NODE_28523_length_265_cov_1.469388_g28332_i0	PRJNA1120586	28523	265	1.469388	3.8938782	Dactylellina cionopaga	47266	Fungi	Fungi	152	5.4699999999999986e-43	NR	KAF3932129.1	47266	g28332	i0	75	5.97735849056604	88	22	99.6	0	265	2	131	218	KAF3932129.1 Beta-TrCP [Dactylellina cionopaga]	diamond	1584	152	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Orbiliomycetes	Orbiliales	Orbiliaceae	Dactylellina	Dactylellina cionopaga
26753220	26753220	PRJNA1120586_P_NODE_35601_length_245_cov_1.403409_g35410_i0	PRJNA1120586	35601	245	1.403409	3.43835205	Recurvomyces mirabilis	574656	Fungi	Fungi	44.3	0.0109	NR	XP_064690326.1	574656	g35410	i0	32.9	0.857142857142857	70	44	84.5	2	236	30	382	449	XP_064690326.1 uncharacterized protein LTS14_009436 [Recurvomyces mirabilis]	diamond	210	44.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Recurvomyces	Recurvomyces mirabilis
28733221	28733221	PRJNA1120586_P_NODE_48567_length_229_cov_0.900000_g48376_i0	PRJNA1120586	48567	229	0.9	2.061	Nectriaceae	110618	Fungi	Fungi	92.4	4.8700000000000005e-21	NR	KAF5667939.1	42747	g48376	i0	84.3	6.6943231441048	51	8	66.8	0	153	1	125	175	KAF5667939.1 MADS-box transcription protein [Fusarium heterosporum]	diamond	1533	92.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium heterosporum
29017654	29017654	PRJNA1120586_P_NODE_47768_length_229_cov_0.900000_g47577_i0	PRJNA1120586	47768	229	0.9	2.061	Leotiomycetes	147548	Fungi	Fungi	109	1.14e-25	NR	CZT51112.1	38038	g47577	i0	91.2	2.24017467248908	57	5	74.7	0	2	172	383	439	CZT51112.1 related to archipelago beta form (F-box-WD40 repeat protein) [Rhynchosporium secalis]	diamond	513	109	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Ploettnerulaceae	Rhynchosporium	Rhynchosporium secalis
29501514	29501514	PRJNA1120586_P_NODE_42430_length_233_cov_0.878049_g42239_i0	PRJNA1120586	42430	233	0.878049	2.04585417	Apiospora kogelbergensis	1337665	Fungi	Fungi	43.5	0.0179	NR	XP_066734597.1	1337665	g42239	i0	30.4	0.888412017167382	69	48	88.8	0	207	1	773	841	XP_066734597.1 ATP-dependent DNA helicase 2 subunit 1 [Apiospora kogelbergensis]	diamond	207	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Amphisphaeriales	Apiosporaceae	Apiospora	Apiospora kogelbergensis
30449448	30449448	PRJNA1120586_P_NODE_44393_length_232_cov_0.883436_g44202_i0	PRJNA1120586	44393	232	0.883436	2.04957152	Sarocladium strictum	5046	Fungi	Fungi	75.5	4.04e-14	NR	KAK0387188.1	5046	g44202	i0	79.5	0.504310344827586	39	8	50.4	0	119	3	1	39	KAK0387188.1 hypothetical protein NLU13_5501 [Sarocladium strictum]	diamond	117	75.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
30891723	30891723	PRJNA1120586_P_NODE_34594_length_247_cov_2.988764_g34403_i0	PRJNA1120586	34594	247	2.988764	7.38224708	Friedmanniomyces endolithicus	329885	Fungi	Fungi	124	1.59e-33	NR	KAK0331223.1	329885	g34403	i0	92.6	0.983805668016194	81	6	98.4	0	4	246	12	92	KAK0331223.1 hypothetical protein LTR94_029781, partial [Friedmanniomyces endolithicus]	diamond	243	124	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Friedmanniomyces	Friedmanniomyces endolithicus
30923397	30923397	PRJNA1120586_P_NODE_49694_length_228_cov_0.905660_g49503_i0	PRJNA1120586	49694	228	0.90566	2.0649048	Hapsidospora chrysogenum ATCC 1155	5044	Fungi	Fungi	49.7	1.13e-4	NR	KFH48892.1	857340	g49503	i0	41	0.802631578947368	61	33	76.3	2	225	52	679	739	KFH48892.1 PHD finger protein-like protein-like protein [Hapsidospora chrysogenum ATCC 11550]	diamond	183	49.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Bionectriaceae	Hapsidospora	Hapsidospora chrysogena
31081245	31081245	PRJNA1120586_P_NODE_44395_length_232_cov_0.883436_g44204_i0	PRJNA1120586	44395	232	0.883436	2.04957152	Endocarpon pusillum	364733	Fungi	Fungi	105	3.66e-24	NR	KAF7510634.1	364733	g44204	i0	72.7	0.995689655172414	77	21	99.6	0	1	231	584	660	KAF7510634.1 hypothetical protein GJ744_006246 [Endocarpon pusillum]	diamond	231	105	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Verrucariales	Verrucariaceae	Endocarpon	Endocarpon pusillum
32682927	32682927	PRJNA1120586_P_NODE_51460_length_227_cov_0.911392_g51269_i0	PRJNA1120586	51460	227	0.911392	2.06885984	Lachnellula	47830	Fungi	Fungi	74.3	2.28e-13	NR	TVY48604.1	215460	g51269	i0	56.3	1.69162995594714	64	23	78	1	225	49	1039	1102	TVY48604.1 Citrinin polyketide synthase [Lachnellula occidentalis]	diamond	384	74.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Lachnaceae	Lachnellula	Lachnellula occidentalis

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