metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA781196" 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
759286	759286	PRJNA781196_P_NODE_40081_length_283_cov_1.100000_g39704_i0	PRJNA781196	40081	283	1.1	3.113	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	180	1.15e-40	NTclustered	gi\|268638122\|ref\|XM_638368.2\|	352472	g39704	i0	79.104	10.6961130742049	268	50	94	4	14	279	404	141	Dictyostelium discoideum AX4 ubiquitin-conjugating enzyme E2 (rad6) mRNA, complete cds	blastn	3027	180	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
1211190	1211190	PRJNA781196_P_NODE_27841_length_330_cov_1.214008_g27464_i0	PRJNA781196	27841	330	1.214008	4.0062264	Dictyostelium	5782	Evosea	other_Eukaryota	217	1.04e-51	NTclustered	gi\|2274919\|emb\|AJ000063.1\|	44689	g27464	i0	82.213	48.7848484848485	253	44	77	1	27	279	359	108	Dictyostelium discoideum mRNA for ADP-ribosylation factor 1	blastn	16099	217	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
7137783	7137783	PRJNA781196_P_NODE_28346_length_328_cov_0.917647_g27969_i0	PRJNA781196	28346	328	0.917647	3.00988216	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	244	4.7399999999999996e-60	NTclustered	gi\|66800824\|ref\|XM_629336.1\|	352472	g27969	i0	84.553	5.70121951219512	246	38	75	0	49	294	246	1	Dictyostelium discoideum AX4 Ras GTPase (rasD) mRNA, complete cds	blastn	1870	244	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
7137839	7137839	PRJNA781196_P_NODE_31846_length_312_cov_1.305439_g31469_i0	PRJNA781196	31846	312	1.305439	4.07296968	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	198	3.54e-46	NTclustered	gi\|330818907\|ref\|XM_003291484.1\|	5786	g31469	i0	78.526	15.875	312	60	99	5	4	312	102	409	Dictyostelium purpureum ribosomal protein L10E (DICPUDRAFT_92700), mRNA	blastn	4953	198	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
7589338	7589338	PRJNA781196_P_NODE_52046_length_252_cov_0.871508_g51669_i0	PRJNA781196	52046	252	0.871508	2.19620016	Dictyosteliaceae	2058185	Evosea	other_Eukaryota	158	4.71e-34	NTclustered	gi\|1057487858\|gb\|KX539489.1\|	142831	g51669	i0	83.735	10.0396825396825	166	27	66	0	41	206	2857	2692	Dictyostelium polycephalum oxoglutarate dehydrogenase (ogdh) gene, complete cds	blastn	2530	158	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales		Coremiostelium	Coremiostelium polycephalum
8412346	8412346	PRJNA781196_P_NODE_33807_length_304_cov_1.471861_g33430_i0	PRJNA781196	33807	304	1.471861	4.47445744	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	187	7.44e-43	NTclustered	gi\|66826022\|ref\|XM_641274.1\|	352472	g33430	i0	87.975	5.60855263157895	158	19	52	0	40	197	43	200	Dictyostelium discoideum AX4 S60 ribosomal protein L36a (rpl36a) mRNA, complete cds	blastn	1705	187	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
10963199	10963199	PRJNA781196_P_NODE_25249_length_343_cov_2.559259_g24872_i0	PRJNA781196	25249	343	2.559259	8.77825837	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	228	5.0199999999999985e-55	NTclustered	gi\|470252539\|ref\|XM_004359310.1\|	261658	g24872	i0	78.932	38.4110787172012	337	69	98	2	7	342	516	181	Cavenderia fasciculata ADP-ribosylation factor (arfA), partial mRNA	blastn	13175	228	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
11415073	11415073	PRJNA781196_P_NODE_18389_length_390_cov_3.558360_g18012_i0	PRJNA781196	18389	390	3.55836	13.877604	Dictyostelium	5782	Evosea	other_Eukaryota	254	9.52e-63	NTclustered	gi\|167938\|gb\|M23749.1\|DDIUBIQB	44689	g18012	i0	79.112	154.102564102564	383	69	97	9	12	390	11	386	D.discoideum ubiquitin mRNA, complete cds, clone DCUBV45	blastn	60100	254	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
11415300	11415300	PRJNA781196_P_NODE_65449_length_243_cov_0.917647_g65072_i0	PRJNA781196	65449	243	0.917647	2.22988221	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	215	2.64e-51	NTclustered	gi\|330802353\|ref\|XM_003289135.1\|	5786	g65072	i0	84.722	22.8477366255144	216	31	89	2	7	222	264	51	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_88388), partial mRNA	blastn	5552	215	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
19886556	19886556	PRJNA781196_P_NODE_64576_length_243_cov_1.376471_g64199_i0	PRJNA781196	64576	243	1.376471	3.34482453	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	145	3.51e-30	NTclustered	gi\|330801204\|ref\|XM_003288572.1\|	5786	g64199	i0	85.517	4.20987654320988	145	14	58	6	18	158	393	534	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92126), mRNA	blastn	1023	145	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
21613473	21613473	PRJNA781196_P_NODE_49077_length_255_cov_1.285714_g48700_i0	PRJNA781196	49077	255	1.285714	3.2785707	Dictyostelium	5782	Evosea	other_Eukaryota	322	1.6e-83	NTclustered	gi\|167579\|gb\|M14146.1\|DDIACT15	44689	g48700	i0	89.412	99.3254901960784	255	27	100	0	1	255	1006	752	D.discoideum actin 15 gene, complete cds	blastn	25328	322	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
22888769	22888769	PRJNA781196_P_NODE_1238_length_1245_cov_26.602389_g1057_i0	PRJNA781196	1238	1245	26.602389	331.19974305	Entamoeba	5758	Evosea	other_Eukaryota	872	0	NTclustered	gi\|511083902\|dbj\|AK419160.1\|	5759	g1057	i0	80.961	90.2570281124498	1124	194	89	18	49	1162	1142	29	Entamoeba histolytica cDNA clone: Xeh-003B20, actin, complete cds, strain: HM-1:IMSS	blastn	112370	872	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
23711784	23711784	PRJNA781196_P_NODE_1239_length_1245_cov_18.176621_g1058_i0	PRJNA781196	1239	1245	18.176621	226.29893145	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	928	0	NTclustered	gi\|330791385\|ref\|XM_003283726.1\|	5786	g1058	i0	81.705	89.481124497992	1126	194	90	12	48	1167	1135	16	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_91170), partial mRNA	blastn	111404	928	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
23712596	23712596	PRJNA781196_P_NODE_68339_length_204_cov_4.580153_g67962_i0	PRJNA781196	68339	204	4.580153	9.34351212	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	134	6.1800000000000006e-27	NTclustered	gi\|831754677\|ref\|XM_012892735.1\|	1410327	g67962	i0	83.562	2.09803921568627	146	20	71	2	1	144	318	175	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	428	134	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
24162863	24162863	PRJNA781196_P_NODE_2899_length_876_cov_3.349938_g2598_i0	PRJNA781196	2899	876	3.349938	29.34545688	Entamoeba	5758	Evosea	other_Eukaryota	523	1.5599999999999996e-143	NTclustered	gi\|511085920\|dbj\|AK420211.1\|	5759	g2598	i0	78.173	57.1038812785388	843	168	96	14	4	841	847	16	Entamoeba histolytica cDNA clone: Xeh-007N07, elongation factor 1-alpha 1, complete cds, strain: HM-1:IMSS	blastn	50023	523	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica

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