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

9 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax_phylum = "Apicomplexa"

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_class	tax_order	tax_family	tax_genus	tax_species
3443475	3443475	PRJNA911178_P_NODE_26303_length_660_cov_1.703578_g23998_i0	PRJNA911178	26303	660	1.703578	11.2436148	Cryptosporidium hominis	237895	SAR_Eukaryotes	SAR_Eukaryotes	1131	0	NTclustered	gi\|67586105\|ref\|XM_660074.1\|	353151	g23998	i0	97.576	2	660	16	100	0	1	660	14	673	Cryptosporidium hominis TU502 sensor histidine kinase (Chro.00003) partial mRNA	blastn	1320	1131	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium hominis
5996058	5996058	PRJNA911178_P_NODE_286165_length_242_cov_1.366864_g283691_i0	PRJNA911178	286165	242	1.366864	3.30781088	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	320	5.41e-83	NTclustered	gi\|1624698154\|ref\|XM_029013945.1\|	189622	g283691	i0	91.81	17.8347107438017	232	16	96	2	1	232	309	81	Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA	blastn	4316	320	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
14004321	14004321	PRJNA911178_P_NODE_284471_length_242_cov_3.603550_g281997_i0	PRJNA911178	284471	242	3.60355	8.720591	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	58.4	4.69e-4	NTclustered	gi\|527046684\|tpe\|HG323586.1\|	5833	g281997	i0	100	1.61570247933884	31	0	13	0	31	61	189	159	TPA: Plasmodium falciparum SRP RNA for signal recognition particle RNA	blastn	391	58.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
14919648	14919648	PRJNA911178_P_NODE_154032_length_301_cov_1.947368_g151559_i0	PRJNA911178	154032	301	1.947368	5.86157768	Plasmodium gonderi	77519	SAR_Eukaryotes	SAR_Eukaryotes	58.4	6.02e-4	NTclustered	gi\|1620950985\|ref\|XM_028687555.1\|	77519	g151559	i0	94.595	0.122923588039867	37	2	12	0	78	114	4479	4443	Plasmodium gonderi hypothetical protein, conserved (PGO_083330), partial mRNA	blastn	37	58.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gonderi
16552473	16552473	PRJNA911178_P_NODE_214113_length_264_cov_1.486911_g211639_i0	PRJNA911178	214113	264	1.486911	3.92544504	Gregarina	35089	SAR_Eukaryotes	SAR_Eukaryotes	448	2.6299999999999993e-121	NTclustered	gi\|473752\|gb\|L31841.1\|GNA18SRRB	35091	g211639	i0	98.054	74.4583333333333	257	5	97	0	6	262	44	300	Gregarina chortiocetes 18S ribosomal RNA gene, partial	blastn	19657	448	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina chortiocetes
18744477	18744477	PRJNA911178_P_NODE_297295_length_238_cov_2.254545_g294821_i0	PRJNA911178	297295	238	2.254545	5.3658171	Eimeria stiedai	471275	SAR_Eukaryotes	SAR_Eukaryotes	399	6.629999999999998e-107	NTclustered	gi\|511997\|emb\|Z33907.1\|	471275	g294821	i0	97.059	1.61344537815126	238	6	100	1	1	238	611	847	E.stiedae (U82/129) DNA sequence (1173bp)	blastn	384	399	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria stiedai
20019599	20019599	PRJNA911178_P_NODE_304316_length_228_cov_2.251613_g301842_i0	PRJNA911178	304316	228	2.251613	5.13367764	Eimeria stiedai	471275	SAR_Eukaryotes	SAR_Eukaryotes	320	5.05e-83	NTclustered	gi\|511997\|emb\|Z33907.1\|	471275	g301842	i0	93.182	1.8859649122807	220	11	96	3	1	220	591	376	E.stiedae (U82/129) DNA sequence (1173bp)	blastn	430	320	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria stiedai
22569933	22569933	PRJNA911178_P_NODE_293878_length_241_cov_0.916667_g291404_i0	PRJNA911178	293878	241	0.916667	2.20916747	Gregarina sp. IF-2020a	2742471	SAR_Eukaryotes	SAR_Eukaryotes	414	2.3999999999999993e-111	NTclustered	gi\|2008918971\|emb\|LR814091.1\|	2742471	g291404	i0	99.13	90.1742738589212	230	2	95	0	12	241	6	235	Gregarina sp. IF-2020a partial 18S rRNA gene, clone SG2.01.SA.2014-28	blastn	21732	414	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina sp. IF-2020a
23843717	23843717	PRJNA911178_P_NODE_129839_length_324_cov_1.215139_g127367_i0	PRJNA911178	129839	324	1.215139	3.93705036	Eimeria acervulina	5801	SAR_Eukaryotes	SAR_Eukaryotes	486	7.039999999999998e-133	NTclustered	gi\|324022090\|gb\|GU593707.1\|	5801	g127367	i0	94.375	98.4567901234568	320	13	98	4	1	316	1877	1559	Eimeria acervulina strain Miska2 28S ribosomal RNA gene, partial sequence	blastn	31900	486	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina

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