metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1132896" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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
4110617	4110617	PRJNA1132896_P_NODE_10024_length_242_cov_0.781065_g9933_i0	PRJNA1132896	10024	242	0.781065	1.8901773	Poterioochromonas malhamensis	88167	SAR_Eukaryotes	SAR_Eukaryotes	436	5.1499999999999985e-118	NTclustered	gi\|323690576\|gb\|GU935635.1\|	88167	g9933	i0	99.174	98.4214876033058	242	2	100	0	1	242	1799	1558	Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence	blastn	23818	436	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae	Poterioochromonas	Poterioochromonas malhamensis
4110631	4110631	PRJNA1132896_P_NODE_2064_length_377_cov_1.009868_g1973_i0	PRJNA1132896	2064	377	1.009868	3.80720236	Spumella sp. OF-40	1432661	SAR_Eukaryotes	SAR_Eukaryotes	394	5.18e-105	NTclustered	gi\|677286268\|gb\|KF997856.1\|	1432661	g1973	i0	85.791	98.6206896551724	373	52	99	1	6	377	682	310	Spumella sp. OF-40 translation elongation factor 1-alpha (EF1A) mRNA, complete cds	blastn	37180	394	1	Eukaryota	Sar		Chrysophyceae	Chromulinales	Chromulinaceae	Spumella	Spumella sp. OF-40
5386824	5386824	PRJNA1132896_P_NODE_3725_length_295_cov_1.040541_g3634_i0	PRJNA1132896	3725	295	1.040541	3.06959595	Loxophyllum shini	1346494	SAR_Eukaryotes	SAR_Eukaryotes	455	1.7900000000000002e-123	NTclustered	gi\|375305428\|gb\|JF975388.1\|	1346494	g3634	i0	94.558	98.7050847457627	294	16	99	0	1	294	1339	1046	Loxophyllum shini isolate PHB2007053101 28S ribosomal RNA gene, partial sequence	blastn	29118	455	1	Eukaryota	Sar	Ciliophora	Litostomatea	Pleurostomatida	Litonotidae	Loxophyllum	Loxophyllum shini
11235113	11235113	PRJNA1132896_P_NODE_2689_length_338_cov_1.056604_g2598_i0	PRJNA1132896	2689	338	1.056604	3.57132152	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	370	7.76e-98	NTclustered	gi\|161015620\|gb\|EF577220.1\|	293189	g2598	i0	86.391	90.2278106508876	338	46	100	0	1	338	149	486	Spumella-like flagellate JBNZ41 alpha-tubulin gene, partial cds	blastn	30497	370	1	Eukaryota	Sar		Chrysophyceae				Spumella-like flagellate JBNZ41
12510506	12510506	PRJNA1132896_P_NODE_6310_length_256_cov_1.683060_g6219_i0	PRJNA1132896	6310	256	1.68306	4.3086336	Tribonema	2980	SAR_Eukaryotes	SAR_Eukaryotes	126	1.35e-24	NTclustered	gi\|2286039\|emb\|Y07979.1\|	2981	g6219	i0	85.95	47.6171875	121	14	47	3	18	137	2038	1920	T.aequale 28S rRNA gene and ITS2 DNA	blastn	12190	126	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Tribonemataceae	Tribonema	Tribonema aequale
13037304	13037304	PRJNA1132896_P_NODE_10271_length_241_cov_0.916667_g10180_i0	PRJNA1132896	10271	241	0.916667	2.20916747	Cryptosporidium parvum	5807	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|66359733\|ref\|XM_627045.1\|	353152	g10180	i0	100	0.116182572614108	28	0	12	0	22	49	658	685	Cryptosporidium parvum Iowa II hypothetical protein (cgd8_1380) partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
15059460	15059460	PRJNA1132896_P_NODE_3012_length_322_cov_1.216867_g2921_i0	PRJNA1132896	3012	322	1.216867	3.91831174	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	590	5.18e-164	NTclustered	gi\|937630026\|gb\|KP342049.1\|	88167	g2921	i0	99.689	101	322	1	100	0	1	322	1168	847	Poterioochromonas malhamensis strain GD001 18S ribosomal RNA gene, partial sequence	blastn	32522	590	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae	Poterioochromonas	Poterioochromonas malhamensis
15586583	15586583	PRJNA1132896_P_NODE_9553_length_243_cov_0.905882_g9462_i0	PRJNA1132896	9553	243	0.905882	2.20129326	Leukarachnion sp. ATCC PRA-24	568390	SAR_Eukaryotes	SAR_Eukaryotes	182	2.68e-41	NTclustered	gi\|2727570083\|gb\|PP760457.1\|	568390	g9462	i0	84.293	3.97942386831276	191	25	77	4	57	243	2284	2473	Leukarachnion sp. ATCC PRA-24 culture ATCC:BJ-24B2 mitochondrion, complete genome	blastn	967	182	1	Eukaryota	Sar						Leukarachnion sp. ATCC PRA-24
16860793	16860793	PRJNA1132896_P_NODE_154_length_1294_cov_4.026208_g116_i0	PRJNA1132896	154	1294	4.026208	52.09913152	Stramenopile sp. ex Nuclearia delicatula CCAP1552/1	289359	SAR_Eukaryotes	SAR_Eukaryotes	2224	0	NTclustered	gi\|53829555\|gb\|AY582830.1\|	289359	g116	i0	99.753	89.9080370942813	1213	3	94	0	82	1294	1238	26	Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds	blastn	116341	2224	1	Eukaryota	Sar						Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
18135429	18135429	PRJNA1132896_P_NODE_8115_length_247_cov_0.885057_g8024_i0	PRJNA1132896	8115	247	0.885057	2.18609079	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	424	4.1099999999999996e-114	NTclustered	gi\|662862630\|gb\|KJ000270.1\|	151077	g8024	i0	97.571	3.88259109311741	247	6	100	0	1	247	414	168	Chilodonella uncinata strain ATCC PRA-256 clone P7 protein kinase domain containing protein gene, partial cds; macronuclear	blastn	959	424	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
18883318	18883318	PRJNA1132896_P_NODE_2115_length_373_cov_1.733333_g2024_i0	PRJNA1132896	2115	373	1.733333	6.46533209	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	689	0	NTclustered	gi\|323690576\|gb\|GU935635.1\|	88167	g2024	i0	100	74.9436997319035	373	0	100	0	1	373	145	517	Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence	blastn	27954	689	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae	Poterioochromonas	Poterioochromonas malhamensis
21960415	21960415	PRJNA1132896_P_NODE_5238_length_271_cov_1.863636_g5147_i0	PRJNA1132896	5238	271	1.863636	5.05045356	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|118399045\|ref\|XM_001031849.1\|	312017	g5147	i0	100	0.107011070110701	29	0	11	0	174	202	2034	2006	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
21960417	21960417	PRJNA1132896_P_NODE_5418_length_268_cov_3.025641_g5327_i0	PRJNA1132896	5418	268	3.025641	8.10871788	Chrysolepidomonas dendrolepidota	64707	SAR_Eukaryotes	SAR_Eukaryotes	285	2.22e-72	NTclustered	gi\|16326553\|gb\|AF409121.1\|	64707	g5327	i0	88.655	40.5186567164179	238	21	87	6	35	268	3926	3691	Chrysolepidomonas dendrolepidota internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	10859	285	1	Eukaryota	Sar		Chrysophyceae	Chromulinales	Chrysolepidomonadaceae	Chrysolepidomonas	Chrysolepidomonas dendrolepidota

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