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

9 rows where analysis = "blastn", bioproject = "PRJNA222400" 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
367255	367255	PRJNA222400_P_NODE_8201_length_166_cov_0.888889_g8168_i0	PRJNA222400	8201	166	0.888889	1.47555574	Gilbertella persicaria	101096	Fungi	Fungi	137	3.73e-28	NTclustered	gi\|2323711170\|ref\|XM_051573317.1\|	101096	g8168	i0	81.928	9.86144578313253	166	26	99	3	3	166	339	502	Gilbertella persicaria 60S ribosomal protein L15 (B0P05DRAFT_2433), mRNA	blastn	1637	137	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
6744864	6744864	PRJNA222400_P_NODE_526_length_704_cov_9.691603_g497_i0	PRJNA222400	526	704	9.691603	68.22888512	Phycomyces blakesleeanus	4837	Fungi	Fungi	342	3.73e-89	NTclustered	gi\|1069938230\|ref\|XM_018429293.1\|	763407	g497	i0	79.707	58.5596590909091	478	93	68	4	102	577	3071	3546	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	41226	342	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
10571279	10571279	PRJNA222400_P_NODE_6089_length_182_cov_1.172932_g6056_i0	PRJNA222400	6089	182	1.172932	2.13473624	Cokeromyces recurvatus	90255	Fungi	Fungi	60.2	9.25e-5	NTclustered	gi\|2324076817\|ref\|XM_051530401.1\|	90255	g6056	i0	100	1.00549450549451	32	0	18	0	86	117	2069	2038	Cokeromyces recurvatus carbamoyl-phosphate synthase L chain, ATP binding domain-containing protein (BX663DRAFT_531717), partial mRNA	blastn	183	60.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
10571294	10571294	PRJNA222400_P_NODE_7069_length_169_cov_1.733333_g7036_i0	PRJNA222400	7069	169	1.733333	2.92933277	Gamsiella multidivaricata	101098	Fungi	Fungi	106	1.07e-18	NTclustered	gi\|2323777521\|ref\|XM_051559216.1\|	101098	g7036	i0	87.778	1.68047337278107	90	11	53	0	1	90	163	252	Gamsiella multidivaricata 60S ribosomal protein L15 (BC939DRAFT_483872), partial mRNA	blastn	284	106	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
10571312	10571312	PRJNA222400_P_NODE_9149_length_163_cov_0.894737_g9116_i0	PRJNA222400	9149	163	0.894737	1.45842131	Lobosporangium transversale	64571	Fungi	Fungi	126	7.89e-25	NTclustered	gi\|1227141090\|ref\|XM_022024562.1\|	64571	g9116	i0	91.304	10.5092024539877	92	8	56	0	5	96	185	94	Lobosporangium transversale ribosomal protein L1-like protein (BCR41DRAFT_355979), mRNA	blastn	1713	126	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
12535121	12535121	PRJNA222400_P_NODE_3830_length_228_cov_1.776536_g3797_i0	PRJNA222400	3830	228	1.776536	4.05050208	Fungi	4751	Fungi	Fungi	156	1.51e-33	NTclustered	gi\|2323768457\|ref\|XM_051552000.1\|	101098	g3797	i0	80.193	30.2894736842105	207	41	91	0	22	228	330	124	Gamsiella multidivaricata ARF/SAR (BC939DRAFT_391981), partial mRNA	blastn	6906	156	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
18218900	18218900	PRJNA222400_P_NODE_7075_length_169_cov_1.733333_g7042_i0	PRJNA222400	7075	169	1.733333	2.92933277	Utharomyces epallocaulus	101125	Fungi	Fungi	191	2.87e-44	NTclustered	gi\|11078271\|gb\|AF157302.1\|AF157302	101125	g7042	i0	86.982	96.6094674556213	169	22	100	0	1	169	189	21	Utharomyces epallocaulus translation elongation factor 1-alpha (EF-1alpha) gene, partial cds	blastn	16327	191	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Pilobolaceae	Utharomyces	Utharomyces epallocaulus
19493129	19493129	PRJNA222400_P_NODE_1636_length_399_cov_0.888571_g1603_i0	PRJNA222400	1636	399	0.888571	3.54539829	Mucor velutinosus	708070	Fungi	Fungi	200	1.29e-46	NTclustered	gi\|2724913843\|ref\|XM_064820776.1\|	708070	g1603	i0	81.377	41.3709273182957	247	44	62	2	151	396	145	390	Mucor velutinosus uncharacterized protein (ATC70_001380), partial mRNA	blastn	16507	200	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor velutinosus
19493197	19493197	PRJNA222400_P_NODE_6556_length_175_cov_1.650794_g6523_i0	PRJNA222400	6556	175	1.650794	2.8888895	Gamsiella multidivaricata	101098	Fungi	Fungi	121	3.98e-23	NTclustered	gi\|2323776092\|ref\|XM_051552238.1\|	101098	g6523	i0	83.582	24.7371428571429	134	16	75	5	45	175	298	168	Gamsiella multidivaricata ras family-domain-containing protein (BC939DRAFT_395619), partial mRNA	blastn	4329	121	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata

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