metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA946307" 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
1259978	1259978	PRJNA946307_P_NODE_131401_length_170_cov_1.694215_g130527_i0	PRJNA946307	131401	170	1.694215	2.8801655	Fervidobacterium	2422	Bacteria	Bacteria	285	1.29e-72	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g130527	i0	100	12.7235294117647	154	0	91	0	3	156	812008	812161	Fervidobacterium pennivorans strain DYC, complete genome	blastn	2163	285	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
1260737	1260737	PRJNA946307_P_NODE_6341_length_566_cov_5.077369_g5576_i0	PRJNA946307	6341	566	5.077369	28.73790854	Fervidobacterium	2422	Bacteria	Bacteria	926	0	NTclustered	gi\|444439378\|ref\|NR_074093.1\|	2424	g5576	i0	99.802	97.8780918727915	505	0	89	1	1	505	504	1	Fervidobacterium nodosum strain Rt17-B1 16S ribosomal RNA, partial sequence	blastn	55399	926	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
2536116	2536116	PRJNA946307_P_NODE_26482_length_250_cov_9.029851_g25608_i0	PRJNA946307	26482	250	9.029851	22.5746275	Fervidobacterium	2422	Bacteria	Bacteria	427	3.22e-115	NTclustered	gi\|806984310\|ref\|NG_042008.1\|	2424	g25608	i0	99.573	201.172	234	1	94	0	3	236	256	23	Fervidobacterium nodosum strain Rt17-B1 23S ribosomal RNA gene, complete sequence	blastn	50293	427	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
3478344	3478344	PRJNA946307_P_NODE_63563_length_201_cov_3.263158_g62689_i0	PRJNA946307	63563	201	3.263158	6.55894758	Fervidobacterium pennivorans	93466	Bacteria	Bacteria	263	7.419999999999999e-66	NTclustered	gi\|2793129014\|gb\|CP126982.1\|	3389975	g62689	i0	100	4.93532338308458	142	0	71	0	46	187	1789848	1789707	Fervidobacterium pennivorans subsp. shakshaketiis strain GSH chromosome, complete genome	blastn	992	263	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
3478878	3478878	PRJNA946307_P_NODE_93603_length_187_cov_1.500000_g92729_i0	PRJNA946307	93603	187	1.5	2.805	Fervidobacterium nodosum	2424	Bacteria	Bacteria	298	1.86e-76	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g92729	i0	97.688	1.42245989304813	173	4	93	0	15	187	273462	273634	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	266	298	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
3812725	3812725	PRJNA946307_P_NODE_52783_length_210_cov_2.968944_g51909_i0	PRJNA946307	52783	210	2.968944	6.2347824	Bacteria	2	Bacteria	Bacteria	67.6	6.58e-7	NTclustered	gi\|752579342\|gb\|CP007633.1\|	126738	g51909	i0	93.333	0.642857142857143	45	3	21	0	55	99	555639	555595	Thermotoga sp. RQ7, complete genome	blastn	135	67.6	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga sp. RQ7
7638525	7638525	PRJNA946307_P_NODE_35206_length_222_cov_1.947977_g34332_i0	PRJNA946307	35206	222	1.947977	4.32450894	Bacteria	2	Bacteria	Bacteria	350	6.24e-92	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g34332	i0	98.974	45.8918918918919	195	2	88	0	14	208	291983	291789	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	10188	350	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
8579173	8579173	PRJNA946307_P_NODE_145327_length_166_cov_0.888889_g144453_i0	PRJNA946307	145327	166	0.888889	1.47555574	Fervidobacterium nodosum	2424	Bacteria	Bacteria	281	1.63e-71	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g144453	i0	100	0.91566265060241	152	0	92	0	1	152	1651298	1651147	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	152	281	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
13681728	13681728	PRJNA946307_P_NODE_86891_length_190_cov_1.432624_g86017_i0	PRJNA946307	86891	190	1.432624	2.7219856	Fervidobacterium nodosum	2424	Bacteria	Bacteria	315	1.89e-81	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g86017	i0	98.864	28.3473684210526	176	2	93	0	14	189	981202	981377	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	5386	315	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
16562882	16562882	PRJNA946307_P_NODE_1873_length_1045_cov_6.090361_g1494_i0	PRJNA946307	1873	1045	6.090361	63.64427245	Fervidobacterium	2422	Bacteria	Bacteria	1864	0	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g1494	i0	99.32	156.603827751196	1030	7	99	0	2	1031	1281752	1282781	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	163651	1881	0.990962254120149	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
17504582	17504582	PRJNA946307_P_NODE_147774_length_165_cov_1.931034_g146900_i0	PRJNA946307	147774	165	1.931034	3.1862061	Fervidobacterium nodosum	2424	Bacteria	Bacteria	274	2.7e-69	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g146900	i0	100	0.896969696969697	148	0	90	0	18	165	111445	111592	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	148	274	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
20052171	20052171	PRJNA946307_P_NODE_104736_length_182_cov_1.473684_g103862_i0	PRJNA946307	104736	182	1.473684	2.68210488	Fervidobacterium nodosum	2424	Bacteria	Bacteria	261	2.36e-65	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g103862	i0	94.643	0.923076923076923	168	9	92	0	15	182	650	817	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	168	261	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
20386042	20386042	PRJNA946307_P_NODE_10436_length_415_cov_10.196721_g9584_i0	PRJNA946307	10436	415	10.196721	42.31639215	Fervidobacterium	2422	Bacteria	Bacteria	725	0	NTclustered	gi\|444439378\|ref\|NR_074093.1\|	2424	g9584	i0	99.497	106.315662650602	398	2	96	0	15	412	494	891	Fervidobacterium nodosum strain Rt17-B1 16S ribosomal RNA, partial sequence	blastn	44121	725	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
21328584	21328584	PRJNA946307_P_NODE_157197_length_163_cov_1.403509_g156323_i0	PRJNA946307	157197	163	1.403509	2.28771967	Fervidobacterium nodosum	2424	Bacteria	Bacteria	272	9.58e-69	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g156323	i0	99.333	0.920245398773006	150	1	92	0	1	150	906047	906196	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	150	272	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
22602896	22602896	PRJNA946307_P_NODE_117298_length_176_cov_2.322835_g116424_i0	PRJNA946307	117298	176	2.322835	4.0881896	Fervidobacterium ngatamarikiense	3389972	Bacteria	Bacteria	300	4.8e-77	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g116424	i0	100	2.14772727272727	162	0	92	0	1	162	100784	100945	Fervidobacterium pennivorans strain DYC, complete genome	blastn	378	300	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
22938369	22938369	PRJNA946307_P_NODE_46158_length_210_cov_4.602484_g45284_i0	PRJNA946307	46158	210	4.602484	9.6652164	Bacteria	2	Bacteria	Bacteria	185	1.74e-42	NTclustered	gi\|160359135\|gb\|CP000879.1\|	403833	g45284	i0	100	24.8619047619048	100	0	90	0	1	100	465902	465803	Petrotoga mobilis SJ95, complete genome	blastn	5221	185	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga mobilis
23878817	23878817	PRJNA946307_P_NODE_141339_length_167_cov_0.881356_g140465_i0	PRJNA946307	141339	167	0.881356	1.47186452	Fervidobacterium nodosum	2424	Bacteria	Bacteria	279	5.9e-71	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g140465	i0	99.351	1.34730538922156	154	1	92	0	14	167	1855760	1855607	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	225	279	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
24211962	24211962	PRJNA946307_P_NODE_19819_length_287_cov_6.256303_g18947_i0	PRJNA946307	19819	287	6.256303	17.95558961	Fervidobacterium	2422	Bacteria	Bacteria	492	1.32e-134	NTclustered	gi\|444439378\|ref\|NR_074093.1\|	2424	g18947	i0	99.63	102.829268292683	270	0	94	1	15	283	1058	1327	Fervidobacterium nodosum strain Rt17-B1 16S ribosomal RNA, partial sequence	blastn	29512	492	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
24212290	24212290	PRJNA946307_P_NODE_4939_length_653_cov_6.874172_g4251_i0	PRJNA946307	4939	653	6.874172	44.88834316	Fervidobacterium	2422	Bacteria	Bacteria	1125	0	NTclustered	gi\|806984310\|ref\|NG_042008.1\|	2424	g4251	i0	98.289	226.430321592649	643	9	98	2	1	642	908	267	Fervidobacterium nodosum strain Rt17-B1 23S ribosomal RNA gene, complete sequence	blastn	147859	1125	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
24212307	24212307	PRJNA946307_P_NODE_51739_length_210_cov_3.291925_g50865_i0	PRJNA946307	51739	210	3.291925	6.9130425	Fervidobacterium	2422	Bacteria	Bacteria	159	1.0599999999999999e-34	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g50865	i0	98.889	45.8333333333333	90	0	90	1	11	100	294663	294575	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	9625	159	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
25487230	25487230	PRJNA946307_P_NODE_4800_length_663_cov_6.726384_g4124_i0	PRJNA946307	4800	663	6.726384	44.59592592	Fervidobacterium	2422	Bacteria	Bacteria	743	0	NTclustered	gi\|806984310\|ref\|NG_042008.1\|	2424	g4124	i0	92.336	278.015082956259	535	22	79	16	1	525	3347	3872	Fervidobacterium nodosum strain Rt17-B1 23S ribosomal RNA gene, complete sequence	blastn	184324	743	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
25487261	25487261	PRJNA946307_P_NODE_52000_length_210_cov_3.242236_g51126_i0	PRJNA946307	52000	210	3.242236	6.8086956	Bacteria	2	Bacteria	Bacteria	185	1.74e-42	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g51126	i0	100	7.08571428571429	100	0	89	0	1	100	782589	782688	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	1488	185	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans

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