metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA438111" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA438111" 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
1708671	1708671	PRJNA438111_P_NODE_10442_length_317_cov_3.215278_g9819_i0	PRJNA438111	10442	317	3.215278	10.19243126	Rhizophagus irregularis	588596	Fungi	Fungi	230	1.2799999999999998e-55	NTclustered	gi\|2749798103\|ref\|XM_066147921.1\|	588596	g9819	i0	79.936	10.018927444795	314	62	99	1	1	314	651	963	Rhizophagus irregularis RuvB-like protein 1 variant 2 (OCT59_003877), mRNA	blastn	3176	230	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
5538096	5538096	PRJNA438111_P_NODE_56925_length_174_cov_3.772414_g56300_i0	PRJNA438111	56925	174	3.772414	6.56400036	Zychaea mexicana	64656	Fungi	Fungi	56.5	0.001	NTclustered	gi\|2432197672\|ref\|XM_053125885.1\|	64656	g56300	i0	100	0.344827586206897	30	0	17	0	87	116	92	63	Zychaea mexicana stress-activated map kinase interacting protein 1-domain-containing protein (BDB00DRAFT_858699), mRNA	blastn	60	56.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Zychaea	Zychaea mexicana
9362621	9362621	PRJNA438111_P_NODE_73928_length_162_cov_1.947368_g73303_i0	PRJNA438111	73928	162	1.947368	3.15473616	Acaulospora viridis	1385717	Fungi	Fungi	76.8	8e-10	NTclustered	gi\|743402873\|emb\|HG421738.1\|	1385717	g73303	i0	92.593	26.4197530864198	54	3	33	1	1	53	810	863	Acaulospora sp. JP-2013 genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate CP 100, clone 1.4	blastn	4280	76.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Acaulosporaceae	Acaulospora	Acaulospora viridis
15737271	15737271	PRJNA438111_P_NODE_75113_length_161_cov_3.174242_g74488_i0	PRJNA438111	75113	161	3.174242	5.11052962	Gigaspora margarita	4874	Fungi	Fungi	254	3.42e-63	NTclustered	gi\|530339809\|gb\|KC666029.1\|	4874	g74488	i0	95.062	98.2111801242236	162	7	100	1	1	161	413	574	Gigaspora margarita isolate WDG47 18S ribosomal RNA gene, partial sequence	blastn	15812	254	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
22110827	22110827	PRJNA438111_P_NODE_44898_length_187_cov_7.651899_g44273_i0	PRJNA438111	44898	187	7.651899	14.30905113	Rhizophagus irregularis	588596	Fungi	Fungi	122	1.2e-23	NTclustered	gi\|2749806817\|ref\|XM_025316245.2\|	588596	g44273	i0	80.117	3.01604278074866	171	28	89	6	16	181	309	140	Rhizophagus irregularis 40S ribosomal protein eS28 (OCT59_008841), mRNA	blastn	564	122	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis

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