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

9 rows where analysis = "blastn", bioproject = "PRJNA950981" 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
933879	933879	PRJNA950981_P_NODE_21601_length_242_cov_0.923077_g21425_i0	PRJNA950981	21601	242	0.923077	2.23384634	Gilbertella persicaria	101096	Fungi	Fungi	241	4.33e-59	NTclustered	gi\|2323722075\|ref\|XM_051576681.1\|	101096	g21425	i0	85.062	42.3388429752066	241	31	98	5	5	242	653	415	Gilbertella persicaria V-type proton ATPase subunit B (B0P05DRAFT_528882), mRNA	blastn	10246	241	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
7311874	7311874	PRJNA950981_P_NODE_15626_length_260_cov_1.668449_g15450_i0	PRJNA950981	15626	260	1.668449	4.3379674	Phycomyces blakesleeanus	4837	Fungi	Fungi	217	7.94e-52	NTclustered	gi\|1069954154\|ref\|XM_018429040.1\|	763407	g15450	i0	86.735	47.35	196	24	75	2	23	217	205	11	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	12311	217	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
7640453	7640453	PRJNA950981_P_NODE_17646_length_250_cov_3.192090_g17470_i0	PRJNA950981	17646	250	3.19209	7.980225	Fungi	4751	Fungi	Fungi	390	4.22e-104	NTclustered	gi\|658131632\|emb\|HF968958.1\|	4874	g17470	i0	94.821	150.516	251	12	100	1	1	250	2006	2256	Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 4, clone BL2_6_26	blastn	37629	390	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
8586826	8586826	PRJNA950981_P_NODE_19667_length_246_cov_0.901734_g19491_i0	PRJNA950981	19667	246	0.901734	2.21826564	Lichtheimia ornata	688661	Fungi	Fungi	222	1.5999999999999996e-53	NTclustered	gi\|2553566953\|ref\|XM_058484273.1\|	688661	g19491	i0	87.958	86.2560975609756	191	20	76	2	56	243	769	959	Lichtheimia ornata ATP synthase subunit beta, mitochondrial (O0I10_004212), partial mRNA	blastn	21219	222	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ornata
16236677	16236677	PRJNA950981_P_NODE_13413_length_281_cov_1.500000_g13237_i0	PRJNA950981	13413	281	1.5	4.215	Glomus sp. Tf 2-16	262042	Fungi	Fungi	520	5.909999999999999e-143	NTclustered	gi\|41353938\|gb\|AY522919.1\|	262042	g13237	i0	100	89.1067615658363	281	0	100	0	1	281	71	351	Glomus sp. Tf 2-16 26S ribosomal RNA gene, partial sequence	blastn	25039	520	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Glomus	Glomus sp. Tf 2-16
18785615	18785615	PRJNA950981_P_NODE_18195_length_249_cov_1.329545_g18019_i0	PRJNA950981	18195	249	1.329545	3.31056705	Glomus sp. Tf 2-16	262042	Fungi	Fungi	414	2.49e-111	NTclustered	gi\|41353938\|gb\|AY522919.1\|	262042	g18019	i0	99.134	55.9879518072289	231	1	92	1	1	230	290	520	Glomus sp. Tf 2-16 26S ribosomal RNA gene, partial sequence	blastn	13941	414	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Glomus	Glomus sp. Tf 2-16
22610816	22610816	PRJNA950981_P_NODE_12338_length_292_cov_2.374429_g12162_i0	PRJNA950981	12338	292	2.374429	6.93333268	Phycomyces blakesleeanus	4837	Fungi	Fungi	217	9.07e-52	NTclustered	gi\|1069959073\|ref\|XM_018429708.1\|	763407	g12162	i0	89.143	33.6986301369863	175	17	60	2	113	286	104	277	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	9840	217	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
23886196	23886196	PRJNA950981_P_NODE_10399_length_316_cov_1.226337_g10223_i0	PRJNA950981	10399	316	1.226337	3.87522492	uncultured Glomeromycotina	241622	Fungi	Fungi	106	2.24e-18	NTclustered	gi\|2863800393\|gb\|PQ669850.1\|	241622	g10223	i0	92	4.63291139240506	75	6	24	0	14	88	804	878	Uncultured Glomeromycotina isolate HbAMF84 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	1464	106	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota					uncultured Glomeromycotina
24214115	24214115	PRJNA950981_P_NODE_10519_length_314_cov_1.489627_g10343_i0	PRJNA950981	10519	314	1.489627	4.67742878	Fungi	4751	Fungi	Fungi	267	9.64e-67	NTclustered	gi\|1069936519\|ref\|XM_018440025.1\|	763407	g10343	i0	82.484	87.4936305732484	314	46	99	6	1	311	136	443	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	27473	267	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus

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