metadata: contig_metadata: 20 rows where bioproject = "PRJEB48218" and tax

20 rows where bioproject = "PRJEB48218" and tax_phylum = "Aquificota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1336874	1336874	PRJEB48218_S_NODE_23202_length_185_cov_3.057692_g22240_i0	PRJEB48218	23202	185	3.057692	5.6567302	Aquificota bacterium	2202151	Bacteria	Bacteria	303	3.95e-78	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g22240	i0	98.276	0.940540540540541	174	2	94	1	13	185	1214606	1214433	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	174	303	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
3888600	3888600	PRJEB48218_S_NODE_22944_length_187_cov_2.430380_g21982_i0	PRJEB48218	22944	187	2.43038	4.5448106	Aquificota bacterium	2202151	Bacteria	Bacteria	259	8.79e-65	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g21982	i0	91.892	0.989304812834225	185	15	99	0	3	187	1150807	1150623	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	185	259	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
3888893	3888893	PRJEB48218_S_NODE_7624_length_347_cov_11516.720126_g6662_i0	PRJEB48218	7624	347	11516.720126	39963.01883722	Aquificota bacterium	2202151	Bacteria	Bacteria	414	3.64e-111	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g6662	i0	98.712	229.694524495677	233	3	67	0	115	347	445294	445062	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	79704	414	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
5164870	5164870	PRJEB48218_S_NODE_22745_length_188_cov_3.433962_g21783_i0	PRJEB48218	22745	188	3.433962	6.45584856	Aquificota bacterium	2202151	Bacteria	Bacteria	270	4.09e-68	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g21783	i0	94.35	0.941489361702128	177	9	94	1	1	177	1024082	1024257	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	177	270	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
6440969	6440969	PRJEB48218_S_NODE_8926_length_309_cov_13094.900000_g7964_i0	PRJEB48218	8926	309	13094.9	40463.241	Aquificota bacterium	2202151	Bacteria	Bacteria	342	1.5299999999999999e-89	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g7964	i0	98.953	257.805825242718	191	2	62	0	6	196	1139639	1139449	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	79662	342	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
8989592	8989592	PRJEB48218_S_NODE_20068_length_208_cov_3.877095_g19106_i0	PRJEB48218	20068	208	3.877095	8.0643576	Aquificota bacterium	2202151	Bacteria	Bacteria	340	3.4699999999999996e-89	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g19106	i0	96.172	1.00480769230769	209	7	100	1	1	208	538248	538040	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	209	340	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
8989609	8989609	PRJEB48218_S_NODE_20988_length_201_cov_3.470930_g20026_i0	PRJEB48218	20988	201	3.47093	6.9765693	Aquificota bacterium	2202151	Bacteria	Bacteria	333	5.569999999999999e-87	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g20026	i0	96.985	0.990049751243781	199	5	99	1	4	201	1394559	1394361	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	199	333	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
10265662	10265662	PRJEB48218_S_NODE_8809_length_312_cov_13485.950530_g7847_i0	PRJEB48218	8809	312	13485.95053	42076.1656536	Aquificota bacterium	2202151	Bacteria	Bacteria	324	5.6e-84	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g7847	i0	96.429	255.342948717949	196	7	63	0	2	197	336462	336657	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	79667	324	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
11540755	11540755	PRJEB48218_S_NODE_23250_length_185_cov_2.314103_g22288_i0	PRJEB48218	23250	185	2.314103	4.28109055	Aquificota bacterium	2202151	Bacteria	Bacteria	311	2.36e-80	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g22288	i0	96.791	2.02702702702703	187	4	100	1	1	185	167764	167950	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	375	311	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
11540773	11540773	PRJEB48218_S_NODE_23930_length_180_cov_3.284768_g22968_i0	PRJEB48218	23930	180	3.284768	5.9125824	Aquificota bacterium	2202151	Bacteria	Bacteria	296	6.39e-76	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g22968	i0	96.154	1.01111111111111	182	5	100	1	1	180	656789	656608	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	182	296	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
11540867	11540867	PRJEB48218_S_NODE_29190_length_155_cov_3.182540_g28228_i0	PRJEB48218	29190	155	3.18254	4.932937	Aquificota bacterium	2202151	Bacteria	Bacteria	276	6.95e-70	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g28228	i0	98.71	1.9741935483871	155	2	100	0	1	155	39992	39838	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	306	276	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
15018373	15018373	PRJEB48218_S_NODE_9892_length_289_cov_13852.373077_g8930_i0	PRJEB48218	9892	289	13852.373077	40033.35819253	Hydrogenobacter	939	Bacteria	Bacteria	285	2.4199999999999997e-72	NTclustered	gi\|2049901404\|gb\|CP076323.1\|	940	g8930	i0	98.75	278.318339100346	160	2	55	0	13	172	431141	430982	MAG: Hydrogenobacter thermophilus isolate RBS10-74 chromosome, complete genome	blastn	80434	285	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Aquificaceae	Hydrogenobacter	Hydrogenobacter thermophilus
16639296	16639296	PRJEB48218_S_NODE_20994_length_201_cov_3.203488_g20032_i0	PRJEB48218	20994	201	3.203488	6.43901088	Pampinifervens florentissimum	1632019	Bacteria	Bacteria	219	1.6299999999999999e-52	NTclustered	gi\|1812217338\|gb\|CP048795.1\|	1632019	g20032	i0	86.5	1.91044776119403	200	25	99	2	1	199	1043284	1043482	Hydrogenobacter sp. T-8 chromosome	blastn	384	219	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Aquificaceae	Pampinifervens	Pampinifervens florentissimum
16639379	16639379	PRJEB48218_S_NODE_25494_length_171_cov_3.521127_g24532_i0	PRJEB48218	25494	171	3.521127	6.02112717	Aquificota bacterium	2202151	Bacteria	Bacteria	265	1.69e-66	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g24532	i0	98.658	0.871345029239766	149	2	87	0	20	168	1669639	1669491	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	149	265	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
16639435	16639435	PRJEB48218_S_NODE_28974_length_156_cov_2.661417_g28012_i0	PRJEB48218	28974	156	2.661417	4.15181052	Aquificota bacterium	2202151	Bacteria	Bacteria	268	1.1699999999999997e-67	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g28012	i0	99.324	0.948717948717949	148	1	95	0	1	148	72547	72400	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	148	268	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
16639454	16639454	PRJEB48218_S_NODE_30294_length_151_cov_3.573770_g29332_i0	PRJEB48218	30294	151	3.57377	5.3963927	Aquificota bacterium	2202151	Bacteria	Bacteria	272	8.689999999999998e-69	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g29332	i0	99.333	0.993377483443709	150	1	99	0	1	150	1669514	1669365	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	150	272	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
21739086	21739086	PRJEB48218_S_NODE_13538_length_243_cov_2.943925_g12576_i0	PRJEB48218	13538	243	2.943925	7.15373775	Aquificota bacterium	2202151	Bacteria	Bacteria	366	6.89e-97	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g12576	i0	93.852	1.00411522633745	244	14	100	1	1	243	1021704	1021461	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	244	366	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
21739231	21739231	PRJEB48218_S_NODE_23998_length_180_cov_2.192053_g23036_i0	PRJEB48218	23998	180	2.192053	3.9456954	Aquificota bacterium	2202151	Bacteria	Bacteria	272	1.08e-68	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g23036	i0	94.828	0.966666666666667	174	9	97	0	7	180	77079	76906	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	174	272	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
23014510	23014510	PRJEB48218_S_NODE_23959_length_180_cov_2.748344_g22997_i0	PRJEB48218	23959	180	2.748344	4.9470192	Aquificota bacterium	2202151	Bacteria	Bacteria	320	3.79e-83	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g22997	i0	100	0.961111111111111	173	0	96	0	4	176	465258	465086	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	173	320	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
24288427	24288427	PRJEB48218_S_NODE_2840_length_792_cov_4805.427261_g2125_i0	PRJEB48218	2840	792	4805.427261	38058.98390712	Aquificota bacterium	2202151	Bacteria	Bacteria	1158	0	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g2125	i0	98.773	119.402777777778	652	6	88	2	42	693	972951	972302	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	94567	1158	1	Bacteria	Pseudomonadati	Aquificota					Aquificota 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);;