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

9 rows where analysis = "blastn", bioproject = "PRJNA792582" 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
3327970	3327970	PRJNA792582_P_NODE_18243_length_403_cov_1.290909_g17429_i0	PRJNA792582	18243	403	1.290909	5.20236327	Polyschismium peyerimhoffii	2911783	Evosea	other_Eukaryota	276	2.11e-69	NTclustered	gi\|2161226355\|gb\|MZ313553.1\|	2911783	g17429	i0	88.066	36.1712158808933	243	16	58	11	142	376	6800	6563	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	14577	276	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Polyschismium	Polyschismium peyerimhoffii
5043438	5043438	PRJNA792582_P_NODE_14144_length_456_cov_1.932115_g13331_i0	PRJNA792582	14144	456	1.932115	8.8104444	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	811	0	NTclustered	gi\|399764274\|gb\|JQ271785.1\|	1215994	g13331	i0	99.113	15.1008771929825	451	4	99	0	6	456	19	469	Tubulinea group 04 sp. BCHM5 18S ribosomal RNA gene, partial sequence	blastn	6886	817	0.99265605875153	Eukaryota	Amoebozoa	Tubulinea					Tubulinea group 04 sp. BCHM5
5880219	5880219	PRJNA792582_P_NODE_11425_length_504_cov_4.856148_g10615_i0	PRJNA792582	11425	504	4.856148	24.47498592	Vannella sp. strain CAZ6/I	325077	Discosea	other_Eukaryota	782	0	NTclustered	gi\|62865939\|gb\|AY929914.1\|	325077	g10615	i0	94.882	100.789682539683	508	12	100	11	1	504	12	509	Vannella sp. strain CAZ6/I 18S small subunit ribosomal RNA gene, partial sequence	blastn	50798	782	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp. strain CAZ6/I
9705127	9705127	PRJNA792582_P_NODE_21348_length_373_cov_1.003333_g20534_i0	PRJNA792582	21348	373	1.003333	3.74243209	Telaepolella tubasferens	1346289	Evosea	other_Eukaryota	431	3.9e-116	NTclustered	gi\|167859711\|gb\|EU273435.1\|	1346289	g20534	i0	88.219	99.4343163538874	365	38	98	5	1	365	360	1	Telaepolella tubasferens clone 1 actin gene, partial cds	blastn	37089	431	1	Eukaryota	Amoebozoa	Evosea	Variosea		Flamellidae	Telaepolella	Telaepolella tubasferens
10980800	10980800	PRJNA792582_P_NODE_22469_length_363_cov_4.862069_g21655_i0	PRJNA792582	22469	363	4.862069	17.64931047	uncultured Rhizamoeba	1260765	Tubulinea	other_Eukaryota	217	1.15e-51	NTclustered	gi\|511487963\|gb\|JX898537.1\|	1260765	g21655	i0	80.936	26.7988980716253	299	35	79	16	1	285	291	1	Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence	blastn	9728	217	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae		uncultured Rhizamoeba
16079368	16079368	PRJNA792582_P_NODE_27433_length_330_cov_1.186770_g26619_i0	PRJNA792582	27433	330	1.18677	3.916341	Arcyria sp. 'tenuissima'	3129282	Evosea	other_Eukaryota	337	7.66e-88	NTclustered	gi\|2698738389\|gb\|PP491458.1\|	3129282	g26619	i0	85.196	38.4787878787879	331	46	100	2	1	330	703	1031	Arcyria sp. 'tenuissima' voucher sc32644 internal transcribed spacer region, partial sequence	blastn	12698	337	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Arcyria	Arcyria sp. 'tenuissima'
22454145	22454145	PRJNA792582_P_NODE_27398_length_330_cov_1.435798_g26584_i0	PRJNA792582	27398	330	1.435798	4.7381334	Heterostelium album	2086695	Evosea	other_Eukaryota	67.6	1.11e-6	NTclustered	gi\|1160569142\|ref\|XM_020571968.1\|	670386	g26584	i0	97.436	1.65757575757576	39	1	12	0	114	152	42	80	Polysphondylium pallidum PN500 hypothetical protein partial mRNA	blastn	547	67.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
22892997	22892997	PRJNA792582_P_NODE_32238_length_304_cov_2.956710_g31424_i0	PRJNA792582	32238	304	2.95671	8.9883984	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	562	1.06e-155	NTclustered	gi\|399764264\|gb\|JQ271775.1\|	1215986	g31424	i0	100	6.1875	304	0	100	0	1	304	675	978	Tubulinea group 02 sp. 1HFKJ 18S ribosomal RNA gene, partial sequence	blastn	1881	562	1	Eukaryota	Amoebozoa	Tubulinea					Tubulinea group 02 sp. 1HFKJ
23729696	23729696	PRJNA792582_P_NODE_17759_length_409_cov_1.166667_g16945_i0	PRJNA792582	17759	409	1.166667	4.77166803	Didymium spongiosum	289992	Evosea	other_Eukaryota	326	2.1e-84	NTclustered	gi\|2161226356\|gb\|MZ313554.1\|	289992	g16945	i0	83.607	6.60880195599022	366	41	86	16	42	394	7194	7553	Mucilago crustacea 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	2703	326	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium spongiosum

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