metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA641991" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA641991" and tax_phylum = "Mucoromycota"

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
4445475	4445475	PRJNA641991_S_NODE_5144_length_237_cov_1.888298_g5025_i0	PRJNA641991	5144	237	1.888298	4.47526626	Rhizophagus irregularis	588596	Fungi	Fungi	84.2	7.54e-12	NTclustered	gi\|2749821332\|ref\|XM_025314831.2\|	588596	g5025	i0	90.476	0.561181434599156	63	6	27	0	175	237	204	266	Rhizophagus irregularis uncharacterized protein (OCT59_018453), mRNA	blastn	133	84.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
6262099	6262099	PRJNA641991_S_NODE_9505_length_184_cov_0.985185_g9386_i0	PRJNA641991	9505	184	0.985185	1.8127404	Mucorales	4827	Fungi	Fungi	134	5.45e-27	NTclustered	gi\|2323750583\|ref\|XM_051548529.1\|	101107	g9386	i0	82.667	37.4239130434783	150	26	82	0	32	181	236	385	Halteromyces radiatus 40S ribosomal protein S23 (BX664DRAFT_366607), partial mRNA	blastn	6886	134	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
6996314	6996314	PRJNA641991_S_NODE_10546_length_176_cov_1.133858_g10427_i0	PRJNA641991	10546	176	1.133858	1.99559008	Rhizophagus irregularis	588596	Fungi	Fungi	91.6	3.15e-14	NTclustered	gi\|2749821943\|ref\|XM_025321019.2\|	588596	g10427	i0	84.211	28.4034090909091	95	13	53	2	83	176	1331	1238	Rhizophagus irregularis uncharacterized protein (OCT59_018788), mRNA	blastn	4999	91.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
10821971	10821971	PRJNA641991_S_NODE_11149_length_172_cov_1.113821_g11030_i0	PRJNA641991	11149	172	1.113821	1.91577212	Rhizomucor pusillus	4840	Fungi	Fungi	132	1.8e-26	NTclustered	gi\|2837732244\|ref\|XM_069388582.1\|	4840	g11030	i0	80.588	21.3837209302326	170	33	99	0	1	170	136	305	Rhizomucor pusillus uncharacterized protein (VTP01DRAFT_9359), partial mRNA	blastn	3678	132	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
10821974	10821974	PRJNA641991_S_NODE_11869_length_167_cov_1.559322_g11750_i0	PRJNA641991	11869	167	1.559322	2.60406774	Gilbertella persicaria	101096	Fungi	Fungi	167	4.79e-37	NTclustered	gi\|2323735675\|ref\|XM_051574429.1\|	101096	g11750	i0	85.535	1.8502994011976	159	23	95	0	5	163	975	1133	Gilbertella persicaria acyl-CoA dehydrogenase/oxidase (B0P05DRAFT_468359), partial mRNA	blastn	309	167	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
13371806	13371806	PRJNA641991_S_NODE_13311_length_164_cov_0.886957_g13192_i0	PRJNA641991	13311	164	0.886957	1.45460948	Halteromyces radiatus	101107	Fungi	Fungi	139	1.02e-28	NTclustered	gi\|2323758632\|ref\|XM_051547161.1\|	101107	g13192	i0	82.209	1.98780487804878	163	27	99	2	3	164	805	966	Halteromyces radiatus RuvB-like 1 (BX664DRAFT_342530), mRNA	blastn	326	139	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
22294901	22294901	PRJNA641991_S_NODE_6518_length_215_cov_1.536145_g6399_i0	PRJNA641991	6518	215	1.536145	3.30271175	Cokeromyces recurvatus	90255	Fungi	Fungi	195	2.98e-45	NTclustered	gi\|2324086443\|ref\|XM_051524341.1\|	90255	g6399	i0	83.981	20.2139534883721	206	30	95	3	12	215	541	337	Cokeromyces recurvatus ATP synthase subunit alpha (BX663DRAFT_480549), partial mRNA	blastn	4346	195	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
22835842	22835842	PRJNA641991_S_NODE_3438_length_285_cov_1.194915_g3319_i0	PRJNA641991	3438	285	1.194915	3.40550775	Opisthokonta	33154	Fungi	Fungi	239	1.88e-58	NTclustered	gi\|2324074678\|ref\|XM_051607598.1\|	29922	g3319	i0	85.345	40.4035087719298	232	32	81	2	43	273	222	452	Mucor mucedo ATP synthase subunit alpha (EV154DRAFT_607207), mRNA	blastn	11515	239	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor mucedo
23570522	23570522	PRJNA641991_S_NODE_8439_length_193_cov_1.298611_g8320_i0	PRJNA641991	8439	193	1.298611	2.50631923	Radiomyces spectabilis	64574	Fungi	Fungi	60.2	9.94e-5	NTclustered	gi\|2323706754\|ref\|XM_051566731.1\|	64574	g8320	i0	97.143	1.48186528497409	35	1	18	0	6	40	2166	2200	Radiomyces spectabilis WD40-repeat-containing domain protein (BYT42DRAFT_555996), mRNA	blastn	286	60.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Radiomycetaceae	Radiomyces	Radiomyces spectabilis

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