metadata: contig_metadata: 10 rows where bioproject = "PRJNA438572" and tax

10 rows where bioproject = "PRJNA438572" 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
6812914	6812914	PRJNA438572_P_NODE_506_length_1201_cov_11.992908_g457_i0	PRJNA438572	506	1201	11.992908	144.03482508	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	401	1.89e-135	NR	XP_013760592.1	461836	g457	i0	67.9	0.746877601998335	299	92	74.2	2	1144	254	43	339	XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062]	diamond	897	401	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
9363241	9363241	PRJNA438572_P_NODE_9708_length_328_cov_2.035294_g9589_i0	PRJNA438572	9708	328	2.035294	6.67576432	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	133	3.65e-35	NR	XP_013760592.1	461836	g9589	i0	60.7	2.9359756097561	107	40	97.9	1	327	7	224	328	XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062]	diamond	963	133	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
20836475	20836475	PRJNA438572_P_NODE_11997_length_297_cov_0.977679_g11878_i0	PRJNA438572	11997	297	0.977679	2.90370663	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	241	5.49e-59	NTclustered	gi\|923138192\|ref\|XM_013907107.1\|	461836	g11878	i0	81.481	79.8821548821549	297	51	99	4	1	295	1076	1370	Thecamonas trahens ATCC 50062 luminal-binding protein 5 (AMSG_00842), partial mRNA	blastn	23725	241	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28323904	28323904	PRJNA438572_P_NODE_24646_length_242_cov_0.875740_g24527_i0	PRJNA438572	24646	242	0.87574	2.1192908	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.5	3.24e-4	NR	XP_013762273.1	461836	g24527	i0	42.6	2.50413223140496	68	35	79.3	2	23	214	227	294	XP_013762273.1 uncharacterized protein AMSG_01101, partial [Thecamonas trahens ATCC 50062]	diamond	606	48.5	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28434082	28434082	PRJNA438572_P_NODE_6326_length_399_cov_1.365031_g6207_i0	PRJNA438572	6326	399	1.365031	5.44647369	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	162	1.67e-44	NR	XP_013759182.1	461836	g6207	i0	59.2	0.977443609022556	130	51	97.7	1	2	391	275	402	XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062]	diamond	390	162	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28592002	28592002	PRJNA438572_P_NODE_18087_length_251_cov_0.876404_g17968_i0	PRJNA438572	18087	251	0.876404	2.19977404	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	93.2	6.8e-20	NR	XP_013752868.1	461836	g17968	i0	51.9	0.944223107569721	79	38	94.4	0	1	237	211	289	XP_013752868.1 carboxylesterase [Thecamonas trahens ATCC 50062]	diamond	237	93.2	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28623629	28623629	PRJNA438572_P_NODE_21827_length_246_cov_0.901734_g21708_i0	PRJNA438572	21827	246	0.901734	2.21826564	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	85.1	4.81e-18	NR	XP_013755608.1	461836	g21708	i0	51.3	1.91463414634146	78	38	95.1	0	245	12	154	231	XP_013755608.1 40S ribosomal protein [Thecamonas trahens ATCC 50062]	diamond	471	85.1	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29160461	29160461	PRJNA438572_P_NODE_13369_length_284_cov_1.109005_g13250_i0	PRJNA438572	13369	284	1.109005	3.1495742	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	63.2	3.98e-9	NR	XP_013759266.1	461836	g13250	i0	36.7	0.950704225352113	90	50	95.1	1	278	9	549	631	XP_013759266.1 serine/threonine protein kinase [Thecamonas trahens ATCC 50062]	diamond	270	63.2	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
30549829	30549829	PRJNA438572_P_NODE_11553_length_302_cov_1.851528_g11434_i0	PRJNA438572	11553	302	1.851528	5.59161456	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	88.6	5.7e-18	NR	XP_013759182.1	461836	g11434	i0	46.8	0.933774834437086	94	50	93.4	0	283	2	151	244	XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062]	diamond	282	88.6	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
32352544	32352544	PRJNA438572_P_NODE_5139_length_439_cov_1.229508_g5020_i0	PRJNA438572	5139	439	1.229508	5.39754012	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	83.2	2.29e-15	NR	XP_013754710.1	461836	g5020	i0	34.1	0.840546697038724	123	74	79.3	3	39	386	534	656	XP_013754710.1 uncharacterized protein AMSG_09324 [Thecamonas trahens ATCC 50062]	diamond	369	83.2	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);;