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

9 rows where analysis = "blastn", bioproject = "PRJNA380129" and tax_kingdom = "Fungi"

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
3624853	3624853	PRJNA380129_P_NODE_1103_length_604_cov_1.363478_g792_i0	PRJNA380129	1103	604	1.363478	8.23540712	root	1	Root_unresolved	Root_unresolved	291	1.1599999999999998e-73	NTclustered	gi\|85002188\|gb\|DQ341383.1\|	5061	g792	i0	100	68.2698675496689	157	0	68	0	448	604	1236	1392	Aspergillus niger strain 094811 18S ribosomal RNA gene, partial sequence	blastn	41235	291	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus niger
6177045	6177045	PRJNA380129_P_NODE_2985_length_353_cov_5.391975_g2661_i0	PRJNA380129	2985	353	5.391975	19.03367175	Aspergillus	5052	Fungi	Fungi	627	4.359999999999999e-175	NTclustered	gi\|158535183\|gb\|EF652038.1\|	469263	g2661	i0	99.708	96.8781869688385	342	1	97	0	1	342	559	900	Aspergillus sp. NRRL 145 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	34198	632	0.992088607594937	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus sp. NRRL 145
6779731	6779731	PRJNA380129_P_NODE_1266_length_527_cov_1.522088_g950_i0	PRJNA380129	1266	527	1.522088	8.02140376	Malassezia restricta	76775	Fungi	Fungi	475	2.5899999999999994e-129	NTclustered	gi\|1321659621\|gb\|KY911094.1\|	76775	g950	i0	99.617	44.6508538899431	261	0	72	1	268	527	2195	1935	Malassezia restricta mitochondrion, complete genome	blastn	23531	475	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
8055239	8055239	PRJNA380129_P_NODE_1487_length_465_cov_1.584862_g1166_i0	PRJNA380129	1487	465	1.584862	7.3696083	Aspergillus verrucosus	3033834	Fungi	Fungi	364	5.109999999999999e-96	NTclustered	gi\|2666209008\|dbj\|LC797029.1\|	3033834	g1166	i0	99.015	63.0903225806452	203	2	63	0	1	203	32099	31897	Aspergillus verrucosus NBRC 115547 mitochondrial DNA, complete genome	blastn	29337	364	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus verrucosus
15101929	15101929	PRJNA380129_P_NODE_832_length_694_cov_1.798496_g528_i0	PRJNA380129	832	694	1.798496	12.48156224	root	1	Root_unresolved	Root_unresolved	63.9	3.2e-5	NTclustered	gi\|2749703766\|ref\|XM_014090103.2\|	63577	g528	i0	93.333	0.345821325648415	45	0	6	1	633	677	2257	2216	Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA	blastn	240	63.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae	Trichoderma	Trichoderma atroviride
22078530	22078530	PRJNA380129_P_NODE_1258_length_531_cov_2.952191_g942_i0	PRJNA380129	1258	531	2.952191	15.67613421	Vuilleminia pseudocystidiata	47061	Fungi	Fungi	448	5.689999999999999e-121	NTclustered	gi\|1473261214\|gb\|MH874158.1\|	47061	g942	i0	100	62.8323917137476	242	0	61	0	41	282	23	264	Vuilleminia pseudocystidiata culture CBS:347.95 strain CBS 347.95 large subunit ribosomal RNA gene, partial sequence	blastn	33364	448	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Corticiales	Vuilleminiaceae	Vuilleminia	Vuilleminia pseudocystidiata
22078534	22078534	PRJNA380129_P_NODE_3378_length_215_cov_3.220430_g3054_i0	PRJNA380129	3378	215	3.22043	6.9239245	Pseudoloma neurophilia	146866	Fungi	Fungi	390	3.54e-104	NTclustered	gi\|11993647\|gb\|AF322654.1\|	146866	g3054	i0	100	95.9581395348837	211	0	98	0	5	215	1255	1045	Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	20631	390	1	Eukaryota	Opisthokonta	Fungi	Microsporidia				Pseudoloma	Pseudoloma neurophilia
23354052	23354052	PRJNA380129_P_NODE_3199_length_283_cov_2.751969_g2875_i0	PRJNA380129	3199	283	2.751969	7.78807227	Paxillus rubicundulus	463315	Fungi	Fungi	141	5.42e-29	NTclustered	gi\|1778128217\|ref\|NC_045204.1\|	463315	g2875	i0	100	25.1413427561837	76	0	27	0	116	191	20185	20110	Paxillus rubicundulus mitochondrion, complete genome	blastn	7115	141	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Paxillaceae	Paxillus	Paxillus rubicundulus
24628295	24628295	PRJNA380129_P_NODE_1420_length_479_cov_2.273333_g1101_i0	PRJNA380129	1420	479	2.273333	10.88926507	Wolfiporia cocos	81056	Fungi	Fungi	462	1.82e-125	NTclustered	gi\|126508724\|gb\|EF397600.1\|	81056	g1101	i0	100	72.3465553235908	250	0	68	0	230	479	1559	1808	Poria cocos strain KANP No. 7233 28S ribosomal RNA gene, partial sequence	blastn	34654	462	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Phaeolaceae	Wolfiporia	Wolfiporia cocos

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