metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax_phylum = "Balneolota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
25588355	25588355	PRJNA737474g_S_NODE_468409_length_234_cov_4144.826087_g467115_i0	PRJNA737474	468409	234	4144.826087	9698.89304358	Balneolaceae bacterium	2053516	Bacteria	Bacteria	76.8	1.24e-9	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g467115	i0	92.593	184.17094017094	54	2	23	2	142	195	2090	2141	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	43096	76.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25716057	25716057	PRJNA737474f_S_NODE_345226_length_220_cov_3.707483_g344548_i0	PRJNA737474	345226	220	3.707483	8.1564626	Balneolaceae bacterium	2053516	Bacteria	Bacteria	82.4	2.48e-11	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g344548	i0	88.406	203.740909090909	69	6	30	2	16	82	2151	2083	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	44823	82.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25767873	25767873	PRJNA737474g_S_NODE_451802_length_238_cov_1266.072727_g450508_i0	PRJNA737474	451802	238	1266.072727	3013.25309026	root	1	Root_unresolved	Root_unresolved	75	4.56e-9	NTclustered	gi\|2166246568\|dbj\|LC663148.1\|	2053516	g450508	i0	97.674	177.546218487395	43	1	18	0	159	201	79	37	Balneolaceae bacterium ARSSAG-00002351 DNA, putative prophage region, clone: 00002351_pp2	blastn	42256	75	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25852181	25852181	PRJNA737474f_S_NODE_366675_length_209_cov_8566.551471_g365997_i0	PRJNA737474	366675	209	8566.551471	17904.09257439	Balneolaceae bacterium	2053516	Bacteria	Bacteria	75	3.91e-9	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g365997	i0	92.453	211.023923444976	53	2	25	1	43	95	2140	2090	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	44104	75	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25860244	25860244	PRJNA737474g_S_NODE_455323_length_237_cov_2630.500000_g454029_i0	PRJNA737474	455323	237	2630.5	6234.285	Balneolaceae bacterium	2053516	Bacteria	Bacteria	84.2	7.54e-12	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g454029	i0	96.078	183.084388185654	51	2	22	0	40	90	2140	2090	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	43391	84.2	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25901032	25901032	PRJNA737474f_S_NODE_148035_length_267_cov_35067.500000_g147357_i0	PRJNA737474	148035	267	35067.5	93630.225	root	1	Root_unresolved	Root_unresolved	75	5.21e-9	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g147357	i0	100	166.104868913858	40	0	15	0	228	267	2101	2140	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	44350	75	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25985001	25985001	PRJNA737474f_S_NODE_115788_length_282_cov_1735.789474_g115110_i0	PRJNA737474	115788	282	1735.789474	4894.92631668	Balneolaceae bacterium	2053516	Bacteria	Bacteria	76.8	1.54e-9	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g115110	i0	92.453	151.641843971631	53	4	19	0	193	245	2090	2142	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	42763	76.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25988092	25988092	PRJNA737474f_S_NODE_333948_length_224_cov_32.370861_g333270_i0	PRJNA737474	333948	224	32.370861	72.51072864	Balneolaceae bacterium	2053516	Bacteria	Bacteria	75	4.25e-9	NTclustered	gi\|2166246688\|dbj\|LC663154.1\|	2053516	g333270	i0	97.674	182.767857142857	43	1	19	0	1	43	10309	10267	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp1	blastn	40940	75	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25990833	25990833	PRJNA737474g_S_NODE_125108_length_309_cov_4988.847458_g123814_i0	PRJNA737474	125108	309	4988.847458	15415.53864522	Balneolaceae bacterium	2053516	Bacteria	Bacteria	73.1	2.21e-8	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g123814	i0	95.652	30.4854368932039	46	0	15	2	47	92	2144	2101	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	9420	73.1	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26122262	26122262	PRJNA737474f_S_NODE_173397_length_258_cov_119.000000_g172719_i0	PRJNA737474	173397	258	119	307.02	Balneolaceae bacterium	2053516	Bacteria	Bacteria	82.4	3e-11	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g172719	i0	96.078	174.751937984496	51	1	19	1	183	232	2091	2141	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	45086	82.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26129670	26129670	PRJNA737474g_S_NODE_247221_length_264_cov_1892.026178_g245927_i0	PRJNA737474	247221	264	1892.026178	4994.94910992	Balneolaceae bacterium	2053516	Bacteria	Bacteria	80.5	1.11e-10	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g245927	i0	96	172.833333333333	50	1	19	1	40	88	2140	2091	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	45628	80.5	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26258871	26258871	PRJNA737474f_S_NODE_197070_length_251_cov_749.382022_g196392_i0	PRJNA737474	197070	251	749.382022	1880.94887522	Balneolaceae bacterium	2053516	Bacteria	Bacteria	78.7	3.75e-10	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g196392	i0	100	179.98406374502	42	0	17	0	36	77	2143	2102	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	45176	78.7	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26259169	26259169	PRJNA737474f_S_NODE_219814_length_248_cov_1103.468571_g219136_i0	PRJNA737474	219814	248	1103.468571	2736.60205608	Balneolaceae bacterium	2053516	Bacteria	Bacteria	75	4.79e-9	NTclustered	gi\|2166246568\|dbj\|LC663148.1\|	2053516	g219136	i0	95.652	169.165322580645	46	2	19	0	35	80	34	79	Balneolaceae bacterium ARSSAG-00002351 DNA, putative prophage region, clone: 00002351_pp2	blastn	41953	75	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26267160	26267160	PRJNA737474g_S_NODE_336174_length_249_cov_1.107955_g334880_i0	PRJNA737474	336174	249	1.107955	2.75880795	Balneolaceae bacterium	2053516	Bacteria	Bacteria	73.1	1.73e-8	NTclustered	gi\|2166246568\|dbj\|LC663148.1\|	2053516	g334880	i0	95.652	170.883534136546	46	1	18	1	181	226	82	38	Balneolaceae bacterium ARSSAG-00002351 DNA, putative prophage region, clone: 00002351_pp2	blastn	42550	73.1	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26404035	26404035	PRJNA737474g_S_NODE_417447_length_242_cov_1604.526627_g416153_i0	PRJNA737474	417447	242	1604.526627	3882.95443734	Balneolaceae bacterium	2053516	Bacteria	Bacteria	76.8	1.29e-9	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g416153	i0	100	187.623966942149	41	0	17	0	164	204	2101	2141	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	45405	76.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26404487	26404487	PRJNA737474g_S_NODE_455583_length_237_cov_1729.463415_g454289_i0	PRJNA737474	455583	237	1729.463415	4098.82829355	Balneolaceae bacterium	2053516	Bacteria	Bacteria	75	4.54e-9	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g454289	i0	100	184.582278481013	40	0	17	0	39	78	2141	2102	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	43746	75	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26529195	26529195	PRJNA737474f_S_NODE_112144_length_284_cov_5040.672986_g111466_i0	PRJNA737474	112144	284	5040.672986	14315.51128024	Balneolaceae bacterium	2053516	Bacteria	Bacteria	78.7	4.33e-10	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g111466	i0	100	303.095070422535	42	0	27	0	39	80	2140	2099	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	86079	78.7	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26531351	26531351	PRJNA737474f_S_NODE_236800_length_246_cov_1.664740_g236122_i0	PRJNA737474	236800	246	1.66474	4.0952604	Balneolaceae bacterium	2053516	Bacteria	Bacteria	67.6	7.94e-7	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g236122	i0	97.436	146.044715447154	39	1	16	0	208	246	2097	2135	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	35927	67.6	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26540132	26540132	PRJNA737474g_S_NODE_408584_length_243_cov_1.117647_g407290_i0	PRJNA737474	408584	243	1.117647	2.71588221	Balneolaceae bacterium	2053516	Bacteria	Bacteria	69.4	2.17e-7	NTclustered	gi\|2166246568\|dbj\|LC663148.1\|	2053516	g407290	i0	97.5	0.444444444444444	40	1	16	0	31	70	39	78	Balneolaceae bacterium ARSSAG-00002351 DNA, putative prophage region, clone: 00002351_pp2	blastn	108	69.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26540993	26540993	PRJNA737474g_S_NODE_494008_length_229_cov_2661.121795_g492714_i0	PRJNA737474	494008	229	2661.121795	6093.96891055	Balneolaceae bacterium	2053516	Bacteria	Bacteria	82.4	2.61e-11	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g492714	i0	100	190.048034934498	44	0	19	0	36	79	2144	2101	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	43521	82.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium

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