metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA964500" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA964500" and tax_clade = "Opisthokonta"

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
26614108	26614108	PRJNA964500_S_NODE_7101_length_215_cov_3.344086_g7009_i0	PRJNA964500	7101	215	3.344086	7.1897849	Aspergillus unguis	40381	Fungi	Fungi	75.5	8.76e-15	NR	KAL4811127.1	40381	g7009	i0	62.1	2.67906976744186	66	25	92.1	0	210	13	109	174	KAL4811127.1 heat shock protein 9/12-domain-containing protein [Aspergillus unguis]	diamond	576	75.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus unguis
27657913	27657913	PRJNA964500_S_NODE_8184_length_203_cov_2.574713_g8092_i0	PRJNA964500	8184	203	2.574713	5.22666739	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	129	4.39e-37	NR	XP_057300244.1	13093	g8092	i0	84.8	7.80295566502463	66	10	97.5	0	201	4	3	68	XP_057300244.1 probable 60S ribosomal protein L37-A [Hydractinia symbiolongicarpus]	diamond	1584	129	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
28358560	28358560	PRJNA964500_S_NODE_9666_length_190_cov_2.347826_g9574_i0	PRJNA964500	9666	190	2.347826	4.4608694	Metazoa	33208	Chordata	Chordata	45.4	0.0021	NR	XP_051782102.1	27687	g9574	i0	55	3.39473684210526	40	18	63.2	0	141	22	219	258	XP_051782102.1 uncharacterized protein K02A2.6-like [Erpetoichthys calabaricus]	diamond	645	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
29678116	29678116	PRJNA964500_S_NODE_17330_length_151_cov_1.770492_g17238_i0	PRJNA964500	17330	151	1.770492	2.67344292	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	52.4	4.26e-6	NR	XP_006826086.1	10224	g17238	i0	57.8	0.894039735099338	45	19	89.4	0	147	13	1141	1185	XP_006826086.1 PREDICTED: uncharacterized protein LOC102808992 [Saccoglossus kowalevskii]	diamond	135	52.4	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
30152000	30152000	PRJNA964500_S_NODE_5172_length_244_cov_4.330233_g5080_i0	PRJNA964500	5172	244	4.330233	10.56576852	Sporormia fimetaria CBS 119925	1340428	Fungi	Fungi	43.9	0.00258	NR	KAF2751681.1	1340428	g5080	i0	70	0.368852459016393	30	8	35.7	1	6	92	61	90	KAF2751681.1 putative chaperone/heat shock protein Hsp12 [Sporormia fimetaria CBS 119925]	diamond	90	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Sporormiaceae	Sporormia	Sporormia fimetaria
30942296	30942296	PRJNA964500_S_NODE_13614_length_166_cov_1.678832_g13522_i0	PRJNA964500	13614	166	1.678832	2.78686112	Bimuria novae-zelandiae CBS 1	147497	Fungi	Fungi	95.5	1.05e-22	NR	KAF1967949.1	1447943	g13522	i0	91.8	0.885542168674699	49	4	88.6	0	151	5	70	118	KAF1967949.1 hypothetical protein BU23DRAFT_279957 [Bimuria novae-zelandiae CBS 107.79]	diamond	147	95.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymosphaeriaceae	Bimuria	Bimuria novae-zelandiae
31131419	31131419	PRJNA964500_S_NODE_14295_length_163_cov_2.373134_g14203_i0	PRJNA964500	14295	163	2.373134	3.86820842	Pseudopithomyces chartarum	1892770	Fungi	Fungi	106	9.36e-27	NR	KAK3213860.1	1892770	g14203	i0	94.3	0.975460122699387	53	3	97.5	0	162	4	87	139	KAK3213860.1 hypothetical protein GRF29_28g1265241 [Pseudopithomyces chartarum]	diamond	159	106	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymosphaeriaceae	Pseudopithomyces	Pseudopithomyces chartarum
31163008	31163008	PRJNA964500_S_NODE_13375_length_167_cov_2.630435_g13283_i0	PRJNA964500	13375	167	2.630435	4.39282645	Pseudopithomyces chartarum	1892770	Fungi	Fungi	114	6.88e-30	NR	KAK3213860.1	1892770	g13283	i0	98.2	0.988023952095808	55	1	98.8	0	2	166	172	226	KAK3213860.1 hypothetical protein GRF29_28g1265241 [Pseudopithomyces chartarum]	diamond	165	114	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymosphaeriaceae	Pseudopithomyces	Pseudopithomyces chartarum
31606099	31606099	PRJNA964500_S_NODE_14276_length_163_cov_2.865672_g14184_i0	PRJNA964500	14276	163	2.865672	4.67104536	Puccinia coronata f. sp. avenae	200324	Fungi	Fungi	62	9.86e-11	NR	PLW10301.1	200324	g14184	i0	100	0.588957055214724	32	0	58.9	0	9	104	72	103	PLW10301.1 hypothetical protein PCANC_22331 [Puccinia coronata f. sp. avenae]	diamond	96	62	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia coronata
32207193	32207193	PRJNA964500_S_NODE_12758_length_170_cov_2.297872_g12666_i0	PRJNA964500	12758	170	2.297872	3.9063824	Rhinolophus ferrumequinum	59479	Chordata	Chordata	57.8	6.81e-8	NR	KAF6301838.1	59479	g12666	i0	58.3	0.847058823529412	48	19	82.9	1	1	141	255	302	KAF6301838.1 hypothetical protein mRhiFer1_008753 [Rhinolophus ferrumequinum]	diamond	144	57.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Rhinolophidae	Rhinolophus	Rhinolophus ferrumequinum
32586921	32586921	PRJNA964500_S_NODE_2439_length_323_cov_12.544218_g2347_i0	PRJNA964500	2439	323	12.544218	40.51782414	Orbilia brochopaga	3140254	Fungi	Fungi	42.4	0.0281	NR	KAF3901435.1	3140254	g2347	i0	38	0.464396284829721	50	31	46.4	0	182	33	4	53	KAF3901435.1 hypothetical protein ABW21_db0202567 [Orbilia brochopaga]	diamond	150	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Orbiliomycetes	Orbiliales	Orbiliaceae	Orbilia	Orbilia brochopaga

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