metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax_phylum = "Tubulinea"

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
647650	647650	PRJNA675331_P_NODE_15381_length_269_cov_1.178571_g15209_i0	PRJNA675331	15381	269	1.178571	3.17035599	Saccamoeba lacustris	704142	Tubulinea	other_Eukaryota	300	7.97e-77	NTclustered	gi\|423292025\|gb\|JQ519458.1\|	704142	g15209	i0	86.891	91.0631970260223	267	35	99	0	3	269	678	412	Saccamoeba lacustris clone JG10.115_b9 actin gene, partial cds	blastn	24496	300	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba lacustris
3198690	3198690	PRJNA675331_P_NODE_2843_length_552_cov_1.102296_g2675_i0	PRJNA675331	2843	552	1.102296	6.08467392	Rhizamoeba saxonica	200886	Tubulinea	other_Eukaryota	695	0	NTclustered	gi\|423292021\|gb\|JQ519456.1\|	200886	g2675	i0	89.512	94.2989130434783	553	52	99	5	3	552	204	753	Rhizamoeba saxonica clone JG10.147_g3 actin gene, partial cds	blastn	52053	695	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae	Rhizamoeba	Rhizamoeba saxonica
4475739	4475739	PRJNA675331_P_NODE_15984_length_265_cov_0.989583_g15812_i0	PRJNA675331	15984	265	0.989583	2.62239495	Ptolemeba noxubium	1525730	Tubulinea	other_Eukaryota	436	5.719999999999999e-118	NTclustered	gi\|667752760\|gb\|KJ542109.1\|	1525730	g15812	i0	97.276	93.6301886792453	257	7	97	0	1	257	1411	1155	Ptolemeba noxubium isolate Nx13-1a 18S ribosomal RNA gene, partial sequence	blastn	24812	436	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Ptolemeba	Ptolemeba noxubium
5751318	5751318	PRJNA675331_P_NODE_21105_length_246_cov_0.890173_g20933_i0	PRJNA675331	21105	246	0.890173	2.18982558	Copromyxa protea	931554	Tubulinea	other_Eukaryota	316	7.14e-82	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g20933	i0	89.837	1	246	25	100	0	1	246	1365	1120	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	246	316	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
8301136	8301136	PRJNA675331_P_NODE_5927_length_394_cov_5.831776_g5755_i0	PRJNA675331	5927	394	5.831776	22.97719744	Rhizamoeba saxonica	200886	Tubulinea	other_Eukaryota	169	3.59e-37	NTclustered	gi\|300078497\|gb\|GU001159.1\|	200886	g5755	i0	87.671	10.5203045685279	146	16	37	2	19	162	4165	4310	Rhizamoeba saxonica 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	4145	169	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae	Rhizamoeba	Rhizamoeba saxonica
13401828	13401828	PRJNA675331_P_NODE_17031_length_257_cov_1.842391_g16859_i0	PRJNA675331	17031	257	1.842391	4.73494487	Ptolemeba noxubium	1525730	Tubulinea	other_Eukaryota	448	2.5499999999999995e-121	NTclustered	gi\|667752761\|gb\|KJ542110.1\|	1525730	g16859	i0	98.054	70.136186770428	257	5	100	0	1	257	1383	1127	Ptolemeba noxubium isolate Nx13-1c 18S ribosomal RNA gene, partial sequence	blastn	18025	448	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Ptolemeba	Ptolemeba noxubium
13401869	13401869	PRJNA675331_P_NODE_471_length_1269_cov_2.233278_g376_i0	PRJNA675331	471	1269	2.233278	28.34029782	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1216	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g376	i0	84.294	36.1694247438928	1267	176	99	18	19	1269	1	1260	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	45899	1216	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
13401876	13401876	PRJNA675331_P_NODE_6971_length_367_cov_1.047619_g6799_i0	PRJNA675331	6971	367	1.047619	3.84476173	uncultured Saccamoeba	2590465	Tubulinea	other_Eukaryota	388	2.3399999999999996e-103	NTclustered	gi\|1691659396\|gb\|MN097065.1\|	2590465	g6799	i0	94.466	81.1553133514986	253	12	68	2	4	254	107	359	Uncultured Saccamoeba clone OTU343 small subunit ribosomal RNA gene, partial sequence	blastn	29784	388	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae		uncultured Saccamoeba
15950526	15950526	PRJNA675331_P_NODE_4513_length_447_cov_0.925134_g4341_i0	PRJNA675331	4513	447	0.925134	4.13534898	Rhizamoeba saxonica	200886	Tubulinea	other_Eukaryota	592	2.06e-164	NTclustered	gi\|423292021\|gb\|JQ519456.1\|	200886	g4341	i0	90.583	95.592841163311	446	42	99	0	2	447	580	135	Rhizamoeba saxonica clone JG10.147_g3 actin gene, partial cds	blastn	42730	592	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae	Rhizamoeba	Rhizamoeba saxonica
15950528	15950528	PRJNA675331_P_NODE_473_length_1268_cov_2.015063_g376_i1	PRJNA675331	473	1268	2.015063	25.55099884	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1221	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g376	i1	84.373	33.6648264984227	1267	175	99	18	18	1268	1	1260	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	42687	1221	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
17225819	17225819	PRJNA675331_P_NODE_2234_length_614_cov_6.900185_g2068_i0	PRJNA675331	2234	614	6.900185	42.3671359	Copromyxa microcystidis	1678070	Tubulinea	other_Eukaryota	1085	0	NTclustered	gi\|861553842\|gb\|KP719188.1\|	1678070	g2068	i0	98.537	74.4104234527687	615	8	100	1	1	614	743	129	Copromyxa microcystidis strain A2JEPDK small subunit ribosomal RNA gene, partial sequence	blastn	45688	1085	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa microcystidis
18500037	18500037	PRJNA675331_P_NODE_22495_length_243_cov_2.417647_g22323_i0	PRJNA675331	22495	243	2.417647	5.87488221	Ptolemeba noxubium	1525730	Tubulinea	other_Eukaryota	340	4.169999999999999e-89	NTclustered	gi\|667752760\|gb\|KJ542109.1\|	1525730	g22323	i0	92.116	43.3086419753086	241	19	99	0	1	241	12	252	Ptolemeba noxubium isolate Nx13-1a 18S ribosomal RNA gene, partial sequence	blastn	10524	340	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Ptolemeba	Ptolemeba noxubium
19774611	19774611	PRJNA675331_P_NODE_16756_length_259_cov_2.483871_g16584_i0	PRJNA675331	16756	259	2.483871	6.43322589	Copromyxa flindersi	3050410	Tubulinea	other_Eukaryota	479	9.13e-131	NTclustered	gi\|2513086415\|gb\|OR081327.1\|	3050410	g16584	i0	100	83.7876447876448	259	0	100	0	1	259	712	970	Copromyxa flindersi strain KI4.1.H5.3 small subunit ribosomal RNA gene, partial sequence	blastn	21701	479	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa flindersi
21050226	21050226	PRJNA675331_P_NODE_11357_length_299_cov_1.075221_g11185_i0	PRJNA675331	11357	299	1.075221	3.21491079	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	315	3.21e-81	NTclustered	gi\|423291982\|gb\|JQ519436.1\|	5778	g11185	i0	86.007	97.3779264214047	293	41	98	0	7	299	32	324	Vermamoeba vermiformis clone JG10.95_g4 actin gene, partial cds	blastn	29116	315	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
22325152	22325152	PRJNA675331_P_NODE_21098_length_246_cov_0.890173_g20926_i0	PRJNA675331	21098	246	0.890173	2.18982558	Saccamoeba lacustris	704142	Tubulinea	other_Eukaryota	348	2.53e-91	NTclustered	gi\|423292023\|gb\|JQ519457.1\|	704142	g20926	i0	93.22	99.650406504065	236	16	96	0	11	246	255	20	Saccamoeba lacustris clone JG10.115_a9 actin gene, partial cds	blastn	24514	348	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba lacustris
22325177	22325177	PRJNA675331_P_NODE_358_length_1437_cov_7.412757_g274_i0	PRJNA675331	358	1437	7.412757	106.52131809	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1485	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g274	i0	86.155	48.0932498260264	1394	171	96	13	27	1400	1	1392	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	69110	1485	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
23600519	23600519	PRJNA675331_P_NODE_13979_length_276_cov_1.133005_g13807_i0	PRJNA675331	13979	276	1.133005	3.1270938	Saccamoeba sp. DP7	1215623	Tubulinea	other_Eukaryota	370	6.17e-98	NTclustered	gi\|399764206\|gb\|JQ271717.1\|	1215623	g13807	i0	93.878	81.9746376811594	245	15	89	0	32	276	1692	1448	Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence	blastn	22625	370	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba sp. DP7
23600571	23600571	PRJNA675331_P_NODE_2059_length_639_cov_2.102473_g1893_i0	PRJNA675331	2059	639	2.102473	13.43480247	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	411	9.089999999999998e-110	NTclustered	gi\|1042160947\|dbj\|LC102280.1\|	239731	g1893	i0	88.724	5.34428794992175	337	36	53	2	304	639	1	336	Hartmannella cantabrigiensis gene for elongation factor 2 alpha, partial cds, strain: ALC3	blastn	3415	411	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
23600587	23600587	PRJNA675331_P_NODE_2379_length_600_cov_1.743833_g2213_i0	PRJNA675331	2379	600	1.743833	10.462998	Glaeseria mira	242547	Tubulinea	other_Eukaryota	549	1.73e-151	NTclustered	gi\|33946339\|gb\|AY294146.1\|	242547	g2213	i0	89.791	71.5516666666667	431	40	80	4	170	600	802	1228	Glaeseria mira small subunit ribosomal RNA gene, partial sequence	blastn	42931	549	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Glaeseria	Glaeseria mira

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