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

9 rows where analysis = "blastn", bioproject = "PRJNA615351" and tax_phylum = "Zoopagomycota"

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
595502	595502	PRJNA615351_P_NODE_125181_length_237_cov_1.584158_g111081_i0	PRJNA615351	125181	237	1.584158	3.75445446	Coemansia reversa	61392	Fungi	Fungi	191	4.3200000000000003e-44	NTclustered	gi\|358030855\|dbj\|AB609161.1\|	61392	g111081	i0	84.422	36.6497890295359	199	25	83	6	42	237	1330	1525	Coemansia reversa EF2 gene for translation elongation factor 2, partial cds, strain: NRRL 1564	blastn	8686	191	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia reversa
9524214	9524214	PRJNA615351_P_NODE_44568_length_816_cov_9.729834_g33385_i0	PRJNA615351	44568	816	9.729834	79.39544544	Linderina pennispora	61395	Fungi	Fungi	254	2.09e-62	NTclustered	gi\|2028322926\|ref\|XM_040888010.1\|	61395	g33385	i0	78.372	32.9436274509804	393	83	48	2	408	799	915	524	Linderina pennispora 60S ribosomal protein L10-A (DL89DRAFT_268696), partial mRNA	blastn	26882	254	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
11353326	11353326	PRJNA615351_P_NODE_127529_length_231_cov_3.260204_g113429_i0	PRJNA615351	127529	231	3.260204	7.53107124	Entomophthoraceae	34481	Fungi	Fungi	411	2.9599999999999995e-110	NTclustered	gi\|1776904868\|gb\|MN706588.1\|	176680	g113429	i0	98.701	88.8268398268398	231	3	100	0	1	231	338	108	Furia ithacensis strain FiMD2 large subunit ribosomal RNA gene, partial sequence	blastn	20519	411	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Furia	Furia ithacensis
12074992	12074992	PRJNA615351_P_NODE_187490_length_150_cov_1.226087_g173390_i0	PRJNA615351	187490	150	1.226087	1.8391305	Pandora neoaphidis	76017	Fungi	Fungi	278	1.85e-70	NTclustered	gi\|145308024\|gb\|EF392560.1\|	76017	g173390	i0	100	82.7666666666667	150	0	100	0	1	150	632	781	Pandora neoaphidis strain ARSEF 3240 18S ribosomal RNA gene, partial sequence	blastn	12415	278	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Pandora	Pandora neoaphidis
21551854	21551854	PRJNA615351_P_NODE_144097_length_199_cov_1.731707_g129997_i0	PRJNA615351	144097	199	1.731707	3.44609693	Entomophthoraceae	34481	Fungi	Fungi	357	3.2699999999999996e-94	NTclustered	gi\|18033614\|gb\|AF351134.1\|AF351134	176680	g129997	i0	98.995	100.266331658291	199	2	100	0	1	199	1456	1654	Furia ithacensis small subunit ribosomal RNA gene, partial sequence	blastn	19953	357	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Furia	Furia ithacensis
22272689	22272689	PRJNA615351_P_NODE_132598_length_220_cov_2.589189_g118498_i0	PRJNA615351	132598	220	2.589189	5.6962158	Neozygites floridana	164420	Fungi	Fungi	405	1.2999999999999997e-108	NTclustered	gi\|22535856\|gb\|AF296759.1\|	164420	g118498	i0	100	30.4772727272727	219	0	99	0	2	220	297	79	Neozygites sp. ARSEF 662 small subunit ribosomal RNA gene, partial sequence	blastn	6705	405	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Neozygitomycetes	Neozygitales	Neozygitaceae	Neozygites	Neozygites floridana
22272797	22272797	PRJNA615351_P_NODE_163038_length_173_cov_1.442029_g148938_i0	PRJNA615351	163038	173	1.442029	2.49471017	Kickxella alabastrina	61397	Fungi	Fungi	110	8.5e-20	NTclustered	gi\|2323999502\|ref\|XM_051534073.1\|	61397	g148938	i0	80	7.79190751445087	150	28	86	2	14	162	290	142	Kickxella alabastrina putative RPL43B-60S large subunit ribosomal protein (BX661DRAFT_175458), mRNA	blastn	1348	110	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
22273118	22273118	PRJNA615351_P_NODE_87338_length_380_cov_2.301449_g73263_i0	PRJNA615351	87338	380	2.301449	8.7455062	Linderina pennispora	61395	Fungi	Fungi	52.8	0.036	NTclustered	gi\|2028320870\|ref\|XM_040884338.1\|	61395	g73263	i0	100	0.0736842105263158	28	0	7	0	303	330	211	184	Linderina pennispora acid phosphatase/Vanadium-dependent haloperoxidase (DL89DRAFT_217852), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
22827363	22827363	PRJNA615351_P_NODE_168798_length_166_cov_91.061069_g154698_i0	PRJNA615351	168798	166	91.061069	151.16137454	Entomophthoraceae	34481	Fungi	Fungi	246	5.94e-61	NTclustered	gi\|1269236915\|gb\|MG252968.1\|	42210	g154698	i0	97.241	96.5542168674699	145	4	87	0	20	164	836	980	Zoophthora radicans voucher 41 small subunit ribosomal RNA gene, partial sequence	blastn	16028	246	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Zoophthora	Zoophthora radicans

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