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

14 rows where analysis = "blastn", bioproject = "PRJEB81327" 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
139501	139501	PRJEB81327_P_NODE_11101_length_408_cov_5.232836_g10493_i0	PRJEB81327	11101	408	5.232836	21.34997088	Physarum polycephalum	5791	Evosea	other_Eukaryota	497	4.19e-136	NTclustered	gi\|3221\|emb\|V01159.1\|	5791	g10493	i0	88.862	55.8455882352941	413	34	99	10	1	405	1531	1939	Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA	blastn	22785	497	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
139779	139779	PRJEB81327_P_NODE_33701_length_272_cov_1.155779_g33093_i0	PRJEB81327	33701	272	1.155779	3.14371888	Stemonitopsis subcaespitosa	1048528	Evosea	other_Eukaryota	370	6.07e-98	NTclustered	gi\|426281760\|gb\|JX681133.1\|	1048528	g33093	i0	91.176	98.7352941176471	272	24	100	0	1	272	284	13	Stemonitopsis subcaespitosa actin gene, partial cds	blastn	26856	370	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Stemonitida	Stemonitidae	Stemonitopsis	Stemonitopsis subcaespitosa
140261	140261	PRJEB81327_P_NODE_8781_length_468_cov_1.455696_g8173_i0	PRJEB81327	8781	468	1.455696	6.81265728	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	257	8.980000000000001e-64	NTclustered	gi\|167938\|gb\|M23749.1\|DDIUBIQB	44689	g8173	i0	79.177	68.8076923076923	389	68	82	11	36	420	389	10	D.discoideum ubiquitin mRNA, complete cds, clone DCUBV45	blastn	32202	257	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
2271931	2271931	PRJEB81327_P_NODE_17262_length_325_cov_1.436508_g16654_i0	PRJEB81327	17262	325	1.436508	4.668651	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.031	NTclustered	gi\|2104813\|emb\|Y13119.1\|	44689	g16654	i0	100	0.344615384615385	28	0	9	0	39	66	2037	2010	Dictyostelium discoideum mRNA for CudA protein	blastn	112	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
2690309	2690309	PRJEB81327_P_NODE_67403_length_232_cov_2.591195_g66795_i0	PRJEB81327	67403	232	2.591195	6.0115724	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	182	2.54e-41	NTclustered	gi\|330801204\|ref\|XM_003288572.1\|	5786	g66795	i0	81.498	4.20689655172414	227	36	97	5	6	229	214	437	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92126), mRNA	blastn	976	182	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
4824880	4824880	PRJEB81327_P_NODE_1924_length_1106_cov_2.766699_g1534_i0	PRJEB81327	1924	1106	2.766699	30.59969094	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	787	0	NTclustered	gi\|511083902\|dbj\|AK419160.1\|	5759	g1534	i0	80.633	94.246835443038	1043	180	93	20	7	1038	1060	29	Entamoeba histolytica cDNA clone: Xeh-003B20, actin, complete cds, strain: HM-1:IMSS	blastn	104237	787	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
6518474	6518474	PRJEB81327_P_NODE_9266_length_453_cov_2.136842_g8658_i0	PRJEB81327	9266	453	2.136842	9.67989426	Entamoeba dispar	46681	Evosea	other_Eukaryota	154	1.17e-32	NTclustered	gi\|167389105\|ref\|XM_001738768.1\|	370354	g8658	i0	78.8	1.45695364238411	250	38	53	12	212	453	246	4	Entamoeba dispar SAW760 40S ribosomal protein S17-A, putative (EDI_100200), partial mRNA	blastn	660	154	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
8649960	8649960	PRJEB81327_P_NODE_17047_length_327_cov_1.606299_g16439_i0	PRJEB81327	17047	327	1.606299	5.25259773	Dictyostelium	5782	Evosea	other_Eukaryota	313	1.28e-80	NTclustered	gi\|7274\|emb\|X55973.1\|	44689	g16439	i0	84.049	97.7981651376147	326	50	99	2	1	325	802	478	D. discoideum EF1-I gene for elongation factor 1 alpha	blastn	31980	313	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
9067172	9067172	PRJEB81327_P_NODE_39788_length_261_cov_2.909574_g39180_i0	PRJEB81327	39788	261	2.909574	7.59398814	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	243	1.3200000000000001e-59	NTclustered	gi\|470239206\|ref\|XM_004351317.1\|	261658	g39180	i0	88.889	25.6130268199234	198	20	75	2	3	199	197	1	Cavenderia fasciculata Rho GTPase (rac1A), partial mRNA	blastn	6685	243	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
15442290	15442290	PRJEB81327_P_NODE_32593_length_274_cov_1.174129_g31985_i0	PRJEB81327	32593	274	1.174129	3.21711346	Arcyria sp. 'tenuissima'	3129282	Evosea	other_Eukaryota	392	1.3099999999999999e-104	NTclustered	gi\|2698738389\|gb\|PP491458.1\|	3129282	g31985	i0	92.419	1.01094890510949	277	17	99	2	1	273	3573	3849	Arcyria sp. 'tenuissima' voucher sc32644 internal transcribed spacer region, partial sequence	blastn	277	392	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Arcyria	Arcyria sp. 'tenuissima'
15442678	15442678	PRJEB81327_P_NODE_62813_length_242_cov_0.911243_g62205_i0	PRJEB81327	62813	242	0.911243	2.20520806	Echinostelium minutum	300235	Evosea	other_Eukaryota	281	2.55e-71	NTclustered	gi\|210062522\|gb\|AY842034.2\|	300235	g62205	i0	88.115	2.02066115702479	244	19	99	10	4	242	1003	1241	Echinostelium minutum strain ATCC 22345 18S ribosomal RNA gene, partial sequence	blastn	489	281	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Echinosteliales	Echinosteliidae	Echinostelium	Echinostelium minutum
16716340	16716340	PRJEB81327_P_NODE_18254_length_316_cov_1.880658_g17646_i0	PRJEB81327	18254	316	1.880658	5.94287928	Arcyria sp. 'tenuissima'	3129282	Evosea	other_Eukaryota	307	5.720000000000001e-79	NTclustered	gi\|2698738389\|gb\|PP491458.1\|	3129282	g17646	i0	84.444	35.1835443037975	315	46	99	2	3	316	1030	718	Arcyria sp. 'tenuissima' voucher sc32644 internal transcribed spacer region, partial sequence	blastn	11118	307	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Arcyria	Arcyria sp. 'tenuissima'
20540724	20540724	PRJEB81327_P_NODE_31737_length_275_cov_1.524752_g31129_i0	PRJEB81327	31737	275	1.524752	4.193068	Physarum albescens	289948	Evosea	other_Eukaryota	473	4.55e-129	NTclustered	gi\|381139256\|emb\|HE655073.1\|	289948	g31129	i0	97.818	46.0654545454545	275	4	100	1	1	275	1059	1331	Physarum albescens partial 28S rRNA gene, isolate Fr-K2	blastn	12668	473	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum albescens
21816855	21816855	PRJEB81327_P_NODE_58178_length_245_cov_0.895349_g57570_i0	PRJEB81327	58178	245	0.895349	2.19360505	Heterostelium album	2086695	Evosea	other_Eukaryota	156	1.64e-33	NTclustered	gi\|1160571874\|ref\|XM_020575431.1\|	670386	g57570	i0	85.43	4.17551020408163	151	20	61	2	47	196	257	108	Polysphondylium pallidum PN500 S60 ribosomal protein L36a (rpl36a), partial mRNA	blastn	1023	156	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album

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