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

11 rows where analysis = "diamond", bioproject = "PRJNA1035005" and tax_phylum = "Blastocladiomycota"

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
5271477	5271477	PRJNA1035005_P_NODE_12705_length_339_cov_0.879699_g12300_i0	PRJNA1035005	12705	339	0.879699	2.98217961	Fungi	4751	Fungi	Fungi	107	3.11e-24	NR	KAJ3366379.1	64505	g12300	i0	55.9	7.15929203539823	118	40	97.3	3	338	9	396	509	KAJ3366379.1 Protein phosphatase PP2A regulatory subunit B [Allomyces javanicus]	diamond	2427	108	0.990740740740741	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces javanicus
19294553	19294553	PRJNA1035005_P_NODE_28836_length_284_cov_1.473934_g28430_i0	PRJNA1035005	28836	284	1.473934	4.18597256	Blastocladiella emersonii	4808	Fungi	Fungi	102	6.42e-23	NR	ABH04243.1	4808	g28430	i0	71.4	0.887323943661972	84	19	88.7	1	2	253	163	241	ABH04243.1 heat shock protein 90 kDa [Blastocladiella emersonii]	diamond	252	102	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
26686841	26686841	PRJNA1035005_P_NODE_38801_length_271_cov_1.550505_g38395_i0	PRJNA1035005	38801	271	1.550505	4.20186855	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	72.4	1.48e-12	NR	KAI9139780.1	1500003	g38395	i0	44	0.830258302583026	75	42	83	0	226	2	174	248	KAI9139780.1 thioredoxin-like protein [Paraphysoderma sedebokerense]	diamond	225	72.4	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
27856384	27856384	PRJNA1035005_P_NODE_33945_length_277_cov_1.911765_g33539_i0	PRJNA1035005	33945	277	1.911765	5.29558905	Blastocladiella britannica	64508	Fungi	Fungi	53.9	6.07e-6	NR	KAI9220106.1	64508	g33539	i0	39.3	1.7978339350180499	89	43	86.6	4	241	2	8	94	KAI9220106.1 hypothetical protein BC828DRAFT_384359 [Blastocladiella britannica]	diamond	498	53.9	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
28290375	28290375	PRJNA1035005_P_NODE_89506_length_228_cov_2.012903_g89099_i0	PRJNA1035005	89506	228	2.012903	4.5894188400000004	Eukaryota	2759	Fungi	Fungi	119	4.03e-33	NR	KAI9220876.1	64508	g89099	i0	86.7	3.94736842105263	60	8	78.9	0	180	1	1	60	KAI9220876.1 putative RPL43B-60S large subunit ribosomal protein [Blastocladiella britannica]	diamond	900	120	0.991666666666667	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
28574588	28574588	PRJNA1035005_P_NODE_72887_length_246_cov_1.352601_g72481_i0	PRJNA1035005	72887	246	1.352601	3.32739846	Fungi	4751	Fungi	Fungi	71.6	2.08e-12	NR	KAI9141901.1	1500003	g72481	i0	45	1.92682926829268	80	42	96.3	2	3	239	15	93	KAI9141901.1 hypothetical protein BKA69DRAFT_1038209 [Paraphysoderma sedebokerense]	diamond	474	71.6	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
29151377	29151377	PRJNA1035005_P_NODE_809_length_1590_cov_5.191826_g626_i0	PRJNA1035005	809	1590	5.191826	82.5500334	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	147	1.3e-33	NR	KAI9138918.1	1500003	g626	i0	26.9	0.967924528301887	513	288	87.2	21	1486	101	36	512	KAI9138918.1 hypothetical protein BKA69DRAFT_707945 [Paraphysoderma sedebokerense]	diamond	1539	147	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
30698590	30698590	PRJNA1035005_P_NODE_1234_length_1187_cov_1.508977_g955_i0	PRJNA1035005	1234	1187	1.508977	17.91155699	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	136	4.55e-31	NR	KAI9138915.1	1500003	g955	i0	30.1	1.83487784330244	379	194	83.4	15	105	1094	30	386	KAI9138915.1 hypothetical protein BKA69DRAFT_1088626 [Paraphysoderma sedebokerense]	diamond	2178	136	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
31140591	31140591	PRJNA1035005_P_NODE_15715_length_319_cov_1.207317_g15309_i0	PRJNA1035005	15715	319	1.207317	3.85134123	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	144	1.95e-38	NR	KAI9141231.1	1500003	g15309	i0	62.3	3.97805642633229	106	40	99.7	0	2	319	259	364	KAI9141231.1 P-loop containing nucleoside triphosphate hydrolase protein [Paraphysoderma sedebokerense]	diamond	1269	144	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
31425576	31425576	PRJNA1035005_P_NODE_86216_length_242_cov_0.923077_g85810_i0	PRJNA1035005	86216	242	0.923077	2.23384634	Allomyces macrogynus ATCC 38327	578462	Fungi	Fungi	95.1	1.36e-20	NR	KNE72634.1	578462	g85810	i0	55	0.991735537190083	80	36	99.2	0	1	240	660	739	KNE72634.1 hypothetical protein AMAG_16397 [Allomyces macrogynus ATCC 38327]	diamond	240	95.1	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
32596109	32596109	PRJNA1035005_P_NODE_4280_length_517_cov_1.513514_g3882_i0	PRJNA1035005	4280	517	1.513514	7.82486738	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	73.9	6.54e-12	NR	KAI9139772.1	1500003	g3882	i0	50.9	0.928433268858801	53	26	30.8	0	358	516	36	88	KAI9139772.1 WD40-repeat-containing domain protein [Paraphysoderma sedebokerense]	diamond	480	73.9	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense

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