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

9 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax_phylum = "Perkinsozoa"

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_order	tax_family	tax_genus	tax_species
277575	277575	PRJNA1122875_P_NODE_22141_length_352_cov_2.448029_g21917_i0	PRJNA1122875	22141	352	2.448029	8.61706208	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	158	6.85e-34	NTclustered	gi\|294881230\|ref\|XM_002769261.1\|	423536	g21917	i0	78.776	17.2073863636364	245	44	68	6	112	352	49	289	Perkinsus marinus ATCC 50983 60S ribosomal protein L27a, putative, mRNA	blastn	6057	158	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
2828019	2828019	PRJNA1122875_P_NODE_10883_length_503_cov_21.695349_g10662_i0	PRJNA1122875	10883	503	21.695349	109.12760547	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	305	3.42e-78	NTclustered	gi\|294897197\|ref\|XM_002775826.1\|	423536	g10662	i0	79.817	50.675944333996	436	74	85	12	34	462	457	29	Perkinsus marinus ATCC 50983 60S ribosomal protein L27a, putative, mRNA	blastn	25490	305	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
2828621	2828621	PRJNA1122875_P_NODE_543_length_1415_cov_7.156483_g479_i0	PRJNA1122875	543	1415	7.156483	101.26423445	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	628	5.27e-175	NTclustered	gi\|294955937\|ref\|XM_002788709.1\|	423536	g479	i0	78.457	59.8120141342756	998	190	70	22	43	1029	16	999	Perkinsus marinus ATCC 50983 glyceraldehyde 3-phosphate dehydrogenase, putative, mRNA	blastn	84634	628	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
13031138	13031138	PRJNA1122875_P_NODE_16391_length_413_cov_1.300000_g16167_i0	PRJNA1122875	16391	413	1.3	5.369	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	211	6.19e-50	NTclustered	gi\|294949007\|ref\|XM_002785960.1\|	423536	g16167	i0	77.557	62.2929782082324	352	77	85	2	60	410	6	356	Perkinsus marinus ATCC 50983 elongation factor 2, putative, mRNA	blastn	25727	211	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
15580597	15580597	PRJNA1122875_P_NODE_4233_length_747_cov_5.574184_g4035_i0	PRJNA1122875	4233	747	5.574184	41.63915448	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	324	1.44e-83	NTclustered	gi\|294874491\|ref\|XM_002766937.1\|	423536	g4035	i0	79.046	53.2168674698795	482	93	64	7	121	598	606	129	Perkinsus marinus ATCC 50983 40S ribosomal protein S5, putative, mRNA	blastn	39753	324	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
16855239	16855239	PRJNA1122875_P_NODE_9534_length_534_cov_2.416486_g9315_i0	PRJNA1122875	9534	534	2.416486	12.90403524	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	300	1.7e-76	NTclustered	gi\|294933094\|ref\|XM_002780549.1\|	423536	g9315	i0	80.049	59.6198501872659	406	79	76	2	130	534	117	521	Perkinsus marinus ATCC 50983 40S ribosomal protein S5, putative, mRNA	blastn	31837	300	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
19403819	19403819	PRJNA1122875_P_NODE_6796_length_616_cov_2.856354_g6580_i0	PRJNA1122875	6796	616	2.856354	17.59514064	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	292	3.31e-74	NTclustered	gi\|294933094\|ref\|XM_002780549.1\|	423536	g6580	i0	77.847	26.2857142857143	483	99	78	8	135	613	596	118	Perkinsus marinus ATCC 50983 40S ribosomal protein S5, putative, mRNA	blastn	16192	292	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
21954352	21954352	PRJNA1122875_P_NODE_25178_length_331_cov_0.934109_g24954_i0	PRJNA1122875	25178	331	0.934109	3.09190079	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	202	2.92e-47	NTclustered	gi\|294927756\|ref\|XM_002779126.1\|	423536	g24954	i0	81.275	52.4350453172205	251	45	76	2	82	331	1260	1011	Perkinsus marinus ATCC 50983 Tubulin alpha chain, putative, mRNA	blastn	17356	202	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
23229918	23229918	PRJNA1122875_P_NODE_2819_length_866_cov_36.972257_g2651_i0	PRJNA1122875	2819	866	36.972257	320.17974562	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	115	1.1e-20	NTclustered	gi\|294932372\|ref\|XM_002780194.1\|	423536	g2651	i0	76.852	8.7159353348729791	216	42	24	6	618	829	244	33	Perkinsus marinus ATCC 50983 40S ribosomal protein S25, putative, mRNA	blastn	7548	115	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus

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