metadata: contig_metadata: 17 rows where bioproject = "PRJNA540466" and tax

17 rows where bioproject = "PRJNA540466" 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_genus	tax_species
3058918	3058918	PRJNA540466_S_NODE_3423_length_746_cov_541.435364_g3079_i0	PRJNA540466	3423	746	541.435364	4039.10781544	Balneolaceae bacterium	2053516	Bacteria	Bacteria	169	7.109999999999999e-37	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g3079	i0	93.86	25.3471849865952	114	4	15	3	1	113	2108	2219	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	18909	169	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
3059203	3059203	PRJNA540466_S_NODE_6903_length_609_cov_483.518657_g6435_i0	PRJNA540466	6903	609	483.518657	2944.62862113	Balneolaceae bacterium	2053516	Bacteria	Bacteria	130	2.71e-25	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g6435	i0	96.25	30.264367816092	80	1	13	2	7	84	2140	2219	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	18431	130	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
5611715	5611715	PRJNA540466_S_NODE_2625_length_800_cov_201.709766_g2322_i0	PRJNA540466	2625	800	201.709766	1613.678128	Balneolaceae bacterium	2053516	Bacteria	Bacteria	169	7.64e-37	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g2322	i0	93.86	23.63625	114	4	14	3	688	800	2219	2108	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	18909	169	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
5611893	5611893	PRJNA540466_S_NODE_445_length_1248_cov_150.863830_g377_i0	PRJNA540466	445	1248	150.86383	1882.7805984	Balneolaceae bacterium	2053516	Bacteria	Bacteria	169	1.21e-36	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g377	i0	93.86	15.1514423076923	114	4	9	3	1	113	2108	2219	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	18909	169	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
6885627	6885627	PRJNA540466_S_NODE_29726_length_329_cov_372.859375_g29177_i0	PRJNA540466	29726	329	372.859375	1226.70734375	Balneolaceae bacterium	2053516	Bacteria	Bacteria	169	2.95e-37	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g29177	i0	93.86	107.905775075988	114	4	46	3	1	113	2108	2219	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	35501	169	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
8160595	8160595	PRJNA540466_S_NODE_1347_length_940_cov_98.906574_g1160_i0	PRJNA540466	1347	940	98.906574	929.7217956	Balneolaceae bacterium	2053516	Bacteria	Bacteria	130	4.27e-25	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g1160	i0	96.25	19.3095744680851	80	1	8	2	7	84	2140	2219	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	18151	130	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
9436133	9436133	PRJNA540466_S_NODE_148_length_1638_cov_138.709904_g121_i0	PRJNA540466	148	1638	138.709904	2272.06822752	Balneolaceae bacterium	2053516	Bacteria	Bacteria	169	1.5999999999999998e-36	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g121	i0	93.86	11.543956043956	114	4	7	3	1	113	2108	2219	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	18909	169	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
11321555	11321555	PRJNA540466_S_NODE_61389_length_244_cov_61.830409_g60840_i0	PRJNA540466	61389	244	61.830409	150.86619796	FCB group	1783270	Bacteria	Bacteria	97.1	1e-15	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g60840	i0	98.214	74.2745901639344	56	0	23	1	189	244	2219	2165	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	18123	97.1	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
11986695	11986695	PRJNA540466_S_NODE_27810_length_339_cov_537.770677_g27261_i0	PRJNA540466	27810	339	537.770677	1823.04259503	Balneolaceae bacterium	2053516	Bacteria	Bacteria	169	3.05e-37	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g27261	i0	93.86	104.675516224189	114	4	44	3	1	113	2108	2219	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	35485	169	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
13261781	13261781	PRJNA540466_S_NODE_29931_length_328_cov_903.054902_g29382_i0	PRJNA540466	29931	328	903.054902	2962.02007856	Balneolaceae bacterium	2053516	Bacteria	Bacteria	169	2.9399999999999996e-37	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g29382	i0	93.86	117.920731707317	114	4	47	3	216	328	2219	2108	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	38678	169	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
13261798	13261798	PRJNA540466_S_NODE_31891_length_319_cov_592.451220_g31342_i0	PRJNA540466	31891	319	592.45122	1889.9193918	Balneolaceae bacterium	2053516	Bacteria	Bacteria	130	1.3399999999999999e-25	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g31342	i0	96.25	106.956112852665	80	1	35	2	236	313	2219	2140	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	34119	130	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
14536702	14536702	PRJNA540466_S_NODE_20912_length_387_cov_256.270701_g20363_i0	PRJNA540466	20912	387	256.270701	991.76761287	Balneolaceae bacterium	2053516	Bacteria	Bacteria	130	1.66e-25	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g20363	i0	96.25	90.9793281653747	80	1	30	2	7	84	2140	2219	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	35209	130	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
17085529	17085529	PRJNA540466_S_NODE_38234_length_295_cov_663.045045_g37685_i0	PRJNA540466	38234	295	663.045045	1955.98288275	Balneolaceae bacterium	2053516	Bacteria	Bacteria	169	2.6099999999999996e-37	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g37685	i0	93.86	64.4779661016949	114	4	38	3	183	295	2219	2108	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	19021	169	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
19634107	19634107	PRJNA540466_S_NODE_34616_length_308_cov_503.753191_g34067_i0	PRJNA540466	34616	308	503.753191	1551.55982828	Balneolaceae bacterium	2053516	Bacteria	Bacteria	130	1.29e-25	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g34067	i0	96.25	111.649350649351	80	1	37	2	225	302	2219	2140	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	34388	130	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
19634238	19634238	PRJNA540466_S_NODE_4896_length_677_cov_250.312914_g4487_i0	PRJNA540466	4896	677	250.312914	1694.61842778	Balneolaceae bacterium	2053516	Bacteria	Bacteria	169	6.419999999999999e-37	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g4487	i0	93.86	27.930576070901	114	4	17	3	1	113	2108	2219	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	18909	169	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
24734267	24734267	PRJNA540466_S_NODE_7620_length_589_cov_278.711240_g7138_i0	PRJNA540466	7620	589	278.71124	1641.6092036	Balneolaceae bacterium	2053516	Bacteria	Bacteria	169	5.54e-37	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g7138	i0	93.86	32.1035653650255	114	4	19	3	477	589	2219	2108	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	18909	169	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
30331095	30331095	PRJNA540466_S_NODE_48312_length_268_cov_1.328205_g47763_i0	PRJNA540466	48312	268	1.328205	3.5595894	Fodinibius salicampi	1920655	Bacteria	Bacteria	46.2	0.00297	NR	WP_265787698.1	1920655	g47763	i0	48.8	0.973880597014925	41	21	45.9	0	169	47	34	74	WP_265787698.1 D-arabinono-1,4-lactone oxidase [Fodinibius salicampi]	diamond	261	46.2	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salicampi

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