metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1242190" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1242190" 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
2901649	2901649	PRJNA1242190_S_NODE_10103_length_272_cov_1.065327_g10096_i0	PRJNA1242190	10103	272	1.065327	2.89768944	Minutocellus polymorphus	265543	SAR_Eukaryotes	SAR_Eukaryotes	115	3.14e-21	NTclustered	gi\|2020303798\|gb\|MW417227.1\|	265543	g10096	i0	78.378	1.29044117647059	185	34	67	6	14	195	8521	8702	Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome	blastn	351	115	1	Eukaryota	Sar	Bacillariophyta	Mediophyceae	Cymatosirales	Cymatosiraceae	Minutocellus	Minutocellus polymorphus
5454315	5454315	PRJNA1242190_S_NODE_11905_length_252_cov_1.748603_g11898_i0	PRJNA1242190	11905	252	1.748603	4.40647956	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	363	9.289999999999996e-96	NTclustered	gi\|347439271\|gb\|JN111984.1\|	151077	g11898	i0	97.63	82.6984126984127	211	5	100	0	42	252	702	912	Chilodonella uncinata strain USA_SC2 clone SP1 beta tubulin (btub) gene, partial cds; macronuclear	blastn	20840	363	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
6153823	6153823	PRJNA1242190_S_NODE_7465_length_311_cov_0.882353_g7458_i0	PRJNA1242190	7465	311	0.882353	2.74411783	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	394	4.189999999999999e-105	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g7458	i0	91.126	86.8006430868167	293	23	94	2	1	293	1946	1657	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	26995	394	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
7428905	7428905	PRJNA1242190_S_NODE_3226_length_435_cov_5.784530_g3219_i0	PRJNA1242190	3226	435	5.78453	25.1627055	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	545	1.5799999999999996e-150	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g3219	i0	96.375	29.6689655172414	331	12	83	0	29	359	32	362	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	12906	545	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
8004148	8004148	PRJNA1242190_S_NODE_13067_length_245_cov_2.848837_g13060_i0	PRJNA1242190	13067	245	2.848837	6.97965065	Sterkiella histriomuscorum	94289	SAR_Eukaryotes	SAR_Eukaryotes	176	1.26e-39	NTclustered	gi\|47176465\|gb\|AY618045.1\|	94289	g13060	i0	93.966	46.4775510204082	116	7	47	0	1	116	537	422	Sterkiella histriomuscorum clone UGC1O0002_L19_F genomic sequence	blastn	11387	176	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Sterkiella	Sterkiella histriomuscorum
8703938	8703938	PRJNA1242190_S_NODE_7027_length_318_cov_5.608163_g7020_i0	PRJNA1242190	7027	318	5.608163	17.83395834	Sterkiella	94288	SAR_Eukaryotes	SAR_Eukaryotes	169	2.8399999999999997e-37	NTclustered	gi\|331686195\|gb\|HQ432921.1\|	94289	g7020	i0	78.309	65.7169811320755	272	51	84	8	20	287	1205	1472	Sterkiella histriomuscorum strain BA elongation factor-1 (ef-1) gene, complete cds; macronuclear	blastn	20898	169	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Sterkiella	Sterkiella histriomuscorum
9279119	9279119	PRJNA1242190_S_NODE_2568_length_470_cov_1.680101_g2561_i0	PRJNA1242190	2568	470	1.680101	7.8964747	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	243	2.53e-59	NTclustered	gi\|673019759\|ref\|XM_008865619.1\|	157072	g2561	i0	79.05	16.8617021276596	358	71	76	4	20	375	127	482	Aphanomyces invadans 40S ribosomal protein S23 mRNA	blastn	7925	243	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
9279126	9279126	PRJNA1242190_S_NODE_308_length_734_cov_4.685325_g303_i0	PRJNA1242190	308	734	4.685325	34.3902855	Stramenopile sp. ex Nuclearia delicatula CCAP1552/1	289359	SAR_Eukaryotes	SAR_Eukaryotes	852	0	NTclustered	gi\|53829555\|gb\|AY582830.1\|	289359	g303	i0	99.362	34.066757493188	470	3	64	0	265	734	1238	769	Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds	blastn	25005	852	1	Eukaryota	Sar						Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
10555008	10555008	PRJNA1242190_S_NODE_3689_length_414_cov_3.938416_g3682_i0	PRJNA1242190	3689	414	3.938416	16.30504224	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	737	0	NTclustered	gi\|300676714\|gb\|GQ377691.1\|	151077	g3682	i0	99.029	51.6594202898551	412	3	99	1	4	414	450	39	Chilodonella uncinata rps22a (rps22a) mRNA, complete cds	blastn	21387	737	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
11829508	11829508	PRJNA1242190_S_NODE_3410_length_427_cov_2.144068_g3403_i0	PRJNA1242190	3410	427	2.144068	9.15517036	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	237	1.06e-57	NTclustered	gi\|673019759\|ref\|XM_008865619.1\|	157072	g3403	i0	80.251	22.5011709601874	319	59	74	4	109	425	127	443	Aphanomyces invadans 40S ribosomal protein S23 mRNA	blastn	9608	237	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
11829540	11829540	PRJNA1242190_S_NODE_6350_length_332_cov_2.583012_g6343_i0	PRJNA1242190	6350	332	2.583012	8.57559984	Karlodinium veneficum	407301	SAR_Eukaryotes	SAR_Eukaryotes	235	2.8899999999999996e-57	NTclustered	gi\|112253700\|gb\|DQ884449.1\|	407301	g6343	i0	81.754	27.1957831325301	285	48	85	3	50	332	541	259	Karlodinium micrum clone Kmi-5p-cDNA18 calmodulin mRNA, complete cds	blastn	9029	235	1	Eukaryota	Sar		Dinophyceae	Gymnodiniales	Kareniaceae	Karlodinium	Karlodinium veneficum
13104753	13104753	PRJNA1242190_S_NODE_13591_length_242_cov_3.597633_g13584_i0	PRJNA1242190	13591	242	3.597633	8.70627186	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	364	2.4699999999999992e-96	NTclustered	gi\|301014695\|gb\|GQ377692.1\|	151077	g13584	i0	93.548	1.02479338842975	248	10	100	2	1	242	499	252	Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence	blastn	248	364	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
13804460	13804460	PRJNA1242190_S_NODE_4011_length_400_cov_5.009174_g4004_i0	PRJNA1242190	4011	400	5.009174	20.036696	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	246	1.64e-60	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g4004	i0	94.375	6.2025	160	9	40	0	1	160	2923	3082	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	2481	246	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
15653843	15653843	PRJNA1242190_S_NODE_11713_length_253_cov_9.638889_g11706_i0	PRJNA1242190	11713	253	9.638889	24.38638917	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	233	7.64e-57	NTclustered	gi\|33327399\|gb\|AF527985.1\|	151077	g11706	i0	97.778	69.9920948616601	135	3	53	0	119	253	1	135	Chilodonella uncinata clone 5 histone H4 (H4) gene, partial cds	blastn	17708	233	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
16928079	16928079	PRJNA1242190_S_NODE_12914_length_246_cov_1.601156_g12907_i0	PRJNA1242190	12914	246	1.601156	3.93884376	Stramenopile sp. ex Nuclearia delicatula CCAP1552/1	289359	SAR_Eukaryotes	SAR_Eukaryotes	141	4.61e-29	NTclustered	gi\|53829589\|gb\|AY582847.1\|	289359	g12907	i0	97.561	19.6544715447154	82	2	33	0	1	82	822	903	Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 actin gene, partial cds	blastn	4835	141	1	Eukaryota	Sar						Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
16928114	16928114	PRJNA1242190_S_NODE_3874_length_406_cov_4.432432_g3867_i0	PRJNA1242190	3874	406	4.432432	17.99567392	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	612	1.4299999999999996e-170	NTclustered	gi\|300676719\|gb\|GQ377693.1\|	151077	g3867	i0	95.55	16.4211822660099	382	17	94	0	25	406	699	318	Chilodonella uncinata gcr5-like mRNA, partial sequence	blastn	6667	612	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
19477017	19477017	PRJNA1242190_S_NODE_5116_length_362_cov_22.913495_g5109_i0	PRJNA1242190	5116	362	22.913495	82.9468519	Poterioochromonas malhamensis	88167	SAR_Eukaryotes	SAR_Eukaryotes	316	1.1e-81	NTclustered	gi\|2088238071\|ref\|NC_056910.1\|	88167	g5109	i0	90.871	57.1767955801105	241	15	66	6	60	298	16014	15779	Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome	blastn	20698	316	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae	Poterioochromonas	Poterioochromonas malhamensis
20752364	20752364	PRJNA1242190_S_NODE_11217_length_258_cov_3.140541_g11210_i0	PRJNA1242190	11217	258	3.140541	8.10259578	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	394	3.39e-105	NTclustered	gi\|110644972\|gb\|DQ665918.1\|	151077	g11210	i0	94.51	94.922480620155	255	14	99	0	1	255	386	640	Chilodonella uncinata clone 1 beta-tubulin gene, partial cds	blastn	24490	394	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
20752368	20752368	PRJNA1242190_S_NODE_1137_length_581_cov_6.525591_g1130_i0	PRJNA1242190	1137	581	6.525591	37.91368371	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	763	0	NTclustered	gi\|110645063\|gb\|DQ665311.1\|	151077	g1130	i0	97.327	40.0636833046472	449	12	77	0	133	581	1205	757	Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear	blastn	23277	763	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
23303340	23303340	PRJNA1242190_S_NODE_7939_length_302_cov_6.406114_g7932_i0	PRJNA1242190	7939	302	6.406114	19.34646428	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	115	3.5400000000000006e-21	NTclustered	gi\|829192014\|ref\|XM_012799966.1\|	312017	g7932	i0	88.421	1.39072847682119	95	11	31	0	161	255	219	125	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	420	115	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
24577202	24577202	PRJNA1242190_S_NODE_3280_length_432_cov_3.286908_g3273_i0	PRJNA1242190	3280	432	3.286908	14.19944256	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	366	1.3099999999999999e-96	NTclustered	gi\|300676719\|gb\|GQ377693.1\|	151077	g3273	i0	90.842	7.16898148148148	273	25	63	0	160	432	539	267	Chilodonella uncinata gcr5-like mRNA, partial sequence	blastn	3097	366	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata

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