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

14 rows where analysis = "blastn", bioproject = "PRJNA874604" 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
2126784	2126784	PRJNA874604_P_NODE_17542_length_425_cov_1.161932_g17190_i0	PRJNA874604	17542	425	1.161932	4.938211	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	292	2.22e-74	NTclustered	gi\|330818907\|ref\|XM_003291484.1\|	5786	g17190	i0	80.253	11.4235294117647	395	72	92	5	5	396	24	415	Dictyostelium purpureum ribosomal protein L10E (DICPUDRAFT_92700), mRNA	blastn	4855	292	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
2513262	2513262	PRJNA874604_P_NODE_16002_length_441_cov_9.701087_g15650_i0	PRJNA874604	16002	441	9.701087	42.78179367	Ripella	1217112	Discosea	other_Eukaryota	693	0	NTclustered	gi\|1269228437\|gb\|MF683562.1\|	2047822	g15650	i0	95.034	100.433106575964	443	18	100	4	1	441	1044	604	Ripella decalvata clone 15101 18S ribosomal RNA gene, partial sequence	blastn	44291	695	0.997122302158273	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella decalvata
4679829	4679829	PRJNA874604_P_NODE_1784_length_1117_cov_3.204981_g1576_i0	PRJNA874604	1784	1117	3.204981	35.79963777	Paramoeba branchiphila	308475	Discosea	other_Eukaryota	1144	0	NTclustered	gi\|226347442\|gb\|FJ807261.1\|	308475	g1576	i0	87.238	67.2202327663384	1003	126	90	2	116	1117	1202	201	Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds	blastn	75085	1144	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba branchiphila
7230186	7230186	PRJNA874604_P_NODE_49466_length_285_cov_1.433962_g49114_i0	PRJNA874604	49466	285	1.433962	4.0867917	Paramoeba perurans	437603	Discosea	other_Eukaryota	172	1.94e-38	NTclustered	gi\|145386784\|gb\|EF216909.1\|	437603	g49114	i0	77.855	27.8315789473684	289	57	100	7	1	285	45	330	Neoparamoeba perurans strain GD-HAC/1 28S large subunit ribosomal RNA gene, partial sequence	blastn	7932	172	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba perurans
9779187	9779187	PRJNA874604_P_NODE_11008_length_517_cov_7.601351_g10657_i0	PRJNA874604	11008	517	7.601351	39.29898467	Vannella sp. KDN1	2081467	Discosea	other_Eukaryota	813	0	NTclustered	gi\|1770511914\|dbj\|LC368142.1\|	2081467	g10657	i0	95.038	101.075435203095	524	14	100	10	1	517	1153	1671	Vannella sp. KDN1 gene for 18S ribosomal RNA, partial sequence	blastn	52256	813	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp. KDN1
10166884	10166884	PRJNA874604_P_NODE_85868_length_245_cov_2.226744_g85516_i0	PRJNA874604	85868	245	2.226744	5.4555228	Dictyostelium	5782	Evosea	other_Eukaryota	193	1.25e-44	NTclustered	gi\|790953\|dbj\|D50338.1\|	44689	g85516	i0	84.896	61.3632653061225	192	27	78	2	54	244	2872	2682	Dictyostelium discoideum DNA for ribosomal protein, complete cds	blastn	15034	193	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
12330937	12330937	PRJNA874604_P_NODE_39730_length_310_cov_1.299578_g39378_i0	PRJNA874604	39730	310	1.299578	4.0286918	Didymium bahiense	289975	Evosea	other_Eukaryota	551	2.339999999999999e-152	NTclustered	gi\|2528966063\|gb\|OR214927.1\|	289975	g39378	i0	98.71	87.5870967741936	310	4	100	0	1	310	338	29	Didymium bahiense voucher HFJAU14001 small subunit ribosomal RNA gene, partial sequence	blastn	27152	551	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium bahiense
13605427	13605427	PRJNA874604_P_NODE_36731_length_319_cov_1.878049_g36379_i0	PRJNA874604	36731	319	1.878049	5.99097631	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	176	1.7e-39	NTclustered	gi\|66826022\|ref\|XM_641274.1\|	352472	g36379	i0	86.709	1.72100313479624	158	21	50	0	40	197	43	200	Dictyostelium discoideum AX4 S60 ribosomal protein L36a (rpl36a) mRNA, complete cds	blastn	549	176	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
13606329	13606329	PRJNA874604_P_NODE_84251_length_246_cov_0.890173_g83899_i0	PRJNA874604	84251	246	0.890173	2.18982558	Entamoeba histolytica	5759	Evosea	other_Eukaryota	54.7	0.006	NTclustered	gi\|416173\|emb\|X70311.1\|	5759	g83899	i0	100	0.117886178861789	29	0	12	0	58	86	1791	1819	E.histolytica extrachromosomal rDNA fragment	blastn	29	54.7	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
16540982	16540982	PRJNA874604_P_NODE_9933_length_540_cov_1.372591_g9585_i0	PRJNA874604	9933	540	1.372591	7.4119914	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	460	7.439999999999998e-125	NTclustered	gi\|511083902\|dbj\|AK419160.1\|	5759	g9585	i0	83.707	90.9537037037037	491	76	91	4	6	494	517	29	Entamoeba histolytica cDNA clone: Xeh-003B20, actin, complete cds, strain: HM-1:IMSS	blastn	49115	462	0.995670995670996	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
17431150	17431150	PRJNA874604_P_NODE_96874_length_242_cov_0.911243_g96522_i0	PRJNA874604	96874	242	0.911243	2.20520806	Vannella ebro	207334	Discosea	other_Eukaryota	283	7.1e-72	NTclustered	gi\|33946344\|gb\|AY294151.1\|	207334	g96522	i0	90.278	83.8636363636364	216	21	89	0	27	242	16	231	Vannella ebro actin mRNA, complete cds	blastn	20295	283	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella ebro
21254087	21254087	PRJNA874604_P_NODE_50117_length_284_cov_1.170616_g49765_i0	PRJNA874604	50117	284	1.170616	3.32454944	Cochliopodium kieliense	1512276	Discosea	other_Eukaryota	444	3.6999999999999986e-120	NTclustered	gi\|659103926\|gb\|KJ569726.1\|	1512276	g49765	i0	94.81	43.0774647887324	289	8	100	7	1	284	102	388	Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence	blastn	12234	444	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium kieliense
23804561	23804561	PRJNA874604_P_NODE_68259_length_251_cov_1.730337_g67907_i0	PRJNA874604	68259	251	1.730337	4.34314587	Didymium megalosporum	289980	Evosea	other_Eukaryota	187	5.98e-43	NTclustered	gi\|529177860\|gb\|KC814167.1\|	289980	g67907	i0	80.08	18.8207171314741	251	50	100	0	1	251	741	491	Didymium megalosporum alpha-tubulin gene, partial cds	blastn	4724	187	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium megalosporum
25078906	25078906	PRJNA874604_P_NODE_8980_length_563_cov_11.808163_g8633_i0	PRJNA874604	8980	563	11.808163	66.47995769	Ripella sp. 805	1217113	Discosea	other_Eukaryota	881	0	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g8633	i0	95.512	99.0941385435169	557	16	98	9	11	563	1	552	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	55790	881	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805

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