metadata: contig_metadata: 16 rows where bioproject = "PRJNA1195374" and tax

16 rows where bioproject = "PRJNA1195374" and tax_kingdom = "Thermotogati"

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
1596195	1596195	PRJNA1195374_P_NODE_38762_length_360_cov_0.972125_g38418_i0	PRJNA1195374	38762	360	0.972125	3.49965	Deinococcus ficus	317577	Bacteria	Bacteria	590	5.849999999999998e-164	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g38418	i0	98.225	362.561111111111	338	4	94	2	2	338	2341734	2342070	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	130522	590	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
6699280	6699280	PRJNA1195374_P_NODE_32626_length_395_cov_1.434783_g32282_i0	PRJNA1195374	32626	395	1.434783	5.66739285	Deinococcus metallilatus	1211322	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g32282	i0	100	0.0708860759493671	28	0	7	0	81	108	2220095	2220068	Deinococcus metallilatus strain MA1002 chromosome	blastn	28	52.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
8695991	8695991	PRJNA1195374_P_NODE_8407_length_754_cov_1.602056_g8099_i0	PRJNA1195374	8407	754	1.602056	12.07950224	Deinococcus	1298	Bacteria	Bacteria	56.5	0.006	NTclustered	gi\|1735477873\|gb\|CP031501.1\|	1299	g8099	i0	100	0.635278514588859	30	0	4	0	209	238	236605	236576	Deinococcus radiodurans strain R1 dM1 chromosome II, complete sequence	blastn	479	56.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
9971033	9971033	PRJNA1195374_P_NODE_6888_length_818_cov_2.464430_g6592_i0	PRJNA1195374	6888	818	2.46443	20.1590374	root	1	Root_unresolved	Root_unresolved	299	1.37e-98	NR	WP_291426924.1	47478	g6592	i0	64.9	23.6772616136919	248	86	90.6	1	40	780	5	252	WP_291426924.1 3-hydroxyacyl-CoA dehydrogenase [Deinococcus sp.]	diamond	19368	301	0.993355481727575	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
10525044	10525044	PRJNA1195374_P_NODE_27909_length_429_cov_2.323034_g27565_i0	PRJNA1195374	27909	429	2.323034	9.96581586	Thermus oshimai	56957	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2894814231\|gb\|CP178485.1\|	56957	g27565	i0	97.059	0.144522144522145	34	0	8	1	127	159	750517	750484	Thermus oshimai strain Blanco chromosome, complete genome	blastn	62	56.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
19448286	19448286	PRJNA1195374_P_NODE_74696_length_248_cov_1.760000_g74352_i0	PRJNA1195374	74696	248	1.76	4.3648	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	174	4.59e-39	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g74352	i0	81.481	59.6572580645161	216	36	86	4	18	231	2204291	2204078	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	14795	174	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
20169226	20169226	PRJNA1195374_P_NODE_7756_length_780_cov_1.521924_g7450_i0	PRJNA1195374	7756	780	1.521924	11.8710072	Bacteria	2	Bacteria	Bacteria	295	3.93e-97	NR	WP_303102018.1	47478	g7450	i0	65	41.3346153846154	243	84	93.1	1	3	728	10	252	WP_303102018.1 3-hydroxyacyl-CoA dehydrogenase [Deinococcus sp.]	diamond	32241	295	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
21444733	21444733	PRJNA1195374_P_NODE_51657_length_305_cov_1.099138_g51313_i0	PRJNA1195374	51657	305	1.099138	3.3523709	Deinococcus	1298	Bacteria	Bacteria	553	6.39e-153	NTclustered	gi\|1219686863\|gb\|MF524660.1\|	47478	g51313	i0	99.344	103.373770491803	305	2	100	0	1	305	75	379	Deinococcus sp. strain MadaFrogSkinBac.DB-.3438 16S ribosomal RNA gene, partial sequence	blastn	31529	553	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
23994915	23994915	PRJNA1195374_P_NODE_51279_length_306_cov_1.622318_g50935_i0	PRJNA1195374	51279	306	1.622318	4.96429308	Bacteria	2	Bacteria	Bacteria	174	3.36e-48	NR	1TAQ_A	271	g50935	i0	98.9	2.73529411764706	93	1	91.2	0	306	28	740	832	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	837	174	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
23994984	23994984	PRJNA1195374_P_NODE_59699_length_281_cov_0.826923_g59355_i0	PRJNA1195374	59699	281	0.826923	2.32365363	Thermus	270	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g59355	i0	100	0.298932384341637	28	0	10	0	71	98	2011805	2011832	Thermus scotoductus SA-01, complete genome	blastn	84	52.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
26711278	26711278	PRJNA1195374_P_NODE_69261_length_255_cov_1.269231_g68917_i0	PRJNA1195374	69261	255	1.269231	3.23653905	root	1	Root_unresolved	Root_unresolved	161	5.65e-44	NR	1TAQ_A	271	g68917	i0	97.6	3.95294117647059	84	2	98.8	0	2	253	465	548	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1008	161	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
27312916	27312916	PRJNA1195374_P_NODE_60543_length_278_cov_1.502439_g60199_i0	PRJNA1195374	60543	278	1.502439	4.17678042	root	1	Root_unresolved	Root_unresolved	177	1.72e-49	NR	1TAQ_A	271	g60199	i0	100	5.9568345323741	92	0	99.3	0	2	277	387	478	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1656	177	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
27483198	27483198	PRJNA1195374_P_NODE_17243_length_545_cov_1.864407_g16901_i0	PRJNA1195374	17243	545	1.864407	10.16101815	Thermosipho melanesiensis	46541	Bacteria	Bacteria	124	4.27e-31	NR	WP_012057074.1	46541	g16901	i0	47.6	9.35229357798165	124	63	68.3	2	170	541	4	125	WP_012057074.1 purine-nucleoside phosphorylase [Thermosipho melanesiensis]	diamond	5097	124	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho melanesiensis
27944306	27944306	PRJNA1195374_P_NODE_65205_length_266_cov_1.196891_g64861_i0	PRJNA1195374	65205	266	1.196891	3.18373006	Bacteria	2	Bacteria	Bacteria	178	7.68e-50	NR	1TAQ_A	271	g64861	i0	100	4.96240601503759	88	0	99.2	0	264	1	615	702	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1320	178	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
30407702	30407702	PRJNA1195374_P_NODE_54233_length_296_cov_0.946188_g53889_i0	PRJNA1195374	54233	296	0.946188	2.80071648	Bacteria	2	Bacteria	Bacteria	73.2	1.44e-12	NR	WP_072757930.1	44754	g53889	i0	46.3	4.48986486486486	95	48	95.3	3	4	285	966	1058	WP_072757930.1 cellobiose phosphorylase [Fervidobacterium gondwanense]	diamond	1329	73.6	0.994565217391304	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
31545290	31545290	PRJNA1195374_P_NODE_43156_length_338_cov_1.947170_g42812_i0	PRJNA1195374	43156	338	1.94717	6.5814346	Bacteria	2	Bacteria	Bacteria	233	8.48e-70	NR	1TAQ_A	271	g42812	i0	100	3.96745562130178	112	0	99.4	0	2	337	100	211	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1341	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus

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