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

14 rows where analysis = "blastn", bioproject = "PRJNA1073005" 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
186983	186983	PRJNA1073005_P_NODE_3181_length_595_cov_6.808429_g3063_i0	PRJNA1073005	3181	595	6.808429	40.51015255	Ptolemeba bulliensis	1525729	Tubulinea	other_Eukaryota	1029	0	NTclustered	gi\|667752759\|gb\|KJ542108.1\|	1525729	g3063	i0	97.987	85.527731092437	596	6	100	3	1	595	1867	1277	Ptolemeba bulliensis isolate Sk13-4e 18S ribosomal RNA gene, partial sequence	blastn	50889	1029	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Ptolemeba	Ptolemeba bulliensis
1461544	1461544	PRJNA1073005_P_NODE_3022_length_615_cov_8.525830_g2904_i0	PRJNA1073005	3022	615	8.52583	52.4338545	Ptolemeba bulliensis	1525729	Tubulinea	other_Eukaryota	1007	0	NTclustered	gi\|1255287465\|dbj\|LC272073.1\|	1525729	g2904	i0	96.423	74.8439024390244	615	15	100	6	1	615	595	1202	Ptolemeba bulliensis gene for 18S ribosomal RNA, partial sequence, strain: BA02	blastn	46029	1007	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Ptolemeba	Ptolemeba bulliensis
1461558	1461558	PRJNA1073005_P_NODE_8142_length_278_cov_1.126829_g8023_i0	PRJNA1073005	8142	278	1.126829	3.13258462	Arcella discoides	1078856	Tubulinea	other_Eukaryota	279	1.08e-70	NTclustered	gi\|345452540\|gb\|JF694288.1\|	1078856	g8023	i0	84.946	58.431654676259	279	38	99	4	2	278	642	366	Arcella discoides isolate DL3_98 clone 2 actin gene, partial cds	blastn	16244	279	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Arcellidae	Arcella	Arcella discoides
2737537	2737537	PRJNA1073005_P_NODE_7443_length_304_cov_2.095238_g7324_i0	PRJNA1073005	7443	304	2.095238	6.36952352	Amoeba leningradensis	160820	Tubulinea	other_Eukaryota	305	1.97e-78	NTclustered	gi\|17897590\|emb\|AJ314605.1\|	160820	g7324	i0	84.936	50.5460526315789	312	36	100	9	1	304	1294	1602	Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6	blastn	15366	305	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba leningradensis
7839595	7839595	PRJNA1073005_P_NODE_4327_length_477_cov_1.193069_g4208_i0	PRJNA1073005	4327	477	1.193069	5.69093913	Vexillifera expectata	1789827	Discosea	other_Eukaryota	634	3.619999999999999e-177	NTclustered	gi\|1042160925\|dbj\|LC102269.1\|	1789827	g4208	i0	90.737	99.6918238993711	475	44	99	0	1	475	526	52	Vexillifera expectata gene for actin, partial cds, strain: 4730_cl4	blastn	47553	634	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Vexilliferidae	Vexillifera	Vexillifera expectata
7839601	7839601	PRJNA1073005_P_NODE_6347_length_354_cov_1.284698_g6228_i0	PRJNA1073005	6347	354	1.284698	4.54783092	Vannella sp.	1973054	Discosea	other_Eukaryota	645	1.2099999999999996e-180	NTclustered	gi\|2169663314\|gb\|OL989990.1\|	1973054	g6228	i0	99.435	97.7316384180791	354	2	100	0	1	354	1388	1741	Vannella sp. isolate P147 small subunit ribosomal RNA gene, partial sequence	blastn	34597	645	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp.
10390273	10390273	PRJNA1073005_P_NODE_6889_length_329_cov_0.976562_g6770_i0	PRJNA1073005	6889	329	0.976562	3.21288898	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	52.8	0.031	NTclustered	gi\|470247896\|ref\|XM_004366774.1\|	261658	g6770	i0	100	0.0851063829787234	28	0	9	0	225	252	1265	1238	Cavenderia fasciculata uncharacterized protein (DFA_02446), partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
11665626	11665626	PRJNA1073005_P_NODE_4310_length_478_cov_2.185185_g4191_i0	PRJNA1073005	4310	478	2.185185	10.4451843	Chaos nobile	160822	Tubulinea	other_Eukaryota	499	1.38e-136	NTclustered	gi\|17902587\|emb\|AJ314606.1\|	160822	g4191	i0	91.105	76.4644351464435	371	29	77	4	111	478	942	1311	Chaos nobile partial 16S rRNA gene, strain CCAP 1511/2	blastn	36550	499	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Chaos	Chaos nobile
12940717	12940717	PRJNA1073005_P_NODE_2851_length_640_cov_9.380952_g2735_i0	PRJNA1073005	2851	640	9.380952	60.0380928	Cochliopodium minus	313997	Discosea	other_Eukaryota	809	0	NTclustered	gi\|330902862\|gb\|JF298257.1\|	313997	g2735	i0	90.358	52.70625	643	25	97	21	1	621	631	4	Cochliopodium minus 18S ribosomal RNA gene, partial sequence	blastn	33732	809	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium minus
16763886	16763886	PRJNA1073005_P_NODE_10194_length_242_cov_0.911243_g10075_i0	PRJNA1073005	10194	242	0.911243	2.20520806	Thecamoeba similis	242545	Discosea	other_Eukaryota	298	2.54e-76	NTclustered	gi\|33946350\|gb\|AY294154.1\|	242545	g10075	i0	89.121	91.8512396694215	239	26	99	0	4	242	41	279	Thecamoeba similis actin mRNA, complete cds	blastn	22228	298	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Thecamoebida	Thecamoeba	Thecamoeba similis
18038674	18038674	PRJNA1073005_P_NODE_1935_length_802_cov_3.039781_g1836_i0	PRJNA1073005	1935	802	3.039781	24.37904362	Cochliopodium minus	313997	Discosea	other_Eukaryota	900	0	NTclustered	gi\|330902862\|gb\|JF298257.1\|	313997	g1836	i0	87.728	53.5324189526185	823	33	100	35	1	802	2216	1441	Cochliopodium minus 18S ribosomal RNA gene, partial sequence	blastn	42933	900	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium minus
19312649	19312649	PRJNA1073005_P_NODE_2576_length_682_cov_4.111658_g2462_i0	PRJNA1073005	2576	682	4.111658	28.04150756	Cochliopodium minus	313997	Discosea	other_Eukaryota	745	0	NTclustered	gi\|330902862\|gb\|JF298257.1\|	313997	g2462	i0	86.364	57.4604105571848	726	43	100	33	1	682	644	1357	Cochliopodium minus 18S ribosomal RNA gene, partial sequence	blastn	39188	745	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium minus
19312652	19312652	PRJNA1073005_P_NODE_3456_length_563_cov_2.206122_g3337_i0	PRJNA1073005	3456	563	2.206122	12.42046686	Copromyxa protea	931554	Tubulinea	other_Eukaryota	483	1.66e-131	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g3337	i0	81.9	4.101243339254	558	93	98	4	13	563	570	14	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	2309	483	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
19312668	19312668	PRJNA1073005_P_NODE_8716_length_258_cov_1.335135_g8597_i0	PRJNA1073005	8716	258	1.335135	3.4446483	Platyamoeba placida	3454475	Discosea	other_Eukaryota	316	7.539999999999998e-82	NTclustered	gi\|33946348\|gb\|AY294153.1\|	197527	g8597	i0	88.76	98.1976744186046	258	29	100	0	1	258	565	308	Platyamoeba placida actin mRNA, partial cds	blastn	25335	316	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Platyamoeba	Platyamoeba placida

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