metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1002816" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1002816" and tax_phylum = "Heterolobosea"

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_family	tax_genus	tax_species
3979297	3979297	PRJNA1002816_P_NODE_18284_length_249_cov_0.875000_g18124_i0	PRJNA1002816	18284	249	0.875	2.17875	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	318	2.0099999999999998e-82	NTclustered	gi\|290995373\|ref\|XM_002680224.1\|	5762	g18124	i0	90.456	0.967871485943775	241	23	97	0	9	249	1147	907	Naegleria gruberi N-hydroxycinnamoyl/benzoyltransferase (NAEGRDRAFT_57329), mRNA	blastn	241	318	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
5255746	5255746	PRJNA1002816_P_NODE_17545_length_251_cov_0.865169_g17385_i0	PRJNA1002816	17545	251	0.865169	2.17157419	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	392	1.18e-104	NTclustered	gi\|290980684\|ref\|XM_002673016.1\|	5762	g17385	i0	94.821	1.9840637450199201	251	13	100	0	1	251	327	77	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_56300), mRNA	blastn	498	392	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
6530970	6530970	PRJNA1002816_P_NODE_14166_length_290_cov_1.447005_g14006_i0	PRJNA1002816	14166	290	1.447005	4.1963145	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	508	1.33e-139	NTclustered	gi\|290985314\|ref\|XM_002675325.1\|	5762	g14006	i0	98.276	6.30344827586207	290	5	100	0	1	290	297	586	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_80333), mRNA	blastn	1828	508	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
7805615	7805615	PRJNA1002816_P_NODE_9087_length_372_cov_1.354515_g8927_i0	PRJNA1002816	9087	372	1.354515	5.0387958	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	627	4.6199999999999986e-175	NTclustered	gi\|290991132\|ref\|XM_002678144.1\|	5762	g8927	i0	97.043	1.98655913978495	372	11	100	0	1	372	720	349	Naegleria gruberi ribosomal protein L3 (NAEGRDRAFT_79448), mRNA	blastn	739	627	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
9080412	9080412	PRJNA1002816_P_NODE_20908_length_241_cov_0.916667_g20748_i0	PRJNA1002816	20908	241	0.916667	2.20916747	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	320	5.39e-83	NTclustered	gi\|290996627\|ref\|XM_002680838.1\|	5762	g20748	i0	90.65	1.0207468879668	246	15	99	4	1	239	1313	1557	Naegleria gruberi malate dehydrogenase (NAEGRDRAFT_77259), mRNA	blastn	246	320	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
10356061	10356061	PRJNA1002816_P_NODE_18069_length_249_cov_1.738636_g17909_i0	PRJNA1002816	18069	249	1.738636	4.32920364	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	399	6.989999999999999e-107	NTclustered	gi\|290997743\|ref\|XM_002681395.1\|	5762	g17909	i0	95.582	2.99196787148594	249	11	100	0	1	249	1065	817	Naegleria gruberi PCI domain-containing protein (NAEGRDRAFT_77238), partial mRNA	blastn	745	399	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
14181469	14181469	PRJNA1002816_P_NODE_15032_length_280_cov_1.463768_g14872_i0	PRJNA1002816	15032	280	1.463768	4.0985504	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	473	4.649999999999999e-129	NTclustered	gi\|290988713\|ref\|XM_002676993.1\|	5762	g14872	i0	97.163	9.36785714285714	282	5	100	2	1	280	304	24	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_36760), mRNA	blastn	2623	473	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
14181533	14181533	PRJNA1002816_P_NODE_18152_length_249_cov_0.875000_g17992_i0	PRJNA1002816	18152	249	0.875	2.17875	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	377	3.27e-100	NTclustered	gi\|290994379\|ref\|XM_002679764.1\|	5762	g17992	i0	94.309	3.95983935742972	246	14	99	0	3	248	290	45	Naegleria gruberi 60S ribosomal protein L9 (NAEGRDRAFT_38410), mRNA	blastn	986	377	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
16729723	16729723	PRJNA1002816_P_NODE_13474_length_300_cov_1.308370_g13314_i0	PRJNA1002816	13474	300	1.30837	3.92511	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	449	8.47e-122	NTclustered	gi\|290972448\|ref\|XM_002668919.1\|	5762	g13314	i0	93.667	3.00666666666667	300	19	100	0	1	300	400	101	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_60048), mRNA	blastn	902	449	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
19278328	19278328	PRJNA1002816_P_NODE_11896_length_321_cov_1.766129_g11736_i0	PRJNA1002816	11896	321	1.766129	5.66927409	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	586	6.679999999999997e-163	NTclustered	gi\|290999169\|ref\|XM_002682107.1\|	5762	g11736	i0	99.688	7.39252336448598	320	1	99	0	1	320	16	335	Naegleria gruberi 40S ribosomal protein S16 (NAEGRDRAFT_35163), partial mRNA	blastn	2373	586	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi

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