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

13 rows where analysis = "blastn", bioproject = "PRJNA801875" 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
801043	801043	PRJNA801875_P_NODE_1221_length_363_cov_551.478659_g1118_i0	PRJNA801875	1221	363	551.478659	2001.86753217	Korotnevella jeppesenii	1678066	Discosea	other_Eukaryota	468	2.88e-127	NTclustered	gi\|861553739\|gb\|KP719185.1\|	1678066	g1118	i0	90.191	101.104683195592	367	25	99	9	1	361	1056	1417	Korotnevella jeppesenii strain A1JEPDK small subunit ribosomal RNA gene, partial sequence	blastn	36701	468	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Korotnevella	Korotnevella jeppesenii
2076894	2076894	PRJNA801875_P_NODE_4322_length_157_cov_1.868852_g4219_i0	PRJNA801875	4322	157	1.868852	2.93409764	Polyschismium peyerimhoffii	2911783	Evosea	other_Eukaryota	150	4.47e-32	NTclustered	gi\|2161226355\|gb\|MZ313553.1\|	2911783	g4219	i0	85.714	6.0828025477707	147	16	94	4	5	151	3501	3642	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	955	150	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Polyschismium	Polyschismium peyerimhoffii
4629488	4629488	PRJNA801875_P_NODE_1564_length_305_cov_8.381481_g1461_i0	PRJNA801875	1564	305	8.381481	25.56351705	Paramoeba perurans	437603	Discosea	other_Eukaryota	377	4.13e-100	NTclustered	gi\|145386786\|gb\|EF216911.1\|	437603	g1461	i0	89.667	91.6196721311475	300	25	98	4	4	303	1167	1460	Neoparamoeba perurans strain GD-HAC/2/2 28S large subunit ribosomal RNA gene, partial sequence	blastn	27944	377	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba perurans
7179385	7179385	PRJNA801875_P_NODE_1726_length_286_cov_1.780876_g1623_i0	PRJNA801875	1726	286	1.780876	5.09330536	Echinostelium minutum	300235	Evosea	other_Eukaryota	291	5.15e-74	NTclustered	gi\|210062522\|gb\|AY842034.2\|	300235	g1623	i0	85.714	16.1083916083916	280	35	98	5	4	282	11	286	Echinostelium minutum strain ATCC 22345 18S ribosomal RNA gene, partial sequence	blastn	4607	291	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Echinosteliales	Echinosteliidae	Echinostelium	Echinostelium minutum
9729166	9729166	PRJNA801875_P_NODE_3648_length_172_cov_0.854015_g3545_i0	PRJNA801875	3648	172	0.854015	1.4689058	Vannella septentrionalis	197531	Discosea	other_Eukaryota	268	1.32e-67	NTclustered	gi\|300078499\|gb\|GU001161.1\|	197531	g3545	i0	95.783	2.22093023255814	166	7	97	0	3	168	907	1072	Vannella septentrionalis 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	382	268	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella septentrionalis
9729171	9729171	PRJNA801875_P_NODE_3868_length_167_cov_0.886364_g3765_i0	PRJNA801875	3868	167	0.886364	1.48022788	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	54.7	0.004	NTclustered	gi\|470267841\|ref\|XM_004362120.1\|	261658	g3765	i0	100	0.173652694610778	29	0	17	0	14	42	2211	2183	Cavenderia fasciculata putative RNA helicase (ddx42), partial mRNA	blastn	29	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
11004974	11004974	PRJNA801875_P_NODE_1889_length_269_cov_3.696581_g1786_i0	PRJNA801875	1889	269	3.696581	9.94380289	Paravannella minima	1443144	Discosea	other_Eukaryota	468	2.06e-127	NTclustered	gi\|571331048\|gb\|KF895375.1\|	1443144	g1786	i0	98.491	36.0520446096654	265	4	99	0	4	268	725	989	Paravannella minima strain CCAP 1533/1 18S ribosomal RNA gene, partial sequence	blastn	9698	468	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Paravannella	Paravannella minima
13975674	13975674	PRJNA801875_P_NODE_491_length_627_cov_2.251689_g391_i0	PRJNA801875	491	627	2.251689	14.11809003	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	734	0	NTclustered	gi\|33946348\|gb\|AY294153.1\|	197527	g391	i0	88.045	99.4673046251994	619	74	99	0	9	627	954	336	Platyamoeba placida actin mRNA, partial cds	blastn	62366	734	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Platyamoeba	Platyamoeba placida
16103626	16103626	PRJNA801875_P_NODE_753_length_490_cov_3.002198_g651_i0	PRJNA801875	753	490	3.002198	14.7107702	Cochliopodium arabianum	1676989	Discosea	other_Eukaryota	315	5.52e-81	NTclustered	gi\|667063467\|gb\|KJ781461.1\|	1676989	g651	i0	79.079	94	478	85	97	5	1	475	155	620	Cochliopodium arabianum clone YT220 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	46060	315	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium arabianum
18652524	18652524	PRJNA801875_P_NODE_1475_length_319_cov_1.658451_g1372_i0	PRJNA801875	1475	319	1.658451	5.29045869	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	272	2.11e-68	NTclustered	gi\|330822609\|ref\|XM_003291694.1\|	5786	g1372	i0	82.372	1.10031347962382	312	55	98	0	5	316	461	150	Dictyostelium purpureum uncharacterized protein (rasG), mRNA	blastn	351	272	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
20348132	20348132	PRJNA801875_P_NODE_956_length_425_cov_886.702564_g853_i0	PRJNA801875	956	425	886.702564	3768.485897	Vannella	95228	Discosea	other_Eukaryota	669	0	NTclustered	gi\|399764213\|gb\|JQ271724.1\|	1215628	g853	i0	96.543	95.7035294117647	405	13	95	1	19	422	1496	1900	Vannella sp. ACN1 18S ribosomal RNA gene, partial sequence	blastn	40674	671	0.997019374068554	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp. ACN1
25027609	25027609	PRJNA801875_P_NODE_3800_length_168_cov_1.406015_g3697_i0	PRJNA801875	3800	168	1.406015	2.3621052	Cochliopodium larifeili	1017091	Discosea	other_Eukaryota	250	4.66e-62	NTclustered	gi\|330902855\|gb\|JF298253.1\|	1017091	g3697	i0	93.976	6.40476190476191	166	8	98	2	3	166	1270	1105	Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence	blastn	1076	250	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium larifeili
25448372	25448372	PRJNA801875_P_NODE_1680_length_291_cov_9.476562_g1577_i0	PRJNA801875	1680	291	9.476562	27.57679542	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	490	4.819999999999998e-134	NTclustered	gi\|799102480\|gb\|KP792398.1\|	1637493	g1577	i0	97.251	93.9862542955326	291	4	99	3	3	291	25	313	Amoebozoa sp. Pugl67W 18S ribosomal RNA gene, partial sequence	blastn	27350	490	1	Eukaryota	Amoebozoa						Amoebozoa sp. Pugl67W

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