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

9 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax_clade = "Apusozoa"

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_order	tax_family	tax_genus	tax_species
2828105	2828105	PRJNA1122875_P_NODE_15683_length_421_cov_2.873563_g15459_i0	PRJNA1122875	15683	421	2.873563	12.09770023	Karpovia croatica	2925417	Root_unresolved	Root_unresolved	102	3.97e-17	NTclustered	gi\|2206682173\|gb\|OM966646.1\|	2925417	g15459	i0	87.64	14.4916864608076	89	9	21	2	332	419	6020	6107	Karpovia croatica strain CRO19P6 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	6101	102	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Karpovia	Karpovia croatica
6655389	6655389	PRJNA1122875_P_NODE_2386_length_914_cov_5.514863_g2230_i0	PRJNA1122875	2386	914	5.514863	50.40584782	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	121	2.5000000000000002e-22	NTclustered	gi\|923136453\|ref\|XM_013906238.1\|	461836	g2230	i0	81.818	0.231947483588621	143	26	16	0	635	777	290	148	Thecamonas trahens ATCC 50062 50S ribosomal protein L36e (AMSG_01644), partial mRNA	blastn	212	121	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
7930585	7930585	PRJNA1122875_P_NODE_3387_length_814_cov_1.514170_g3201_i0	PRJNA1122875	3387	814	1.51417	12.3253438	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	396	3.28e-105	NTclustered	gi\|923137248\|ref\|XM_013906635.1\|	461836	g3201	i0	80.99	20.0687960687961	505	90	62	6	19	520	1379	1880	Thecamonas trahens ATCC 50062 inositol-3-phosphate synthase (AMSG_00912), mRNA	blastn	16336	396	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
18129406	18129406	PRJNA1122875_P_NODE_33795_length_284_cov_1.090047_g33571_i0	PRJNA1122875	33795	284	1.090047	3.09573348	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	259	1.44e-64	NTclustered	gi\|923130274\|ref\|XM_013903149.1\|	461836	g33571	i0	83.099	62.2359154929577	284	48	100	0	1	284	699	416	Thecamonas trahens ATCC 50062 14-3-3 family protein epsilon (AMSG_04940), partial mRNA	blastn	17675	259	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
20679108	20679108	PRJNA1122875_P_NODE_34917_length_280_cov_1.478261_g34693_i0	PRJNA1122875	34917	280	1.478261	4.1391308	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	222	1.86e-53	NTclustered	gi\|923123038\|ref\|XM_013899535.1\|	461836	g34693	i0	87.179	35.1571428571429	195	25	70	0	13	207	631	825	Thecamonas trahens ATCC 50062 rRNA 2'-O-methyltransferase fibrillarin (AMSG_09053), partial mRNA	blastn	9844	222	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
21954229	21954229	PRJNA1122875_P_NODE_14918_length_432_cov_1.810585_g14694_i0	PRJNA1122875	14918	432	1.8105850000000001	7.8217272	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	231	4.99e-56	NTclustered	gi\|923137248\|ref\|XM_013906635.1\|	461836	g14694	i0	82.182	39.9861111111111	275	43	84	6	1	272	1492	1221	Thecamonas trahens ATCC 50062 inositol-3-phosphate synthase (AMSG_00912), mRNA	blastn	17274	231	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
23229759	23229759	PRJNA1122875_P_NODE_14439_length_439_cov_1.855191_g14215_i0	PRJNA1122875	14439	439	1.855191	8.14428849	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	130	1.91e-25	NTclustered	gi\|761380055\|ref\|NC_026452.1\|	529818	g14215	i0	84.173	40.8359908883827	139	17	31	4	265	401	1479	1614	Thecamonas trahens strain ATCC 50062 mitochondrion, complete genome	blastn	17927	130	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
24503558	24503558	PRJNA1122875_P_NODE_3080_length_842_cov_25.039012_g2903_i0	PRJNA1122875	3080	842	25.039012	210.82848104	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	154	2.26e-32	NTclustered	gi\|923132316\|ref\|XM_013904170.1\|	461836	g2903	i0	86.957	3.33729216152019	138	16	16	2	47	183	17	153	Thecamonas trahens ATCC 50062 50S ribosomal protein L37a (AMSG_03714), partial mRNA	blastn	2810	154	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
24503560	24503560	PRJNA1122875_P_NODE_30880_length_294_cov_0.882353_g30656_i0	PRJNA1122875	30880	294	0.882353	2.59411782	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	187	7.169999999999998e-43	NTclustered	gi\|923127836\|ref\|XM_013901931.1\|	461836	g30656	i0	78.595	11.265306122449	299	52	99	11	2	294	824	532	Thecamonas trahens ATCC 50062 transmembrane protein 91 (AMSG_06205), partial mRNA	blastn	3312	187	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens

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