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

9 rows where analysis = "blastn", bioproject = "PRJNA1123309" 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
2828953	2828953	PRJNA1123309_P_NODE_32763_length_288_cov_1.674419_g32383_i0	PRJNA1123309	32763	288	1.674419	4.82232672	Cochliopodium larifeili	1017091	Discosea	other_Eukaryota	460	3.74e-125	NTclustered	gi\|330902856\|gb\|JF298254.1\|	1017091	g32383	i0	96.466	59.3854166666667	283	3	98	5	1	283	1108	833	Cochliopodium larifeili clone 902 18S ribosomal RNA gene, partial sequence	blastn	17103	460	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium larifeili
4105393	4105393	PRJNA1123309_P_NODE_37884_length_276_cov_1.142857_g37504_i0	PRJNA1123309	37884	276	1.142857	3.15428532	Physarum polycephalum	5791	Evosea	other_Eukaryota	239	1.82e-58	NTclustered	gi\|119552593\|gb\|EF140724.1\|	5791	g37504	i0	85.526	20.6050724637681	228	33	83	0	26	253	354	127	Physarum polycephalum 14-3-3-like protein mRNA, complete cds	blastn	5687	239	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
4105458	4105458	PRJNA1123309_P_NODE_43044_length_263_cov_1.231579_g42664_i0	PRJNA1123309	43044	263	1.231579	3.23905277	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	56.5	0.002	NTclustered	gi\|330796061\|ref\|XM_003286040.1\|	5786	g42664	i0	87.755	0.186311787072243	49	4	18	2	214	260	1025	977	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_150027), partial mRNA	blastn	49	56.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
5381350	5381350	PRJNA1123309_P_NODE_26145_length_315_cov_2.198347_g25765_i0	PRJNA1123309	26145	315	2.198347	6.92479305	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	58.4	6.34e-4	NTclustered	gi\|66815696\|ref\|XM_636773.1\|	352472	g25765	i0	100	0.212698412698413	31	0	10	0	222	252	5488	5518	Dictyostelium discoideum AX4 DEP domain containing protein (DDB_G0279099) mRNA, complete cds	blastn	67	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
5381390	5381390	PRJNA1123309_P_NODE_29765_length_298_cov_1.333333_g29385_i0	PRJNA1123309	29765	298	1.333333	3.97333234	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	52.8	0.028	NTclustered	gi\|330837833\|ref\|XM_003292006.1\|	5786	g29385	i0	100	0.0939597315436242	28	0	9	0	19	46	613	640	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_156733), partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
11232304	11232304	PRJNA1123309_P_NODE_30189_length_296_cov_1.381166_g29809_i0	PRJNA1123309	30189	296	1.381166	4.08825136	root	1	Root_unresolved	Root_unresolved	355	1.87e-93	NTclustered	gi\|909719646\|gb\|KT185626.1\|	5755	g29809	i0	88.333	51.2871621621622	300	29	99	5	3	296	3965	3666	Acanthamoeba castellanii 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	15181	355	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
14306921	14306921	PRJNA1123309_P_NODE_12172_length_436_cov_2.173554_g11796_i0	PRJNA1123309	12172	436	2.173554	9.47669544	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	333	1.34e-86	NTclustered	gi\|330791897\|ref\|XM_003283980.1\|	5786	g11796	i0	81.132	44.947247706422	424	73	97	5	5	426	1462	1044	Dictyostelium purpureum 26S proteasome ATPase 2 subunit (DICPUDRAFT_96551), mRNA	blastn	19597	333	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
14307267	14307267	PRJNA1123309_P_NODE_42592_length_264_cov_1.397906_g42212_i0	PRJNA1123309	42592	264	1.397906	3.69047184	Arcyria sp. 'tenuissima'	3129282	Evosea	other_Eukaryota	388	1.62e-103	NTclustered	gi\|2698738389\|gb\|PP491458.1\|	3129282	g42212	i0	93.536	0.996212121212121	263	13	98	2	6	264	3555	3817	Arcyria sp. 'tenuissima' voucher sc32644 internal transcribed spacer region, partial sequence	blastn	263	388	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Arcyria	Arcyria sp. 'tenuissima'
18130192	18130192	PRJNA1123309_P_NODE_46855_length_253_cov_1.300000_g46475_i0	PRJNA1123309	46855	253	1.3	3.289	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	202	2.15e-47	NTclustered	gi\|330804280\|ref\|XM_003290077.1\|	5786	g46475	i0	86.74	8.73913043478261	181	24	72	0	10	190	298	478	Dictyostelium purpureum ubiquitin-conjugating enzyme E2-17 kDa (DICPUDRAFT_56481), mRNA	blastn	2211	202	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);;