metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1111082" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1111082" 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
1021211	1021211	PRJNA1111082_P_NODE_3681_length_403_cov_1.569697_g3636_i0	PRJNA1111082	3681	403	1.569697	6.32587891	Poterioochromonas	88166	SAR_Eukaryotes	SAR_Eukaryotes	745	0	NTclustered	gi\|323690576\|gb\|GU935635.1\|	88167	g3636	i0	100	100.096774193548	403	0	100	0	1	403	1327	1729	Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence	blastn	40339	745	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae	Poterioochromonas	Poterioochromonas malhamensis
1490008	1490008	PRJNA1111082_P_NODE_2702_length_462_cov_1.326478_g2657_i0	PRJNA1111082	2702	462	1.326478	6.12832836	Globisporangium ultimum	2052682	SAR_Eukaryotes	SAR_Eukaryotes	110	2.62e-19	NTclustered	gi\|299830435\|ref\|NC_014280.1\|	2052682	g2657	i0	76.526	28.3484848484848	213	42	45	5	97	305	16031	16239	Pythium ultimum mitochondrion, complete genome	blastn	13097	110	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium ultimum
3571860	3571860	PRJNA1111082_P_NODE_83_length_1499_cov_5.345021_g71_i0	PRJNA1111082	83	1499	5.345021	80.12186479	Blastocystis	12967	SAR_Eukaryotes	SAR_Eukaryotes	248	1.83e-60	NTclustered	gi\|156617365\|gb\|EF494738.1\|	463135	g71	i0	76.827	31.2675116744496	479	87	31	18	716	1180	4252	3784	Blastocystis sp. BT-1 tRNA-Asn, tRNA-Leu, tRNA-Met, and tRNA-Asp genes, complete sequence; NADH dehydrogenase subunit 3 (nad3) gene, complete cds; tRNA-Met and tRNA-Pro genes, complete sequence; NADH dehydrogenase subunit 6 (nad6) gene, complete cds; small subunit ribosomal RNA and tRNA-Met genes, complete sequence; and large subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	46870	248	1	Eukaryota	Sar		Bigyra	Opalinata	Blastocystidae	Blastocystis	Blastocystis sp. BT-1
7868022	7868022	PRJNA1111082_P_NODE_12847_length_236_cov_2.355828_g12802_i0	PRJNA1111082	12847	236	2.355828	5.55975408	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	87.9	5.8e-13	NTclustered	gi\|145515744\|ref\|XM_001443735.1\|	5888	g12802	i0	100	0.199152542372881	47	0	20	0	161	207	674	628	Paramecium tetraurelia uncharacterized protein (GSPATT00011949001), partial mRNA	blastn	47	87.9	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
7868124	7868124	PRJNA1111082_P_NODE_4847_length_357_cov_13.845070_g4802_i0	PRJNA1111082	4847	357	13.84507	49.4268999	Amorphochlora amoebiformis	1561963	SAR_Eukaryotes	SAR_Eukaryotes	73.1	2.59e-8	NTclustered	gi\|893150443\|dbj\|AB996604.1\|	1561963	g4802	i0	80.18	14.9159663865546	111	10	30	11	250	357	766	867	Amorphochlora amoebiformis nucleomorph DNA, chromosome: 3, complete sequence, strain: CCMP2058	blastn	5325	73.1	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Amorphochlora	Amorphochlora amoebiformis
14244134	14244134	PRJNA1111082_P_NODE_1872_length_535_cov_12.852814_g1827_i0	PRJNA1111082	1872	535	12.852814	68.7625549	Hematodinium sp.	173654	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.004	NTclustered	gi\|357196844\|emb\|HE610736.1\|	173654	g1827	i0	100	0.0560747663551402	30	0	6	0	506	535	31	2	Hematodinium sp. mitochondrial partial small subunit ribosomal RNA (ssu rRNA gene), clone 16	blastn	30	56.5	1	Eukaryota	Sar		Dinophyceae	Syndiniales	Syndiniaceae	Hematodinium	Hematodinium sp.
14244310	14244310	PRJNA1111082_P_NODE_8192_length_283_cov_1.523810_g8147_i0	PRJNA1111082	8192	283	1.52381	4.3123823	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	523	4.5999999999999983e-144	NTclustered	gi\|10782\|emb\|X54004.1\|	5908	g8147	i0	100	84.9010600706714	283	0	100	0	1	283	1924	1642	Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA	blastn	24027	523	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
15518084	15518084	PRJNA1111082_P_NODE_8573_length_277_cov_2.161765_g8528_i0	PRJNA1111082	8573	277	2.161765	5.98808905	Poterioochromonas malhamensis	88167	SAR_Eukaryotes	SAR_Eukaryotes	403	6.11e-108	NTclustered	gi\|2088238071\|ref\|NC_056910.1\|	88167	g8528	i0	100	55.5379061371841	218	0	100	0	60	277	16014	15797	Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome	blastn	15384	403	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae	Poterioochromonas	Poterioochromonas malhamensis
20147632	20147632	PRJNA1111082_P_NODE_7376_length_297_cov_2.285714_g7331_i0	PRJNA1111082	7376	297	2.285714	6.78857058	root	1	Root_unresolved	Root_unresolved	521	1.7499999999999996e-143	NTclustered	gi\|10782\|emb\|X54004.1\|	5908	g7331	i0	98.322	61.9225589225589	298	4	100	1	1	297	2736	2439	Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA	blastn	18391	521	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
20616463	20616463	PRJNA1111082_P_NODE_237_length_1095_cov_3.184932_g211_i0	PRJNA1111082	237	1095	3.184932	34.8750054	Guinardia delicatula	1244696	SAR_Eukaryotes	SAR_Eukaryotes	244	1.7100000000000004e-59	NTclustered	gi\|2074156200\|gb\|MW413905.1\|	216802	g211	i0	72.698	40.6283105022831	945	180	82	51	106	1003	23689	24602	Guinardia delicatula mitochondrion, complete genome	blastn	44488	244	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Rhizosoleniales	Rhizosoleniaceae	Guinardia	Guinardia delicatula
21892235	21892235	PRJNA1111082_P_NODE_678_length_777_cov_22.312500_g636_i0	PRJNA1111082	678	777	22.3125	173.368125	Diplophrys sp. ATCC_50360	138669	SAR_Eukaryotes	SAR_Eukaryotes	1363	0	NTclustered	gi\|10732805\|gb\|AF304465.1\|AF304465	138669	g636	i0	98.335	49.1570141570142	781	6	100	4	1	777	1505	728	Diplophrys sp. ATCC_50360 small subunit ribosomal RNA gene, complete sequence	blastn	38195	1363	1	Eukaryota	Sar		Bigyra	Amphitremida		Diplophrys	Diplophrys sp. ATCC_50360
24441115	24441115	PRJNA1111082_P_NODE_10120_length_255_cov_2.142857_g10075_i0	PRJNA1111082	10120	255	2.142857	5.46428535	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	472	1.5e-128	NTclustered	gi\|11466252\|ref\|NC_000862.1\|	5908	g10075	i0	100	19.7960784313725	255	0	100	0	1	255	2036	2290	Tetrahymena pyriformis mitochondrion, complete genome	blastn	5048	472	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis

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