metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJEB83101" and tax

17 rows where analysis = "blastn", bioproject = "PRJEB83101" and tax_clade = "Sar"

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
2691670	2691670	PRJEB83101_P_NODE_30843_length_331_cov_3.422481_g30538_i0	PRJEB83101	30843	331	3.422481	11.32841211	Eimeria gruis	300409	SAR_Eukaryotes	SAR_Eukaryotes	520	7.1099999999999985e-143	NTclustered	gi\|345134967\|dbj\|AB619592.1\|	300409	g30538	i0	95.152	84.6042296072508	330	15	99	1	1	329	1706	1377	Eimeria gruis genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence	blastn	28004	520	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria gruis
2693257	2693257	PRJEB83101_P_NODE_89363_length_231_cov_5.905063_g89058_i0	PRJEB83101	89363	231	5.905063	13.64069553	Heterocapsa rotundata	89963	SAR_Eukaryotes	SAR_Eukaryotes	104	5.62e-18	NTclustered	gi\|11055696\|gb\|AY004263.1\|	89963	g89058	i0	100	0.727272727272727	56	0	24	0	173	228	1157	1102	Heterocapsa rotundata 23S ribosomal RNA gene, complete sequence; chloroplast gene for chloroplast product	blastn	168	104	1	Eukaryota	Sar		Dinophyceae	Peridiniales	Heterocapsaceae	Heterocapsa	Heterocapsa rotundata
3967290	3967290	PRJEB83101_P_NODE_15584_length_476_cov_3.707196_g15287_i0	PRJEB83101	15584	476	3.707196	17.64625296	Heterocapsa pygmaea	35672	SAR_Eukaryotes	SAR_Eukaryotes	270	1.1699999999999997e-67	NTclustered	gi\|9437352\|gb\|AF130040.1\|AF130040	35672	g15287	i0	78.419	7.70378151260504	468	64	95	21	13	464	1108	662	Heterocapsa pygmaea 23S ribosomal RNA gene, chloroplast gene for chloroplast RNA, complete sequence	blastn	3667	270	1	Eukaryota	Sar		Dinophyceae	Peridiniales	Heterocapsaceae	Heterocapsa	Heterocapsa pygmaea
3969392	3969392	PRJEB83101_P_NODE_90904_length_221_cov_12.040541_g90599_i0	PRJEB83101	90904	221	12.040541	26.60959561	Protoceratium reticulatum	133427	SAR_Eukaryotes	SAR_Eukaryotes	180	8.61e-41	NTclustered	gi\|11055697\|gb\|AY004264.1\|	133427	g90599	i0	82.938	9.9185520361991	211	24	91	10	12	213	2945	3152	Protoceratium reticulatum 23S ribosomal RNA gene, complete sequence; chloroplast gene for chloroplast product	blastn	2192	180	1	Eukaryota	Sar		Dinophyceae	Gonyaulacales	Protoceratiaceae	Protoceratium	Protoceratium reticulatum
7794145	7794145	PRJEB83101_P_NODE_37627_length_303_cov_3.373913_g37322_i0	PRJEB83101	37627	303	3.373913	10.22295639	Protaspis grandis	361427	SAR_Eukaryotes	SAR_Eukaryotes	292	1.53e-74	NTclustered	gi\|290760486\|gb\|GQ144689.1\|	361427	g37322	i0	86.245	22.3366336633663	269	37	89	0	1	269	2017	1749	Protaspis grandis large subunit ribosomal RNA gene, partial sequence	blastn	6768	292	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida	Thaumatomastigidae	Protaspis	Protaspis grandis
8650858	8650858	PRJEB83101_P_NODE_23487_length_380_cov_0.869707_g23182_i0	PRJEB83101	23487	380	0.869707	3.3048866	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	647	0	NTclustered	gi\|833494855\|ref\|XM_012915027.1\|	5866	g23182	i0	97.368	1215.78421052632	380	10	100	0	1	380	384	5	Babesia bigemina hypothetical protein, conserved partial mRNA	blastn	461998	647	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
12895151	12895151	PRJEB83101_P_NODE_31231_length_329_cov_14.335938_g30926_i0	PRJEB83101	31231	329	14.335938	47.16523602	Eimeria papillata	162632	SAR_Eukaryotes	SAR_Eukaryotes	555	1.9399999999999994e-153	NTclustered	gi\|324022089\|gb\|GU593706.1\|	162632	g30926	i0	97.264	100.322188449848	329	6	100	3	1	329	1588	1913	Eimeria papillata strain Miska1 28S ribosomal RNA gene, partial sequence	blastn	33006	555	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria papillata
13751311	13751311	PRJEB83101_P_NODE_43071_length_288_cov_3.046512_g42766_i0	PRJEB83101	43071	288	3.046512	8.77395456	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	512	1.02e-140	NTclustered	gi\|47935036\|gb\|AY613853.1\|	280247	g42766	i0	99.296	99.2743055555556	284	1	98	1	1	283	76	359	Eimeria arnyi 18S ribosomal RNA gene, partial sequence	blastn	28591	512	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria arnyi
14170850	14170850	PRJEB83101_P_NODE_58992_length_261_cov_2.776596_g58687_i0	PRJEB83101	58992	261	2.776596	7.24691556	Eimeria papillata	162632	SAR_Eukaryotes	SAR_Eukaryotes	187	6.2499999999999984e-43	NTclustered	gi\|324022089\|gb\|GU593706.1\|	162632	g58687	i0	81.301	44.2681992337165	246	33	92	12	1	239	696	457	Eimeria papillata strain Miska1 28S ribosomal RNA gene, partial sequence	blastn	11554	187	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria papillata
15445114	15445114	PRJEB83101_P_NODE_62893_length_255_cov_7.879121_g62588_i0	PRJEB83101	62893	255	7.879121	20.09175855	Leiocephalium pseudosanguineum	2304654	SAR_Eukaryotes	SAR_Eukaryotes	399	7.179999999999999e-107	NTclustered	gi\|983169665\|dbj\|LC068840.1\|	2304654	g62588	i0	94.902	100.407843137255	255	13	100	0	1	255	3946	4200	Leiocephalium pseudosanguineum genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, strain: it12-10kt	blastn	25604	399	1	Eukaryota	Sar		Dinophyceae	Suessiales	Suessiaceae	Leiocephalium	Leiocephalium pseudosanguineum
15445332	15445332	PRJEB83101_P_NODE_70953_length_250_cov_0.881356_g70648_i0	PRJEB83101	70953	250	0.881356	2.20339	Hyaloperonospora parasitica	123356	SAR_Eukaryotes	SAR_Eukaryotes	327	3.36e-85	NTclustered	gi\|169643547\|emb\|CU672241.2\|	123356	g70648	i0	90.65	19.508	246	23	98	0	2	247	10447	10202	H.parasitica DNA sequence from clone HpEmoy2-16O19, complete sequence	blastn	4877	327	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora parasitica
17993043	17993043	PRJEB83101_P_NODE_27735_length_348_cov_8.727273_g27430_i0	PRJEB83101	27735	348	8.727273	30.37091004	Leiocephalium pseudosanguineum	2304654	SAR_Eukaryotes	SAR_Eukaryotes	425	1.69e-114	NTclustered	gi\|983169665\|dbj\|LC068840.1\|	2304654	g27430	i0	88.986	98.3448275862069	345	37	99	1	4	348	2327	2670	Leiocephalium pseudosanguineum genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, strain: it12-10kt	blastn	34224	425	1	Eukaryota	Sar		Dinophyceae	Suessiales	Suessiaceae	Leiocephalium	Leiocephalium pseudosanguineum
19268643	19268643	PRJEB83101_P_NODE_88156_length_236_cov_3.104294_g87851_i0	PRJEB83101	88156	236	3.104294	7.32613384	Kryptoperidinium triquetrum	66468	SAR_Eukaryotes	SAR_Eukaryotes	207	4.27e-49	NTclustered	gi\|239918912\|gb\|FJ491256.1\|	66468	g87851	i0	95.42	3.67372881355932	131	5	56	1	104	234	1410	1281	Heterocapsa triquetra 16S ribosomal RNA, partial sequence; chloroplast	blastn	867	207	1	Eukaryota	Sar		Dinophyceae	Peridiniales	Kryptoperidiniaceae	Kryptoperidinium	Kryptoperidinium triquetrum
21817861	21817861	PRJEB83101_P_NODE_14938_length_488_cov_7.383133_g14641_i0	PRJEB83101	14938	488	7.383133	36.02968904	Polarella glacialis	89957	SAR_Eukaryotes	SAR_Eukaryotes	220	1.23e-52	NTclustered	gi\|344227665\|gb\|JN558036.1\|	89957	g14641	i0	84.016	7.44262295081967	244	23	61	13	21	254	606	369	Polarella glacialis voucher CCMP1383 clone 1 23S ribosomal RNA gene, partial sequence; chloroplast	blastn	3632	220	1	Eukaryota	Sar		Dinophyceae	Suessiales	Suessiaceae	Polarella	Polarella glacialis
21818974	21818974	PRJEB83101_P_NODE_53898_length_269_cov_4.188776_g53593_i0	PRJEB83101	53898	269	4.188776	11.26780744	Eimeria collieie	1576367	SAR_Eukaryotes	SAR_Eukaryotes	326	1.31e-84	NTclustered	gi\|726968578\|gb\|KJ700636.1\|	1576367	g53593	i0	88.519	46.728624535316	270	29	100	2	1	269	612	344	Eimeria collieie large subunit ribosomal RNA gene, partial sequence	blastn	12570	326	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria collieie
21819553	21819553	PRJEB83101_P_NODE_76158_length_247_cov_0.896552_g75853_i0	PRJEB83101	76158	247	0.896552	2.21448344	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	300	7.22e-77	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g75853	i0	91.031	17.914979757085	223	19	99	1	25	247	300291	300512	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	4425	300	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
24369002	24369002	PRJEB83101_P_NODE_90840_length_224_cov_5.324503_g90535_i0	PRJEB83101	90840	224	5.324503	11.92688672	Nematodinium sp.	1678892	SAR_Eukaryotes	SAR_Eukaryotes	128	3.21e-25	NTclustered	gi\|2315199848\|gb\|OP604696.1\|	1678892	g90535	i0	77.333	1.00446428571429	225	45	99	6	3	224	2712	2491	Nematodinium sp. isolate Nm-QI1 large subunit ribosomal RNA gene, partial sequence	blastn	225	128	1	Eukaryota	Sar		Dinophyceae	Gymnodiniales	Warnowiaceae	Nematodinium	Nematodinium sp.

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