metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1028258" 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
164477	164477	PRJNA1028258_P_NODE_27661_length_483_cov_1.874396_g27101_i0	PRJNA1028258	27661	483	1.874396	9.05333268	Arcella discoides	1078856	Tubulinea	other_Eukaryota	477	6.549999999999998e-130	NTclustered	gi\|345452546\|gb\|JF694291.1\|	1078856	g27101	i0	84.536	98.4120082815735	485	71	100	4	1	483	735	253	Arcella discoides isolate DL3_98 clone 5 actin gene, partial cds	blastn	47533	477	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Arcellidae	Arcella	Arcella discoides
1437858	1437858	PRJNA1028258_P_NODE_110882_length_252_cov_0.928962_g110319_i0	PRJNA1028258	110882	252	0.928962	2.34098424	Spumochlamys bryora	675832	Tubulinea	other_Eukaryota	322	1.58e-83	NTclustered	gi\|259595682\|gb\|FJ705345.1\|	675832	g110319	i0	92.444	96.484126984127	225	17	89	0	28	252	392	168	Spumochlamys bryora actin gene, partial cds	blastn	24314	322	1	Eukaryota	Amoebozoa	Tubulinea	Corycida		Microchlamyiidae	Spumochlamys	Spumochlamys bryora
1439639	1439639	PRJNA1028258_P_NODE_44562_length_379_cov_1.970968_g43999_i0	PRJNA1028258	44562	379	1.970968	7.46996872	Cryptodifflugia operculata	1078836	Tubulinea	other_Eukaryota	468	3.03e-127	NTclustered	gi\|421976286\|gb\|JQ519399.1\|	1078836	g43999	i0	89.153	12.8970976253298	378	37	99	4	4	379	36	411	Cryptodifflugia operculata clone JG11.5_7 14-3-3 protein gene, partial cds	blastn	4888	468	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Cryptodifflugiidae	Cryptodifflugia	Cryptodifflugia operculata
1439900	1439900	PRJNA1028258_P_NODE_57862_length_335_cov_0.917293_g57299_i0	PRJNA1028258	57862	335	0.917293	3.07293155	Pyxidicula operculata	1078852	Tubulinea	other_Eukaryota	577	4.2199999999999986e-160	NTclustered	gi\|345452598\|gb\|JF694317.1\|	1078852	g57299	i0	97.904	96.8507462686567	334	6	99	1	2	335	305	637	Pyxidicula operculata clone 2 actin gene, partial cds	blastn	32445	577	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida		Pyxidicula	Pyxidicula operculata
1439908	1439908	PRJNA1028258_P_NODE_58602_length_333_cov_1.015152_g58039_i0	PRJNA1028258	58602	333	1.015152	3.38045616	Nebela penardiana	499102	Tubulinea	other_Eukaryota	359	1.6499999999999998e-94	NTclustered	gi\|423292008\|gb\|JQ519449.1\|	499102	g58039	i0	86.728	95.5285285285285	324	41	97	2	6	328	382	704	Nebela penardiana clone JG11.33_c1 actin pseudogene, partial sequence	blastn	31811	359	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Hyalospheniidae	Nebela	Nebela penardiana
6541970	6541970	PRJNA1028258_P_NODE_153186_length_230_cov_1.322981_g152623_i0	PRJNA1028258	153186	230	1.322981	3.0428563	Copromyxa protea	931554	Tubulinea	other_Eukaryota	139	1.53e-28	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g152623	i0	78.182	0.956521739130435	220	46	95	2	1	219	1317	1099	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	220	139	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
7818475	7818475	PRJNA1028258_P_NODE_93167_length_268_cov_1.165829_g92604_i0	PRJNA1028258	93167	268	1.165829	3.12442172	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	313	1.02e-80	NTclustered	gi\|423291982\|gb\|JQ519436.1\|	5778	g92604	i0	87.687	99.8283582089552	268	33	100	0	1	268	526	259	Vermamoeba vermiformis clone JG10.95_g4 actin gene, partial cds	blastn	26754	313	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
9932971	9932971	PRJNA1028258_P_NODE_168988_length_227_cov_0.898734_g168425_i0	PRJNA1028258	168988	227	0.898734	2.04012618	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	298	2.35e-76	NTclustered	gi\|33946358\|gb\|AY294158.1\|	239731	g168425	i0	90.308	95.1497797356828	227	22	100	0	1	227	931	705	Hartmannella cantabrigiensis actin mRNA, complete cds	blastn	21599	300	0.993333333333333	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
11207889	11207889	PRJNA1028258_P_NODE_13189_length_699_cov_1.812698_g12694_i0	PRJNA1028258	13189	699	1.812698	12.67075902	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	774	0	NTclustered	gi\|33946352\|gb\|AY294155.1\|	242547	g12694	i0	87.045	93.0057224606581	687	87	98	2	1	686	724	39	Glaeseria mira actin mRNA, partial cds	blastn	65011	776	0.997422680412371	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Glaeseria	Glaeseria mira
15467825	15467825	PRJNA1028258_P_NODE_53413_length_348_cov_0.896057_g52850_i0	PRJNA1028258	53413	348	0.896057	3.11827836	Spumochlamys bryora	675832	Tubulinea	other_Eukaryota	425	1.69e-114	NTclustered	gi\|259595682\|gb\|FJ705345.1\|	675832	g52850	i0	89.181	95.8563218390805	342	36	98	1	2	343	461	121	Spumochlamys bryora actin gene, partial cds	blastn	33358	425	1	Eukaryota	Amoebozoa	Tubulinea	Corycida		Microchlamyiidae	Spumochlamys	Spumochlamys bryora
18017202	18017202	PRJNA1028258_P_NODE_69515_length_308_cov_1.104603_g68952_i0	PRJNA1028258	69515	308	1.104603	3.40217724	Cryptodifflugia operculata	1078836	Tubulinea	other_Eukaryota	368	2.51e-97	NTclustered	gi\|345452564\|gb\|JF694300.1\|	1078836	g68952	i0	97.235	94.5324675324675	217	6	70	0	92	308	795	579	Cryptodifflugia operculata clone 4 actin gene, partial cds	blastn	29116	368	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Cryptodifflugiidae	Cryptodifflugia	Cryptodifflugia operculata
20131636	20131636	PRJNA1028258_P_NODE_27056_length_489_cov_1.150000_g26496_i0	PRJNA1028258	27056	489	1.15	5.6235	Flabellulidae	136457	Tubulinea	other_Eukaryota	488	3.0699999999999993e-133	NTclustered	gi\|167859754\|gb\|EU273459.1\|	497999	g26496	i0	84.787	99.6053169734151	493	67	100	8	1	489	785	297	Rhizamoeba sp. ATCC 50933 actin gene, partial cds	blastn	48707	490	0.995918367346939	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae	Rhizamoeba	Rhizamoeba sp. ATCC 50933
24389387	24389387	PRJNA1028258_P_NODE_12380_length_720_cov_2.294931_g11892_i0	PRJNA1028258	12380	720	2.294931	16.5235032	Copromyxa protea	931554	Tubulinea	other_Eukaryota	516	2.12e-141	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g11892	i0	80.506	13.3708333333333	672	131	93	0	30	701	672	1	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	9627	516	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea

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