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

17 rows where analysis = "blastn", bioproject = "PRJNA1120203" 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
1027978	1027978	PRJNA1120203_P_NODE_59521_length_291_cov_2.830275_g58505_i0	PRJNA1120203	59521	291	2.830275	8.23610025	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	496	1.04e-135	NTclustered	gi\|23504780\|emb\|AJ506007.1\|	204812	g58505	i0	98.921	91.8281786941581	278	2	95	1	3	279	434	711	Uncultured rhizosphere cercozoan partial 18S rRNA gene, clone RSC-CHU-27	blastn	26722	501	0.99001996007984	Eukaryota	Sar	Cercozoa					uncultured rhizosphere cercozoan
2303162	2303162	PRJNA1120203_P_NODE_47342_length_328_cov_9.917647_g46326_i0	PRJNA1120203	47342	328	9.917647	32.52988216	Tribonematales	2978	SAR_Eukaryotes	SAR_Eukaryotes	272	2.1799999999999993e-68	NTclustered	gi\|1591446687\|gb\|MK005105.1\|	303373	g46326	i0	98.693	163.490853658537	153	2	93	0	164	316	257	409	Tribonema affine isolate S2F4-16 23S ribosomal RNA gene, partial sequence; chloroplast	blastn	53625	272	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Tribonemataceae	Tribonema	Tribonema affine
4855645	4855645	PRJNA1120203_P_NODE_31024_length_422_cov_1385.481375_g30009_i0	PRJNA1120203	31024	422	1385.481375	5846.7314025	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	732	0	NTclustered	gi\|1419234739\|dbj\|AP018511.1\|	303400	g30009	i0	99.02	159.419431279621	408	4	97	0	13	420	848	1255	Nitzschia palea NIES-2729 chloroplast DNA complet genome	blastn	67275	732	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia palea
7405667	7405667	PRJNA1120203_P_NODE_47626_length_327_cov_14.496063_g46610_i0	PRJNA1120203	47626	327	14.496063	47.40212601	Tribonematales	2978	SAR_Eukaryotes	SAR_Eukaryotes	272	2.17e-68	NTclustered	gi\|1591446687\|gb\|MK005105.1\|	303373	g46610	i0	98.693	163.966360856269	153	2	93	0	13	165	409	257	Tribonema affine isolate S2F4-16 23S ribosomal RNA gene, partial sequence; chloroplast	blastn	53617	272	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Tribonemataceae	Tribonema	Tribonema affine
7928064	7928064	PRJNA1120203_P_NODE_61647_length_287_cov_0.953271_g60631_i0	PRJNA1120203	61647	287	0.953271	2.73588777	uncultured Cercozoa	175275	SAR_Eukaryotes	SAR_Eukaryotes	442	1.3499999999999993e-119	NTclustered	gi\|1002343650\|gb\|KU738528.1\|	175275	g60631	i0	96.324	91.7909407665505	272	5	95	2	3	274	38	304	Uncultured Cercozoa clone OTU_835 18S ribosomal RNA gene, partial sequence	blastn	26344	442	1	Eukaryota	Sar	Cercozoa					uncultured Cercozoa
10478860	10478860	PRJNA1120203_P_NODE_66189_length_276_cov_3.798030_g65173_i0	PRJNA1120203	66189	276	3.79803	10.4825628	Chromulina sp. SAG 17.97	984084	SAR_Eukaryotes	SAR_Eukaryotes	233	8.439999999999999e-57	NTclustered	gi\|859809677\|gb\|KM590766.1\|	984084	g65173	i0	94.667	96.8405797101449	150	8	95	0	3	152	2008	2157	Chromulina sp. SAG 17.97 23S ribosomal RNA gene, partial sequence; plastid	blastn	26728	233	1	Eukaryota	Sar		Chrysophyceae	Chromulinales	Chromulinaceae	Chromulina	Chromulina sp. SAG 17.97
11231348	11231348	PRJNA1120203_P_NODE_70749_length_266_cov_9.896373_g69733_i0	PRJNA1120203	70749	266	9.896373	26.32435218	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	449	7.38e-122	NTclustered	gi\|113926796\|emb\|AM114804.1\|	175275	g69733	i0	98.81	94.781954887218	252	3	95	0	1	252	638	889	Uncultured cercozoan partial 18S rRNA gene, clone WIM44	blastn	25212	449	1	Eukaryota	Sar	Cercozoa					uncultured Cercozoa
11753207	11753207	PRJNA1120203_P_NODE_29470_length_436_cov_6.721763_g28455_i0	PRJNA1120203	29470	436	6.721763	29.30688668	Lotharella oceanica	641309	SAR_Eukaryotes	SAR_Eukaryotes	69.4	4.18e-7	NTclustered	gi\|1009104511\|ref\|NC_029731.1\|	641309	g28455	i0	76.562	0.357798165137615	128	29	29	1	306	432	22583	22456	Lotharella oceanica strain CCMP622 mitochondrion, complete genome	blastn	156	69.4	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Lotharella	Lotharella oceanica
12506783	12506783	PRJNA1120203_P_NODE_63530_length_282_cov_2.162679_g62514_i0	PRJNA1120203	63530	282	2.162679	6.09875478	Cercomonadidae	45108	SAR_Eukaryotes	SAR_Eukaryotes	481	2.799999999999999e-131	NTclustered	gi\|1002343602\|gb\|KU738480.1\|	175275	g62514	i0	99.248	92.4042553191489	266	2	94	0	3	268	38	303	Uncultured Cercozoa clone OTU_318 18S ribosomal RNA gene, partial sequence	blastn	26058	481	1	Eukaryota	Sar	Cercozoa					uncultured Cercozoa
12506807	12506807	PRJNA1120203_P_NODE_66190_length_276_cov_3.684729_g65174_i0	PRJNA1120203	66190	276	3.684729	10.16985204	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	475	1.2699999999999996e-129	NTclustered	gi\|1617862800\|gb\|MK796081.1\|	90962	g65174	i0	99.615	94.2101449275362	260	1	94	0	15	274	682	423	Cryptosporidium sp. isolate 8 small subunit ribosomal RNA gene, partial sequence	blastn	26002	475	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium sp.
13781277	13781277	PRJNA1120203_P_NODE_66251_length_276_cov_1.783251_g65235_i0	PRJNA1120203	66251	276	1.783251	4.92177276	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	464	2.75e-126	NTclustered	gi\|134021803\|gb\|EF023153.1\|	404735	g65235	i0	98.485	75.4420289855072	264	3	95	1	1	263	618	881	Eimeriidae environmental sample clone Amb_18S_441 18S ribosomal RNA gene, partial sequence	blastn	20822	464	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae		uncultured Eimeriidae
15055327	15055327	PRJNA1120203_P_NODE_31132_length_421_cov_1543.594828_g30117_i0	PRJNA1120203	31132	421	1543.594828	6498.53422588	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	726	0	NTclustered	gi\|299830295\|ref\|NC_014267.1\|	160619	g30117	i0	98.775	159.819477434679	408	5	97	0	14	421	76659	76252	Kryptoperidinium foliaceum chloroplast, complete genome	blastn	67284	732	0.991803278688525	Eukaryota	Sar		Dinophyceae	Peridiniales	Kryptoperidiniaceae	Kryptoperidinium	Kryptoperidinium foliaceum
15055902	15055902	PRJNA1120203_P_NODE_90432_length_247_cov_0.885057_g89416_i0	PRJNA1120203	90432	247	0.885057	2.18609079	root	1	Root_unresolved	Root_unresolved	357	4.22e-94	NTclustered	gi\|833494855\|ref\|XM_012915027.1\|	5866	g89416	i0	93.361	754.983805668016	241	16	98	0	3	243	16	256	Babesia bigemina hypothetical protein, conserved partial mRNA	blastn	186481	357	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
15577786	15577786	PRJNA1120203_P_NODE_47633_length_327_cov_4.413386_g46617_i0	PRJNA1120203	47633	327	4.413386	14.43177222	Mallomonas alpina	1677023	SAR_Eukaryotes	SAR_Eukaryotes	272	2.17e-68	NTclustered	gi\|859810863\|gb\|KM817935.1\|	1677023	g46617	i0	99.333	86.152905198776807	150	1	88	0	176	325	2262	2113	Mallomonas alpina strain Hongseong120107J 23S ribosomal RNA gene, partial sequence; plastid	blastn	28172	272	1	Eukaryota	Sar		Synurophyceae	Synurales	Mallomonadaceae	Mallomonas	Mallomonas alpina
16330121	16330121	PRJNA1120203_P_NODE_31133_length_421_cov_267.784483_g30118_i0	PRJNA1120203	31133	421	267.784483	1127.37267343	Monodopsidaceae	425072	SAR_Eukaryotes	SAR_Eukaryotes	726	0	NTclustered	gi\|613433536\|gb\|KJ410684.1\|	43925	g30118	i0	98.775	123.475059382423	408	5	97	0	12	419	65719	66126	Nannochloropsis oculata strain CCMP525 chloroplast, complete genome	blastn	51983	732	0.991803278688525	Eukaryota	Sar		Eustigmatophyceae	Eustigmatales	Monodopsidaceae	Nannochloropsis	Nannochloropsis oculata
16852442	16852442	PRJNA1120203_P_NODE_63594_length_282_cov_1.564593_g62578_i0	PRJNA1120203	63594	282	1.564593	4.41215226	uncultured Cercozoa	175275	SAR_Eukaryotes	SAR_Eukaryotes	472	1.6799999999999998e-128	NTclustered	gi\|38195286\|gb\|AY360709.1\|	175275	g62578	i0	98.502	90.145390070922	267	4	95	0	3	269	138	404	Uncultured cercozoan clone 10-4Fu05 small subunit ribosomal RNA gene, partial sequence	blastn	25421	472	1	Eukaryota	Sar	Cercozoa					uncultured Cercozoa
24501428	24501428	PRJNA1120203_P_NODE_88060_length_247_cov_1.850575_g87044_i0	PRJNA1120203	88060	247	1.850575	4.57092025	Nitzschia sp. (in: diatoms)	1884248	SAR_Eukaryotes	SAR_Eukaryotes	436	5.279999999999999e-118	NTclustered	gi\|2059554281\|gb\|MZ469822.1\|	1884248	g87044	i0	99.582	150.502024291498	239	1	97	0	9	247	5	243	Nitzschia sp. (in: Bacillariophyta) strain DAD-ALGEUK-94 large subunit ribosomal RNA gene, partial sequence; chloroplast	blastn	37174	436	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia sp. (in: diatoms)

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