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

9 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax_phylum = "Evosea"

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
8446516	8446516	PRJNA799842_P_NODE_142287_length_250_cov_0.870056_g140714_i0	PRJNA799842	142287	250	0.870056	2.17514	Entamoeba histolytica	5759	Evosea	other_Eukaryota	169	2.15e-37	NTclustered	gi\|467633\|emb\|Z29969.1\|	5759	g140714	i0	80.081	23.108	246	34	96	8	1	239	1970	2207	E.histolytica plasmid genes for ribosomal RNA and hemolysins HLY1, HLY5mc1 HLY5mc2 HLY4	blastn	5777	169	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
13548109	13548109	PRJNA799842_P_NODE_25191_length_588_cov_2.415534_g23646_i0	PRJNA799842	25191	588	2.415534	14.20333992	Physarum cinereum	289951	Evosea	other_Eukaryota	1074	0	NTclustered	gi\|374255699\|emb\|HE614599.1\|	289951	g23646	i0	99.66	100.540816326531	588	1	100	1	1	588	1111	525	Physarum cinereum partial 18S rRNA gene, strain Idn-2	blastn	59118	1074	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum cinereum
14822729	14822729	PRJNA799842_P_NODE_19132_length_693_cov_2.441935_g17642_i0	PRJNA799842	19132	693	2.441935	16.92260955	Physarum polycephalum	5791	Evosea	other_Eukaryota	678	0	NTclustered	gi\|3221\|emb\|V01159.1\|	5791	g17642	i0	86.783	44.7575757575758	628	60	88	19	1	611	1576	2197	Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA	blastn	31017	678	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
14822903	14822903	PRJNA799842_P_NODE_27492_length_558_cov_2.973196_g25936_i0	PRJNA799842	27492	558	2.973196	16.59043368	Polyschismium peyerimhoffii	2911783	Evosea	other_Eukaryota	350	1.7400000000000002e-91	NTclustered	gi\|2161226355\|gb\|MZ313553.1\|	2911783	g25936	i0	78.778	29.3584229390681	589	76	100	37	1	558	6953	6383	Polyschismium peyerimhoffii 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	16382	350	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Polyschismium	Polyschismium peyerimhoffii
14823224	14823224	PRJNA799842_P_NODE_41692_length_442_cov_1.005420_g40121_i0	PRJNA799842	41692	442	1.00542	4.4439564	Physarum cinereum	289951	Evosea	other_Eukaryota	811	0	NTclustered	gi\|374255699\|emb\|HE614599.1\|	289951	g40121	i0	99.774	91.0294117647059	442	1	100	0	1	442	510	69	Physarum cinereum partial 18S rRNA gene, strain Idn-2	blastn	40235	811	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum cinereum
16521413	16521413	PRJNA799842_P_NODE_111033_length_278_cov_1.126829_g109460_i0	PRJNA799842	111033	278	1.126829	3.13258462	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	54.7	0.007	NTclustered	gi\|330800430\|ref\|XM_003288192.1\|	5786	g109460	i0	100	0.20863309352518	29	0	10	0	201	229	224	196	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_97960), mRNA	blastn	58	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
21621735	21621735	PRJNA799842_P_NODE_75617_length_330_cov_1.509728_g74044_i0	PRJNA799842	75617	330	1.509728	4.9821024	Physarum	5790	Evosea	other_Eukaryota	604	1.8999999999999996e-168	NTclustered	gi\|381139256\|emb\|HE655073.1\|	289948	g74044	i0	99.697	52.4757575757576	330	1	100	0	1	330	1253	924	Physarum albescens partial 28S rRNA gene, isolate Fr-K2	blastn	17317	610	0.99016393442623	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum albescens
22472193	22472193	PRJNA799842_P_NODE_51578_length_395_cov_2.897516_g50005_i0	PRJNA799842	51578	395	2.897516	11.4451882	Fuligo septica	159720	Evosea	other_Eukaryota	211	5.89e-50	NTclustered	gi\|37515398\|emb\|AJ584697.1\|	159720	g50005	i0	94.203	1.33164556962025	138	8	35	0	233	370	14003	13866	Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1	blastn	526	211	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Fuligo	Fuligo septica
25020212	25020212	PRJNA799842_P_NODE_153760_length_248_cov_0.880000_g152187_i0	PRJNA799842	153760	248	0.88	2.1824	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	52.8	0.022	NTclustered	gi\|66823606\|ref\|XM_640066.1\|	352472	g152187	i0	100	0.112903225806452	28	0	11	0	155	182	3513	3540	Dictyostelium discoideum AX4 hypothetical protein (DDB_G0272368) mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum

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