metadata: contig_metadata: 18 rows where bioproject = "PRJNA1016321", tax_phylum = "Aquificota" and tax

18 rows where bioproject = "PRJNA1016321", tax_phylum = "Aquificota" and tax_superkingdom = "Bacteria"

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
159993	159993	PRJNA1016321_P_NODE_56921_length_235_cov_4.370370_g56690_i0	PRJNA1016321	56921	235	4.37037	10.2703695	Aquificota bacterium	2202151	Bacteria	Bacteria	372	1.42e-98	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g56690	i0	97.696	0.923404255319149	217	4	92	1	1	216	1580479	1580263	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	217	372	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
160017	160017	PRJNA1016321_P_NODE_6661_length_792_cov_7.343533_g6464_i0	PRJNA1016321	6661	792	7.343533	58.16078136	Aquificota bacterium	2202151	Bacteria	Bacteria	1380	0	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g6464	i0	98.837	0.977272727272727	774	9	98	0	19	792	775207	774434	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	774	1380	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
5262929	5262929	PRJNA1016321_P_NODE_57885_length_210_cov_6.474453_g57654_i0	PRJNA1016321	57885	210	6.474453	13.5963513	Aquificota bacterium	2202151	Bacteria	Bacteria	318	1.6499999999999995e-82	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g57654	i0	96.842	0.904761904761905	190	6	90	0	1	190	1203639	1203828	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	190	318	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
6538065	6538065	PRJNA1016321_P_NODE_47666_length_251_cov_1.297753_g47435_i0	PRJNA1016321	47666	251	1.297753	3.25736003	Aquificota bacterium	2202151	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g47435	i0	100	1	251	0	100	0	1	251	309872	310122	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	251	464	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
7812447	7812447	PRJNA1016321_P_NODE_49747_length_249_cov_0.875000_g49516_i0	PRJNA1016321	49747	249	0.875	2.17875	Aquificota bacterium	2202151	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g49516	i0	99.598	2	249	1	100	0	1	249	864946	864698	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	498	455	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
9087561	9087561	PRJNA1016321_P_NODE_55688_length_241_cov_3.857143_g55457_i0	PRJNA1016321	55688	241	3.857143	9.29571463	Pampinifervens florentissimum	1632019	Bacteria	Bacteria	315	2.51e-81	NTclustered	gi\|1812217338\|gb\|CP048795.1\|	1632019	g55457	i0	98.864	0.983402489626556	176	2	95	0	13	188	783621	783446	Hydrogenobacter sp. T-8 chromosome	blastn	237	315	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Aquificaceae	Pampinifervens	Pampinifervens florentissimum
10363233	10363233	PRJNA1016321_P_NODE_57489_length_228_cov_3.006452_g57258_i0	PRJNA1016321	57489	228	3.006452	6.85471056	Sulfurihydrogenibium azorense	309806	Bacteria	Bacteria	154	5.42e-33	NTclustered	gi\|225643049\|gb\|CP001229.1\|	204536	g57258	i0	98.837	8.5219298245614	86	1	38	0	143	228	1003993	1003908	Sulfurihydrogenibium azorense Az-Fu1, complete genome	blastn	1943	154	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Hydrogenothermaceae	Sulfurihydrogenibium	Sulfurihydrogenibium azorense
14188049	14188049	PRJNA1016321_P_NODE_27692_length_349_cov_1.496377_g27461_i0	PRJNA1016321	27692	349	1.496377	5.22235573	Aquificota bacterium	2202151	Bacteria	Bacteria	442	1.6699999999999993e-119	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g27461	i0	100	1.50429799426934	239	0	95	0	111	349	1363498	1363736	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	525	442	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
15462073	15462073	PRJNA1016321_P_NODE_24153_length_379_cov_2.529412_g23922_i0	PRJNA1016321	24153	379	2.529412	9.58647148	Aquificota bacterium	2202151	Bacteria	Bacteria	243	2e-59	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g23922	i0	99.254	0.353562005277045	134	1	35	0	3	136	703308	703175	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	134	243	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
15462733	15462733	PRJNA1016321_P_NODE_57233_length_232_cov_2.094340_g57002_i0	PRJNA1016321	57233	232	2.09434	4.8588688	Aquificota bacterium	2202151	Bacteria	Bacteria	418	1.7799999999999995e-112	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g57002	i0	99.138	1	232	2	100	0	1	232	593436	593205	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	232	418	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
16736735	16736735	PRJNA1016321_P_NODE_46454_length_255_cov_1.637363_g46223_i0	PRJNA1016321	46454	255	1.637363	4.17527565	Aquificota bacterium	2202151	Bacteria	Bacteria	466	6.98e-127	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g46223	i0	99.608	1.9843137254902	255	1	100	0	1	255	1262117	1261863	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	506	466	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
16736951	16736951	PRJNA1016321_P_NODE_57454_length_229_cov_2.250000_g57223_i0	PRJNA1016321	57454	229	2.25	5.1525	Aquificota bacterium	2202151	Bacteria	Bacteria	418	1.7499999999999995e-112	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g57223	i0	99.563	1.96506550218341	229	1	100	0	1	229	602812	602584	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	450	418	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
18011124	18011124	PRJNA1016321_P_NODE_22015_length_402_cov_3.404255_g21784_i0	PRJNA1016321	22015	402	3.404255	13.6851051	Pampinifervens florentissimum	1632019	Bacteria	Bacteria	686	0	NTclustered	gi\|1812217338\|gb\|CP048795.1\|	1632019	g21784	i0	98.711	0.965174129353234	388	2	96	1	1	385	808442	808055	Hydrogenobacter sp. T-8 chromosome	blastn	388	686	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Aquificaceae	Pampinifervens	Pampinifervens florentissimum
18011522	18011522	PRJNA1016321_P_NODE_43115_length_267_cov_2.288660_g42884_i0	PRJNA1016321	43115	267	2.28866	6.1107222	Aquificota bacterium	2202151	Bacteria	Bacteria	488	1.5699999999999998e-133	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g42884	i0	99.625	1	267	1	100	0	1	267	677336	677070	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	267	488	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
18011589	18011589	PRJNA1016321_P_NODE_46335_length_255_cov_2.697802_g46104_i0	PRJNA1016321	46335	255	2.697802	6.8793951	Aquificota bacterium	2202151	Bacteria	Bacteria	429	9.159999999999999e-116	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g46104	i0	99.574	0.92156862745098	235	1	92	0	1	235	1057511	1057745	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	235	429	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
19284952	19284952	PRJNA1016321_P_NODE_18916_length_442_cov_3.539295_g18686_i0	PRJNA1016321	18916	442	3.539295	15.6436839	Aquificota bacterium	2202151	Bacteria	Bacteria	763	0	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g18686	i0	97.959	24.183257918552	441	8	99	1	2	442	360343	360782	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	10689	763	1	Bacteria	Pseudomonadati	Aquificota					Aquificota bacterium
23111500	23111500	PRJNA1016321_P_NODE_16079_length_487_cov_4.746377_g15849_i0	PRJNA1016321	16079	487	4.746377	23.11485599	Pampinifervens florentissimum	1632019	Bacteria	Bacteria	686	0	NTclustered	gi\|1812217338\|gb\|CP048795.1\|	1632019	g15849	i0	95.581	0.975359342915811	430	15	97	2	17	442	817148	817577	Hydrogenobacter sp. T-8 chromosome	blastn	475	686	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Aquificaceae	Pampinifervens	Pampinifervens florentissimum
29813653	29813653	PRJNA1016321_P_NODE_43931_length_264_cov_3.308901_g43700_i0	PRJNA1016321	43931	264	3.308901	8.73549864	Sulfurihydrogenibium sp.	2053621	Bacteria	Bacteria	139	6.74e-38	NR	MBX0310550.1	2053621	g43700	i0	94.4	0.818181818181818	72	4	81.8	0	218	3	207	278	MBX0310550.1 hypothetical protein [Sulfurihydrogenibium sp.]	diamond	216	139	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Hydrogenothermaceae	Sulfurihydrogenibium	Sulfurihydrogenibium sp.

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