metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA352850" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA352850" and tax_clade = "Amoebozoa"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
395185	395185	PRJNA352850_P_NODE_25441_length_547_cov_10.277108_g22622_i0	PRJNA352850	25441	547	10.277108	56.21578076	Ripella sp. 805	1217113	Discosea	other_Eukaryota	857	0	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g22622	i0	95.404	99.5393053016453	544	16	99	9	8	547	1	539	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	54448	857	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805
1669897	1669897	PRJNA352850_P_NODE_28182_length_510_cov_6.646421_g25356_i0	PRJNA352850	28182	510	6.646421	33.8967471	Ripella decalvata	2047822	Discosea	other_Eukaryota	610	6.569999999999997e-170	NTclustered	gi\|1269228423\|gb\|MF683548.1\|	2047822	g25356	i0	94.71	77.6196078431373	397	13	77	7	1	392	1165	1558	Ripella decalvata clone 26.2.2 18S ribosomal RNA gene, partial sequence	blastn	39586	610	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella decalvata
5498852	5498852	PRJNA352850_P_NODE_28325_length_508_cov_6.653595_g25499_i0	PRJNA352850	28325	508	6.653595	33.8002626	Ripella sp. 805	1217113	Discosea	other_Eukaryota	850	0	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g25499	i0	96.857	102.092519685039	509	14	100	2	1	508	1044	537	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	51863	850	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805
5499520	5499520	PRJNA352850_P_NODE_50385_length_339_cov_2.431034_g47552_i0	PRJNA352850	50385	339	2.431034	8.24120526	Physarum cinereum	289951	Evosea	other_Eukaryota	579	1.1899999999999996e-160	NTclustered	gi\|374255699\|emb\|HE614599.1\|	289951	g47552	i0	98.48	72.7994100294985	329	4	97	1	11	339	1098	771	Physarum cinereum partial 18S rRNA gene, strain Idn-2	blastn	24679	579	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum cinereum
6772764	6772764	PRJNA352850_P_NODE_25946_length_540_cov_2.619145_g23124_i0	PRJNA352850	25946	540	2.619145	14.143383	Polyschismium peyerimhoffii	2911783	Evosea	other_Eukaryota	388	3.5599999999999997e-103	NTclustered	gi\|2161226355\|gb\|MZ313553.1\|	2911783	g23124	i0	80.316	31.5962962962963	569	67	100	33	1	540	7001	6449	Polyschismium peyerimhoffii 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	17062	388	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Polyschismium	Polyschismium peyerimhoffii
8048060	8048060	PRJNA352850_P_NODE_14367_length_827_cov_6.399743_g11785_i0	PRJNA352850	14367	827	6.399743	52.92587461	Physarum cinereum	289951	Evosea	other_Eukaryota	1423	0	NTclustered	gi\|374255699\|emb\|HE614599.1\|	289951	g11785	i0	99.871	80.1874244256348	773	1	93	0	54	826	1	773	Physarum cinereum partial 18S rRNA gene, strain Idn-2	blastn	66315	1423	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum cinereum
8048441	8048441	PRJNA352850_P_NODE_26507_length_532_cov_7.105590_g23684_i0	PRJNA352850	26507	532	7.10559	37.8017388	Physarum cinereum	289951	Evosea	other_Eukaryota	977	0	NTclustered	gi\|374255699\|emb\|HE614599.1\|	289951	g23684	i0	99.812	97.562030075188	533	0	100	1	1	532	1216	1748	Physarum cinereum partial 18S rRNA gene, strain Idn-2	blastn	51903	977	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum cinereum
8048461	8048461	PRJNA352850_P_NODE_27207_length_523_cov_3.839662_g24383_i0	PRJNA352850	27207	523	3.839662	20.08143226	Fuligo septica	159720	Evosea	other_Eukaryota	263	2.18e-65	NTclustered	gi\|37515398\|emb\|AJ584697.1\|	159720	g24383	i0	89.252	7.62523900573614	214	18	41	4	1	212	13793	14003	Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1	blastn	3988	263	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Fuligo	Fuligo septica
11873469	11873469	PRJNA352850_P_NODE_16950_length_732_cov_3.768668_g14276_i0	PRJNA352850	16950	732	3.768668	27.58664976	Cochliopodium spiniferum	313558	Discosea	other_Eukaryota	739	0	NTclustered	gi\|330902897\|gb\|JF298273.1\|	313558	g14276	i0	84.973	99.9945355191257	732	106	99	4	3	732	52	781	Cochliopodium spiniferum clone 5102 actin gene, partial cds	blastn	73196	739	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium spiniferum
13148663	13148663	PRJNA352850_P_NODE_22411_length_599_cov_2.760000_g19621_i0	PRJNA352850	22411	599	2.76	16.5324	Physarum polycephalum	5791	Evosea	other_Eukaryota	276	3.23e-69	NTclustered	gi\|3221\|emb\|V01159.1\|	5791	g19621	i0	84.669	22.8363939899833	287	33	47	8	163	442	1333	1051	Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA	blastn	13679	276	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
15699155	15699155	PRJNA352850_P_NODE_69493_length_269_cov_3.963636_g66660_i0	PRJNA352850	69493	269	3.963636	10.66218084	Physarum albescens	289948	Evosea	other_Eukaryota	473	4.439999999999999e-129	NTclustered	gi\|381139256\|emb\|HE655073.1\|	289948	g66660	i0	98.507	65.5613382899628	268	4	99	0	2	269	1490	1223	Physarum albescens partial 28S rRNA gene, isolate Fr-K2	blastn	17636	473	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum albescens
16972124	16972124	PRJNA352850_P_NODE_13214_length_880_cov_3.690734_g10692_i0	PRJNA352850	13214	880	3.690734	32.4784592	Physarum polycephalum	5791	Evosea	other_Eukaryota	867	0	NTclustered	gi\|3221\|emb\|V01159.1\|	5791	g10692	i0	84.684	37.7522727272727	901	103	100	29	1	880	2410	1524	Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA	blastn	33222	867	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
19522610	19522610	PRJNA352850_P_NODE_7896_length_1306_cov_19.676213_g5836_i0	PRJNA352850	7896	1306	19.676213	256.97134178	Stemonitopsis subcaespitosa	1048528	Evosea	other_Eukaryota	1075	0	NTclustered	gi\|426281760\|gb\|JX681133.1\|	1048528	g5836	i0	88.44	82.9073506891271	891	103	68	0	189	1079	896	6	Stemonitopsis subcaespitosa actin gene, partial cds	blastn	108277	1075	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Stemonitida	Stemonitidae	Stemonitopsis	Stemonitopsis subcaespitosa
25298001	25298001	PRJNA352850_P_NODE_80820_length_248_cov_1.457286_g77987_i0	PRJNA352850	80820	248	1.457286	3.61406928	root	1	Root_unresolved	Root_unresolved	62.1	3.73e-5	NTclustered	gi\|330798879\|ref\|XM_003287429.1\|	5786	g77987	i0	94.872	15.1935483870968	39	2	16	0	91	129	1132	1094	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_32526), partial mRNA	blastn	3768	62.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum

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