metadata: contig_metadata: 9 rows where bioproject = "PRJNA1010662" and tax

9 rows where bioproject = "PRJNA1010662" 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
2705136	2705136	PRJNA1010662_P_NODE_3843_length_267_cov_1.692661_g3784_i0	PRJNA1010662	3843	267	1.692661	4.51940487	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	119	2.37e-22	NTclustered	gi\|923136453\|ref\|XM_013906238.1\|	461836	g3784	i0	84.746	0.602996254681648	118	18	44	0	15	132	265	148	Thecamonas trahens ATCC 50062 50S ribosomal protein L36e (AMSG_01644), partial mRNA	blastn	161	119	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
3981366	3981366	PRJNA1010662_P_NODE_6364_length_218_cov_2.266272_g6305_i0	PRJNA1010662	6364	218	2.266272	4.94047296	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	83.6	7.89e-17	NR	XP_013762925.1	461836	g6305	i0	52.9	1.84403669724771	68	32	93.6	0	1	204	259	326	XP_013762925.1 cruzipain [Thecamonas trahens ATCC 50062]	diamond	402	83.6	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
19280405	19280405	PRJNA1010662_P_NODE_1496_length_415_cov_5.251366_g1437_i0	PRJNA1010662	1496	415	5.251366	21.7931689	Karpovia croatica	2925417	Root_unresolved	Root_unresolved	102	3.91e-17	NTclustered	gi\|2206682173\|gb\|OM966646.1\|	2925417	g1437	i0	87.64	14.7012048192771	89	9	21	2	21	108	6107	6020	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
26844900	26844900	PRJNA1010662_P_NODE_7341_length_207_cov_1.930380_g7282_i0	PRJNA1010662	7341	207	1.93038	3.9958866	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	48.5	9.8e-5	NR	XP_013753243.1	461836	g7282	i0	41.4	1.01449275362319	70	40	100	1	207	1	7	76	XP_013753243.1 uncharacterized protein AMSG_10809 [Thecamonas trahens ATCC 50062]	diamond	210	48.5	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
26971093	26971093	PRJNA1010662_P_NODE_2182_length_344_cov_1.400000_g2123_i0	PRJNA1010662	2182	344	1.4	4.816	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	76.3	2.09e-13	NR	XP_013763036.1	461836	g2123	i0	44.6	0.976744186046512	112	50	90.7	4	316	5	380	487	XP_013763036.1 tripeptidyl peptidase [Thecamonas trahens ATCC 50062]	diamond	336	76.3	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28195461	28195461	PRJNA1010662_P_NODE_14806_length_165_cov_0.896552_g14747_i0	PRJNA1010662	14806	165	0.896552	1.4793108	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	51.6	9.43e-6	NR	XP_013761031.1	461836	g14747	i0	50.9	3.85454545454545	53	26	96.4	0	163	5	251	303	XP_013761031.1 Cullin-3 [Thecamonas trahens ATCC 50062]	diamond	636	52	0.992307692307692	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28455892	28455892	PRJNA1010662_P_NODE_2906_length_303_cov_1.228346_g2847_i0	PRJNA1010662	2906	303	1.228346	3.72188838	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	96.7	3.75e-22	NR	XP_013762487.1	461836	g2847	i0	55	0.792079207920792	80	36	79.2	0	303	64	152	231	XP_013762487.1 countin-1 [Thecamonas trahens ATCC 50062]	diamond	240	96.7	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29529348	29529348	PRJNA1010662_P_NODE_3590_length_274_cov_2.937778_g3531_i0	PRJNA1010662	3590	274	2.937778	8.04951172	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	86.3	2.66e-17	NR	XP_013760714.1	461836	g3531	i0	50.6	0.974452554744526	89	42	97.4	2	271	5	143	229	XP_013760714.1 surfactant protein B containing protein [Thecamonas trahens ATCC 50062]	diamond	267	86.3	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
31677903	31677903	PRJNA1010662_P_NODE_14577_length_165_cov_1.327586_g14518_i0	PRJNA1010662	14577	165	1.327586	2.1905169	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	62.8	1.08e-9	NR	XP_013760629.1	461836	g14518	i0	68.3	0.745454545454545	41	13	74.5	0	5	127	857	897	XP_013760629.1 uncharacterized protein AMSG_02788 [Thecamonas trahens ATCC 50062]	diamond	123	62.8	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);;