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

9 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax_phylum = "Evosea"

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
2211501	2211501	PRJNA951810_P_NODE_151582_length_256_cov_10.136612_g151237_i0	PRJNA951810	151582	256	10.136612	25.94972672	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	52.8	0.023	NTclustered	gi\|330804915\|ref\|XM_003290387.1\|	5786	g151237	i0	100	0.109375	28	0	11	0	70	97	189	216	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_81152), partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
2211933	2211933	PRJNA951810_P_NODE_180182_length_232_cov_2.402516_g179837_i0	PRJNA951810	180182	232	2.402516	5.57383712	Dictyostelium citrinum	361072	Evosea	other_Eukaryota	135	2e-27	NTclustered	gi\|294662991\|ref\|NC_007787.2\|	361072	g179837	i0	82.209	18.2715517241379	163	23	68	6	31	188	21376	21537	Dictyostelium citrinum mitochondrion, complete genome	blastn	4239	135	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium citrinum
6366947	6366947	PRJNA951810_P_NODE_104525_length_290_cov_3.870968_g104181_i0	PRJNA951810	104525	290	3.870968	11.2258072	Didymium	5792	Evosea	other_Eukaryota	462	1.05e-125	NTclustered	gi\|25989341\|gb\|AY062881.1\|	181200	g104181	i0	95.517	40.9034482758621	290	12	100	1	1	290	628	916	Hyperamoeba dachnaya small subunit ribosomal RNA gene, partial sequence	blastn	11862	462	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium dachnayum
9864308	9864308	PRJNA951810_P_NODE_157988_length_251_cov_5.297753_g157643_i0	PRJNA951810	157988	251	5.297753	13.29736003	Cribraria violacea	1334538	Evosea	other_Eukaryota	248	2.7e-61	NTclustered	gi\|501417113\|gb\|JX481322.1\|	1334538	g157643	i0	84.706	88.1075697211155	255	31	100	7	1	251	761	511	Cribraria violacea voucher AMFD172 elongation factor 1A (EF1A) gene, partial cds	blastn	22115	248	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Liceales	Cribrariaceae	Cribraria	Cribraria violacea
12743104	12743104	PRJNA951810_P_NODE_35930_length_329_cov_1.484375_g35587_i0	PRJNA951810	35930	329	1.484375	4.88359375	Flamella	490353	Evosea	other_Eukaryota	608	1.4599999999999995e-169	NTclustered	gi\|163943978\|gb\|EU186022.1\|	490515	g35587	i0	100	98.8632218844985	329	0	100	0	1	329	687	1015	Flamella arnhemensis 18S ribosomal RNA gene, partial sequence	blastn	32526	608	1	Eukaryota	Amoebozoa	Evosea	Variosea		Flamellidae	Flamella	Flamella arnhemensis
13689476	13689476	PRJNA951810_P_NODE_129771_length_273_cov_3.675000_g129426_i0	PRJNA951810	129771	273	3.675	10.03275	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	148	3.11e-31	NTclustered	gi\|330805894\|ref\|XM_003290864.1\|	5786	g129426	i0	86.232	1.73626373626374	138	18	50	1	64	200	259	122	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_81609), partial mRNA	blastn	474	148	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
16239262	16239262	PRJNA951810_P_NODE_168773_length_243_cov_4.164706_g168428_i0	PRJNA951810	168773	243	4.164706	10.12023558	Didymium environmental sample	1173723	Evosea	other_Eukaryota	121	5.92e-23	NTclustered	gi\|407196931\|gb\|JX545305.1\|	1173723	g168428	i0	77.391	19.0205761316872	230	35	90	11	26	243	1	225	Didymium environmental sample clone HCA_D08-36 28S ribosomal RNA gene, partial sequence	blastn	4622	121	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae		Didymium environmental sample
16239265	16239265	PRJNA951810_P_NODE_168993_length_243_cov_2.882353_g168648_i0	PRJNA951810	168993	243	2.882353	7.00411779	Heterostelium album	2086695	Evosea	other_Eukaryota	122	1.6499999999999995e-23	NTclustered	gi\|1160571044\|ref\|XM_020575016.1\|	670386	g168648	i0	81.046	1.16460905349794	153	29	63	0	89	241	435	283	Polysphondylium pallidum PN500 40S ribosomal protein S14 (rps14), partial mRNA	blastn	283	122	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
20064717	20064717	PRJNA951810_P_NODE_79356_length_299_cov_4.402655_g79012_i0	PRJNA951810	79356	299	4.402655	13.16393845	Acytostelium leptosomum	133408	Evosea	other_Eukaryota	449	8.440000000000001e-122	NTclustered	gi\|1057487862\|gb\|KX539491.1\|	133408	g79012	i0	93.291	104.230769230769	313	7	100	1	1	299	1398	1710	Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds	blastn	31165	449	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium leptosomum

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