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

9 rows where analysis = "blastn", bioproject = "PRJNA857143" 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
5947142	5947142	PRJNA857143_S_NODE_22265_length_512_cov_119.498861_g21179_i0	PRJNA857143	22265	512	119.498861	611.83416832	Vannellidae sp.	2491907	Discosea	other_Eukaryota	255	3.5600000000000003e-63	NTclustered	gi\|1523769315\|gb\|MH535957.1\|	2491907	g21179	i0	79.644	35.921875	393	51	75	23	20	401	325	699	Vannellidae sp. strain 151-1SVA_C2 18S ribosomal RNA gene, partial sequence; mitochondrial	blastn	18392	255	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae		Vannellidae sp.
6339275	6339275	PRJNA857143_S_NODE_195685_length_241_cov_2.785714_g194592_i0	PRJNA857143	195685	241	2.785714	6.71357074	root	1	Root_unresolved	Root_unresolved	52.8	0.022	NTclustered	gi\|470253359\|ref\|XM_004359721.1\|	261658	g194592	i0	100	0.232365145228216	28	0	12	0	35	62	26	53	Cavenderia fasciculata N2227-like domain-containing protein (DFA_01813), partial mRNA	blastn	56	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
8497138	8497138	PRJNA857143_S_NODE_59727_length_374_cov_1.554817_g58634_i0	PRJNA857143	59727	374	1.554817	5.81501558	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	54.7	0.01	NTclustered	gi\|66800670\|ref\|XM_629259.1\|	352472	g58634	i0	96.875	0.0855614973262032	32	1	9	0	302	333	3105	3074	Dictyostelium discoideum AX4 chromo domain-containing protein (DDB_G0293012) mRNA, complete cds	blastn	32	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
9771375	9771375	PRJNA857143_S_NODE_153288_length_264_cov_1.633508_g152195_i0	PRJNA857143	153288	264	1.633508	4.31246112	Paravannella minima	1443144	Discosea	other_Eukaryota	182	2.95e-41	NTclustered	gi\|1583105587\|ref\|NC_040955.1\|	1443144	g152195	i0	81.304	19.219696969697	230	37	86	4	4	230	52418	52192	Paravannella minima mitochondrion, complete genome	blastn	5074	182	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Paravannella	Paravannella minima
11047418	11047418	PRJNA857143_S_NODE_194289_length_242_cov_1.337278_g193196_i0	PRJNA857143	194289	242	1.337278	3.23621276	uncultured myxomycete	385478	Evosea	other_Eukaryota	424	4.01e-114	NTclustered	gi\|1133508007\|emb\|LT670649.1\|	385478	g193196	i0	98.347	100.334710743802	242	3	100	1	1	242	24	264	Uncultured myxomycete partial 18S rRNA gene, isolate OTU429	blastn	24281	424	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa				uncultured myxomycete
12322543	12322543	PRJNA857143_S_NODE_154110_length_263_cov_2.768421_g153017_i0	PRJNA857143	154110	263	2.768421	7.28094723	Acanthamoeba tubiashi	65665	Discosea	other_Eukaryota	115	3.02e-21	NTclustered	gi\|28194601\|gb\|AF479545.1\|	65665	g153017	i0	88.542	32.4980988593156	96	9	59	2	155	249	1191	1285	Acanthamoeba tubiashi strain OC15C 16S small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product	blastn	8547	115	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba tubiashi
12323427	12323427	PRJNA857143_S_NODE_58970_length_375_cov_4.043046_g57877_i0	PRJNA857143	58970	375	4.043046	15.1614225	Phalansterium solitarium	136499	Evosea	other_Eukaryota	198	4.33e-46	NTclustered	gi\|300078500\|gb\|GU001162.1\|	136499	g57877	i0	77.839	36.1626666666667	361	53	92	20	30	375	3007	3355	Phalansterium solitarium 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	13561	198	1	Eukaryota	Amoebozoa	Evosea	Variosea			Phalansterium	Phalansterium solitarium
18695212	18695212	PRJNA857143_S_NODE_23755_length_501_cov_34.289720_g22668_i0	PRJNA857143	23755	501	34.28972	171.7914972	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	200	1.6499999999999999e-46	NTclustered	gi\|470442906\|ref\|XM_004339540.1\|	1257118	g22668	i0	79.514	14.5389221556886	288	53	57	5	113	397	318	34	Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA	blastn	7284	200	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
21637382	21637382	PRJNA857143_S_NODE_4357_length_914_cov_14.350773_g3661_i0	PRJNA857143	4357	914	14.350773	131.16606522	Paramoeba	200890	Discosea	other_Eukaryota	182	1.13e-40	NTclustered	gi\|218218324\|gb\|EU884491.1\|	308475	g3661	i0	88.235	16.7428884026258	153	16	17	2	627	777	244	396	Paramoeba branchiphila clone SM53 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence	blastn	15303	182	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba branchiphila

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