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

9 rows where analysis = "blastn", bioproject = "PRJNA796753" 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
2056744	2056744	PRJNA796753_P_NODE_582_length_1445_cov_27.463557_g480_i0	PRJNA796753	582	1445	27.463557	396.84839865	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1546	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g480	i0	86.876	68.9640138408304	1402	158	96	14	43	1422	1398	1	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	99653	1546	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
4609024	4609024	PRJNA796753_P_NODE_26004_length_295_cov_0.873874_g25692_i0	PRJNA796753	26004	295	0.873874	2.5779283	Copromyxa protea	931554	Tubulinea	other_Eukaryota	239	1.9600000000000003e-58	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g25692	i0	82.374	0.942372881355932	278	45	94	4	20	295	1386	1111	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	278	239	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
8433909	8433909	PRJNA796753_P_NODE_47487_length_245_cov_2.087209_g47175_i0	PRJNA796753	47487	245	2.087209	5.11366205	Glaeseria mira	242547	Tubulinea	other_Eukaryota	303	5.53e-78	NTclustered	gi\|33946352\|gb\|AY294155.1\|	242547	g47175	i0	89.024	93.6040816326531	246	26	100	1	1	245	270	25	Glaeseria mira actin mRNA, partial cds	blastn	22933	303	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Glaeseria	Glaeseria mira
16083121	16083121	PRJNA796753_P_NODE_13053_length_389_cov_2.506329_g12741_i0	PRJNA796753	13053	389	2.506329	9.74961981	Saccamoeba limax	136464	Tubulinea	other_Eukaryota	713	0	NTclustered	gi\|213950421\|gb\|EU869301.1\|	136464	g12741	i0	99.743	23.4858611825193	389	1	100	0	1	389	1498	1886	Saccamoeba limax strain NTSHR small subunit ribosomal RNA gene, partial sequence	blastn	9136	713	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba limax
16083151	16083151	PRJNA796753_P_NODE_18813_length_337_cov_1.575758_g18501_i0	PRJNA796753	18813	337	1.575758	5.31030446	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	425	1.63e-114	NTclustered	gi\|33946358\|gb\|AY294158.1\|	239731	g18501	i0	93.95	77.7181008902077	281	17	83	0	57	337	1151	871	Hartmannella cantabrigiensis actin mRNA, complete cds	blastn	26191	425	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
16083393	16083393	PRJNA796753_P_NODE_9233_length_454_cov_1.711286_g8921_i0	PRJNA796753	9233	454	1.711286	7.76923844	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	616	1.2399999999999999e-171	NTclustered	gi\|62910949\|gb\|AY925001.1\|	5778	g8921	i0	94.911	1.06828193832599	393	20	87	0	62	454	1	393	Hartmannella vermiformis Rpl7A mRNA, partial cds	blastn	485	616	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
19907421	19907421	PRJNA796753_P_NODE_17096_length_349_cov_1.952899_g16784_i0	PRJNA796753	17096	349	1.952899	6.81561751	Copromyxa protea	931554	Tubulinea	other_Eukaryota	398	3.6699999999999982e-106	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g16784	i0	88.889	33.7994269340974	324	34	93	2	6	328	221	543	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	11796	398	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
22457737	22457737	PRJNA796753_P_NODE_13218_length_387_cov_1.961783_g12906_i0	PRJNA796753	13218	387	1.961783	7.59210021	Saccamoeba limax	136464	Tubulinea	other_Eukaryota	684	0	NTclustered	gi\|213950421\|gb\|EU869301.1\|	136464	g12906	i0	98.462	72.2093023255814	390	3	100	1	1	387	1280	891	Saccamoeba limax strain NTSHR small subunit ribosomal RNA gene, partial sequence	blastn	27945	684	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba limax
25007039	25007039	PRJNA796753_P_NODE_17940_length_343_cov_1.140741_g17628_i0	PRJNA796753	17940	343	1.140741	3.91274163	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	501	2.6799999999999993e-137	NTclustered	gi\|423292048\|gb\|JQ519470.1\|	5778	g17628	i0	96.98	93.2827988338192	298	9	87	0	44	341	908	611	Vermamoeba vermiformis clone JG10.132_b5 alpha tubulin gene, partial cds	blastn	31996	501	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis

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