metadata: contig_metadata: 10 rows where bioproject = "PRJNA683669", tax_kingdom = "Fungi" and tax

10 rows where bioproject = "PRJNA683669", tax_kingdom = "Fungi" and tax_phylum = "Cryptomycota"

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_genus	tax_species
9593523	9593523	PRJNA683669_P_NODE_15268_length_332_cov_1.189189_g15037_i0	PRJNA683669	15268	332	1.189189	3.94810748	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	154	3.3299999999999996e-45	NR	PJF19148.1	1246581	g15037	i0	82.7	0.993975903614458	110	19	99.4	0	2	331	2	111	PJF19148.1 hypothetical protein PSACC_00996 [Paramicrosporidium saccamoebae]	diamond	330	154	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
26829133	26829133	PRJNA683669_P_NODE_25841_length_251_cov_1.730337_g25609_i0	PRJNA683669	25841	251	1.730337	4.34314587	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	90.5	5.980000000000001e-21	NR	PJF18687.1	1246581	g25609	i0	61.4	0.99203187250996006	83	29	99.2	3	251	3	47	126	PJF18687.1 Hsp16-like protein [Paramicrosporidium saccamoebae]	diamond	249	90.5	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29198127	29198127	PRJNA683669_P_NODE_6069_length_521_cov_1.517857_g5839_i0	PRJNA683669	6069	521	1.517857	7.90803497	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	131	5.63e-36	NR	PJF18950.1	1246581	g5839	i0	83.3	0.449136276391555	78	13	44.9	0	88	321	1	78	PJF18950.1 hypothetical protein PSACC_01223 [Paramicrosporidium saccamoebae]	diamond	234	131	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29450296	29450296	PRJNA683669_P_NODE_27810_length_249_cov_0.875000_g27578_i0	PRJNA683669	27810	249	0.875	2.17875	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	135	1.92e-36	NR	PJF17387.1	1246581	g27578	i0	80.5	0.987951807228916	82	16	98.8	0	3	248	180	261	PJF17387.1 hypothetical protein PSACC_02854 [Paramicrosporidium saccamoebae]	diamond	246	135	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29702738	29702738	PRJNA683669_P_NODE_33010_length_242_cov_0.911243_g32778_i0	PRJNA683669	33010	242	0.911243	2.20520806	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	52	4.72e-6	NR	PJF19913.1	1246581	g32778	i0	52	0.619834710743802	50	24	62	0	20	169	8	57	PJF19913.1 hypothetical protein PSACC_00271 [Paramicrosporidium saccamoebae]	diamond	150	52	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29955787	29955787	PRJNA683669_P_NODE_13251_length_356_cov_0.812721_g13020_i0	PRJNA683669	13251	356	0.812721	2.89328676	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	89	7.62e-18	NR	PJF19635.1	1246581	g13020	i0	56.5	0.716292134831461	85	34	71.6	1	9	263	329	410	PJF19635.1 RNA polymerase II associated Paf1 complex [Paramicrosporidium saccamoebae]	diamond	255	89	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
30555907	30555907	PRJNA683669_P_NODE_32853_length_242_cov_1.366864_g32621_i0	PRJNA683669	32853	242	1.366864	3.30781088	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	100	2.4e-22	NR	PJF19427.1	1246581	g32621	i0	58.8	0.991735537190083	80	33	99.2	0	3	242	81	160	PJF19427.1 Tcb1p [Paramicrosporidium saccamoebae]	diamond	240	100	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
31472784	31472784	PRJNA683669_P_NODE_13396_length_354_cov_1.021352_g13165_i0	PRJNA683669	13396	354	1.021352	3.61558608	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	157	7.6e-42	NR	PJF17763.1	1246581	g13165	i0	78.6	0.830508474576271	98	21	83.1	0	294	1	299	396	PJF17763.1 60S ribosomal protein L20 [Paramicrosporidium saccamoebae]	diamond	294	157	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
31630740	31630740	PRJNA683669_P_NODE_26356_length_251_cov_0.865169_g26124_i0	PRJNA683669	26356	251	0.865169	2.17157419	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	152	3.42e-41	NR	PJF18517.1	1246581	g26124	i0	89	0.9800796812749	82	9	98	0	4	249	1	82	PJF18517.1 40S ribosomal protein S8 [Paramicrosporidium saccamoebae]	diamond	246	152	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
32390109	32390109	PRJNA683669_P_NODE_28639_length_248_cov_0.880000_g28407_i0	PRJNA683669	28639	248	0.88	2.1824	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	91.3	2.62e-19	NR	PJF18818.1	1246581	g28407	i0	63.8	0.834677419354839	69	25	83.5	0	208	2	36	104	PJF18818.1 hypothetical protein PSACC_01328 [Paramicrosporidium saccamoebae]	diamond	207	91.3	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae

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