metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA773778" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA773778" and tax_phylum = "Thermotogota"

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
750857	750857	PRJNA773778_S_NODE_19801_length_330_cov_1.980545_g19651_i0	PRJNA773778	19801	330	1.980545	6.5357985	Mesotoga infera	1236046	Bacteria	Bacteria	425	1.59e-114	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g19651	i0	91.139	18.5151515151515	316	25	95	3	17	330	2163724	2163410	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	6110	425	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
2027098	2027098	PRJNA773778_S_NODE_32602_length_274_cov_1.149254_g32452_i0	PRJNA773778	32602	274	1.149254	3.14895596	Mesotoga infera	1236046	Bacteria	Bacteria	296	1.05e-75	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g32452	i0	86.397	1.99270072992701	272	36	99	1	1	272	253911	254181	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	546	296	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
3302608	3302608	PRJNA773778_S_NODE_46583_length_243_cov_0.905882_g46433_i0	PRJNA773778	46583	243	0.905882	2.20129326	Mesotoga infera	1236046	Bacteria	Bacteria	263	9.3e-66	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g46433	i0	92.105	0.781893004115226	190	9	76	3	59	243	946741	946929	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	190	263	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
4579221	4579221	PRJNA773778_S_NODE_26764_length_296_cov_1.026906_g26614_i0	PRJNA773778	26764	296	1.026906	3.03964176	Mesotoga infera	1236046	Bacteria	Bacteria	254	7.02e-63	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g26614	i0	82.373	1.88175675675676	295	49	99	3	3	296	312152	311860	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	557	254	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
5854732	5854732	PRJNA773778_S_NODE_32565_length_274_cov_1.184080_g32415_i0	PRJNA773778	32565	274	1.18408	3.2443792	Mesotoga infera	1236046	Bacteria	Bacteria	143	1.45e-29	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g32415	i0	77.154	0.974452554744526	267	47	95	12	1	260	1736620	1736879	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	267	143	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
8404109	8404109	PRJNA773778_S_NODE_2127_length_730_cov_1.211568_g1994_i0	PRJNA773778	2127	730	1.211568	8.8444464	Mesotoga infera	1236046	Bacteria	Bacteria	780	0	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g1994	i0	86.027	1.64520547945205	730	98	99	4	3	730	1855705	1856432	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	1201	780	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
8404680	8404680	PRJNA773778_S_NODE_45747_length_244_cov_1.122807_g45597_i0	PRJNA773778	45747	244	1.1228070000000001	2.73964908	Mesotoga infera	1236046	Bacteria	Bacteria	152	2.11e-32	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g45597	i0	89.831	0.983606557377049	118	12	50	0	126	243	1931067	1930950	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	240	152	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
8404686	8404686	PRJNA773778_S_NODE_46007_length_244_cov_0.900585_g45857_i0	PRJNA773778	46007	244	0.900585	2.1974274	Mesotoga infera	1236046	Bacteria	Bacteria	241	4.38e-59	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g45857	i0	84.836	1	244	31	100	4	1	244	1935325	1935562	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	244	241	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
8404712	8404712	PRJNA773778_S_NODE_47347_length_242_cov_1.147929_g47197_i0	PRJNA773778	47347	242	1.147929	2.77798818	Mesotoga infera	1236046	Bacteria	Bacteria	311	3.26e-80	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g47197	i0	94.527	18.7809917355372	201	11	83	0	1	201	1062269	1062469	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	4545	311	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
9679226	9679226	PRJNA773778_S_NODE_12568_length_394_cov_2.034268_g12418_i0	PRJNA773778	12568	394	2.034268	8.01501592	Mesotoga infera	1236046	Bacteria	Bacteria	508	1.86e-139	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g12418	i0	97.324	12.6522842639594	299	8	77	0	94	392	134666	134368	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	4985	508	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
10955016	10955016	PRJNA773778_S_NODE_20249_length_327_cov_18.637795_g20099_i0	PRJNA773778	20249	327	18.637795	60.94558965	Mesotoga infera	1236046	Bacteria	Bacteria	346	1.26e-90	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g20099	i0	85.928	3.0519877675841	334	36	100	10	1	327	2701843	2702172	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	998	346	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
10955401	10955401	PRJNA773778_S_NODE_36869_length_260_cov_2.208556_g36719_i0	PRJNA773778	36869	260	2.208556	5.7422456	Mesotoga infera	1236046	Bacteria	Bacteria	156	1.76e-33	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g36719	i0	77.606	0.996153846153846	259	56	99	2	1	258	1854546	1854289	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	259	156	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
10955527	10955527	PRJNA773778_S_NODE_41669_length_249_cov_1.420455_g41519_i0	PRJNA773778	41669	249	1.420455	3.53693295	Mesotoga infera	1236046	Bacteria	Bacteria	217	7.55e-52	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g41519	i0	82.661	0.995983935742972	248	39	99	4	1	246	1930931	1930686	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	248	217	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
13504657	13504657	PRJNA773778_S_NODE_20131_length_328_cov_2.050980_g19981_i0	PRJNA773778	20131	328	2.05098	6.7272144	Mesotoga prima	1184387	Bacteria	Bacteria	335	2.7399999999999993e-87	NTclustered	gi\|387857666\|gb\|CP003532.1\|	660470	g19981	i0	90.8	1.15548780487805	250	23	76	0	1	250	2784102	2783853	Mesotoga prima MesG1.Ag.4.2, complete genome	blastn	379	335	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga prima
17329737	17329737	PRJNA773778_S_NODE_4434_length_574_cov_1.083832_g4286_i0	PRJNA773778	4434	574	1.083832	6.22119568	Mesotoga infera	1236046	Bacteria	Bacteria	915	0	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g4286	i0	95.462	1.96515679442509	573	26	100	0	2	574	1948574	1949146	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	1128	915	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
18602686	18602686	PRJNA773778_S_NODE_21295_length_322_cov_0.867470_g21145_i0	PRJNA773778	21295	322	0.86747	2.7932534	Mesotoga infera	1236046	Bacteria	Bacteria	407	5.6e-109	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g21145	i0	89.474	2.52795031055901	323	32	100	2	1	322	1814909	1815230	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	814	407	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
19877687	19877687	PRJNA773778_S_NODE_19756_length_330_cov_8.575875_g19606_i0	PRJNA773778	19756	330	8.575875	28.3003875	Mesotoga infera	1236046	Bacteria	Bacteria	593	4.119999999999999e-165	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g19606	i0	99.091	3	330	3	100	0	1	330	2702172	2701843	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	990	593	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera

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