metadata: contig_metadata: 10 rows where bioproject = "PRJNA1118794" and tax

10 rows where bioproject = "PRJNA1118794" 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
2781071	2781071	PRJNA1118794_P_NODE_25723_length_310_cov_1.763713_g24973_i0	PRJNA1118794	25723	310	1.763713	5.4675103	uncultured Cryptomycota	1130064	Fungi	Fungi	340	5.519999999999999e-89	NTclustered	gi\|2086101798\|gb\|MZ923359.1\|	1130064	g24973	i0	91.27	81.5129032258065	252	18	81	4	58	309	906	1153	Uncultured Cryptomycota clone UMPB-65 small subunit ribosomal RNA gene, partial sequence	blastn	25269	340	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota		uncultured Cryptomycota
7883818	7883818	PRJNA1118794_P_NODE_54487_length_249_cov_0.875000_g53737_i0	PRJNA1118794	54487	249	0.875	2.17875	Rozella allomycis CSF55	988480	Fungi	Fungi	95.9	4.02e-21	NR	EPZ32488.1	988480	g53737	i0	63.4	7.48192771084337	71	26	85.5	0	248	36	186	256	EPZ32488.1 Cyclic nucleotide-binding domain-containing protein [Rozella allomycis CSF55]	diamond	1863	95.9	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
10433802	10433802	PRJNA1118794_P_NODE_1349_length_1263_cov_5.815966_g914_i0	PRJNA1118794	1349	1263	5.815966	73.45565058	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	287	1.08e-91	NR	PJF16902.1	1246581	g914	i0	64.4	5.85985748218527	236	81	55.8	3	1106	402	24	257	PJF16902.1 hypothetical protein PSACC_03283 [Paramicrosporidium saccamoebae]	diamond	7401	287	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
15533292	15533292	PRJNA1118794_P_NODE_36393_length_276_cov_2.142857_g35643_i0	PRJNA1118794	36393	276	2.142857	5.91428532	Rozella sp.	1932610	Fungi	Fungi	298	2.95e-76	NTclustered	gi\|2468791009\|gb\|OQ702919.1\|	1932610	g35643	i0	86.282	100.815217391304	277	34	99	4	1	275	3596	3870	Rozella sp. isolate PSC238 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	27825	298	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella sp.
15533507	15533507	PRJNA1118794_P_NODE_5353_length_610_cov_2.152700_g4622_i0	PRJNA1118794	5353	610	2.1527	13.13147	Rozella allomycis CSF55	988480	Fungi	Fungi	290	4.619999999999998e-96	NR	EPZ33659.1	988480	g4622	i0	74.6	6.12295081967213	177	45	87	0	601	71	74	250	EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55]	diamond	3735	290	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
20631416	20631416	PRJNA1118794_P_NODE_12257_length_409_cov_2.041667_g11507_i0	PRJNA1118794	12257	409	2.041667	8.35041803	Rozella sp.	1932610	Fungi	Fungi	226	2.19e-54	NTclustered	gi\|2468791040\|gb\|OQ702927.1\|	1932610	g11507	i0	78.202	100.332518337408	367	70	89	9	1	362	4118	4479	Rozella sp. isolate PSC259 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	41036	226	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella sp.
21426884	21426884	PRJNA1118794_P_NODE_16957_length_359_cov_1.548951_g16207_i0	PRJNA1118794	16957	359	1.548951	5.56073409	Opisthokonta	33154	Fungi	Fungi	132	4.25e-26	NTclustered	gi\|311235546\|ref\|NG_027561.1\|	281847	g16207	i0	81.212	47.0640668523677	165	29	46	2	4	167	1387	1224	Rozella allomycis UCBMG BK 47-054 28S rRNA gene, partial sequence; from reference material	blastn	16896	132	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
24456665	24456665	PRJNA1118794_P_NODE_20400_length_336_cov_1.528517_g19650_i0	PRJNA1118794	20400	336	1.528517	5.13581712	uncultured Cryptomycota	1130064	Fungi	Fungi	459	1.6e-124	NTclustered	gi\|2086101859\|gb\|MZ923420.1\|	1130064	g19650	i0	91.369	70.5714285714286	336	27	100	2	1	336	481	148	Uncultured Cryptomycota clone UMPB-674 small subunit ribosomal RNA gene, partial sequence	blastn	23712	459	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota		uncultured Cryptomycota
28647246	28647246	PRJNA1118794_P_NODE_64487_length_244_cov_5.304094_g63737_i0	PRJNA1118794	64487	244	5.304094	12.941989360000001	Rozella allomycis CSF55	988480	Fungi	Fungi	82.8	5.13e-17	NR	EPZ34692.1	988480	g63737	i0	66.2	3.86065573770492	65	21	78.7	1	18	209	190	254	EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55]	diamond	942	82.8	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
29373332	29373332	PRJNA1118794_P_NODE_4949_length_637_cov_1.567376_g4224_i0	PRJNA1118794	4949	637	1.567376	9.98418512	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	94.4	1.96e-19	NR	PJF20084.1	1246581	g4224	i0	41.7	0.54160125588697	115	66	54.2	1	437	93	46	159	PJF20084.1 hypothetical protein PSACC_00119 [Paramicrosporidium saccamoebae]	diamond	345	94.4	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);;