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

12 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Chlorobiota"

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
1570200	1570200	PRJNA1148190_P_NODE_433902_length_279_cov_2.242718_g422729_i0	PRJNA1148190	433902	279	2.242718	6.25718322	Chlorobiota bacterium	2268192	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g422729	i0	100	0.100358422939068	28	0	10	0	235	262	779690	779663	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
1574559	1574559	PRJNA1148190_P_NODE_770182_length_242_cov_0.911243_g759009_i0	PRJNA1148190	770182	242	0.911243	2.20520806	Chlorobiota bacterium	2268192	Bacteria	Bacteria	158	4.49e-34	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g759009	i0	79.237	70.6322314049587	236	41	96	8	11	242	4960	5191	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	17093	158	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
2309740	2309740	PRJNA1148190_P_NODE_248862_length_344_cov_1.136531_g237692_i0	PRJNA1148190	248862	344	1.136531	3.90966664	Prosthecochloris	1101	Bacteria	Bacteria	78.7	5.37e-10	NTclustered	gi\|194310671\|gb\|CP001108.1\|	290512	g237692	i0	91.379	1.40116279069767	58	3	16	1	289	344	1560676	1560733	Prosthecochloris aestuarii DSM 271 chromosome, complete genome	blastn	482	78.7	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris aestuarii
2846647	2846647	PRJNA1148190_P_NODE_441643_length_278_cov_1.312195_g430470_i0	PRJNA1148190	441643	278	1.312195	3.6479021	Chlorobium phaeobacteroides	1096	Bacteria	Bacteria	204	6.68e-48	NTclustered	gi\|119353206\|gb\|CP000492.1\|	290317	g430470	i0	82.008	0.859712230215827	239	43	86	0	10	248	326398	326160	Chlorobium phaeobacteroides DSM 266, complete genome	blastn	239	204	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeobacteroides
5398291	5398291	PRJNA1148190_P_NODE_400365_length_286_cov_1.446009_g389192_i0	PRJNA1148190	400365	286	1.446009	4.13558574	Chlorobiota bacterium	2268192	Bacteria	Bacteria	385	2.29e-102	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g389192	i0	90.909	2.20979020979021	286	26	100	0	1	286	2766443	2766728	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	632	385	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
6673705	6673705	PRJNA1148190_P_NODE_449766_length_276_cov_1.842365_g438593_i0	PRJNA1148190	449766	276	1.842365	5.0849274	Chlorobaculum parvum	274539	Bacteria	Bacteria	148	3.1499999999999996e-31	NTclustered	gi\|193085153\|gb\|CP001099.1\|	517417	g438593	i0	83.75	36.3152173913044	160	22	57	4	2	159	222057	221900	Chlorobaculum parvum NCIB 8327, complete genome	blastn	10023	148	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum parvum
7953647	7953647	PRJNA1148190_P_NODE_84687_length_590_cov_1.638298_g73555_i0	PRJNA1148190	84687	590	1.638298	9.6659582	Chlorobiota bacterium	2268192	Bacteria	Bacteria	819	0	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g73555	i0	93.773	3.39152542372881	546	33	92	1	46	590	1263076	1262531	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	2001	819	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
10502351	10502351	PRJNA1148190_P_NODE_653869_length_247_cov_3.034483_g642696_i0	PRJNA1148190	653869	247	3.034483	7.49517301	Chlorobaculum tepidum	1097	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|21672293\|gb\|AE006470.1\|	194439	g642696	i0	96.875	0.129554655870445	32	1	13	0	71	102	937105	937136	Chlorobium tepidum TLS, complete genome	blastn	32	54.7	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum tepidum
14329228	14329228	PRJNA1148190_P_NODE_788192_length_241_cov_0.916667_g777019_i0	PRJNA1148190	788192	241	0.916667	2.20916747	Chlorobaculum limnaeum	274537	Bacteria	Bacteria	115	2.73e-21	NTclustered	gi\|1070918267\|gb\|CP017305.1\|	274537	g777019	i0	82.09	6.50622406639004	134	24	56	0	103	236	2530726	2530593	Chlorobaculum limnaeum strain DSM 1677 chromosome, complete genome	blastn	1568	115	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum limnaeum
18147388	18147388	PRJNA1148190_P_NODE_436195_length_279_cov_1.373786_g425022_i0	PRJNA1148190	436195	279	1.373786	3.83286294	Chlorobiota bacterium	2268192	Bacteria	Bacteria	320	6.38e-83	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g425022	i0	91.739	1.39068100358423	230	19	82	0	3	232	33837	34066	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	388	320	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
19419191	19419191	PRJNA1148190_P_NODE_260516_length_338_cov_1.162264_g249346_i0	PRJNA1148190	260516	338	1.162264	3.92845232	Chlorobiota bacterium	2268192	Bacteria	Bacteria	442	1.6199999999999995e-119	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g249346	i0	90.265	2.40532544378698	339	31	100	2	1	338	2763929	2764266	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	813	442	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
23250168	23250168	PRJNA1148190_P_NODE_60059_length_741_cov_1.488024_g49070_i0	PRJNA1148190	60059	741	1.488024	11.02625784	Chlorobiota bacterium	2268192	Bacteria	Bacteria	863	0	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g49070	i0	87.805	9.04183535762483	738	88	99	2	1	737	1258934	1259670	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	6700	863	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota 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);;