metadata: contig_metadata: 11 rows where bioproject = "PRJNA1123309" and tax

11 rows where bioproject = "PRJNA1123309" 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
3579452	3579452	PRJNA1123309_P_NODE_10163_length_473_cov_3.190000_g9787_i0	PRJNA1123309	10163	473	3.19	15.0887	Deinococcus	1298	Bacteria	Bacteria	669	0	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g9787	i0	92.194	211.701902748414	474	35	99	2	1	472	1814584	1815057	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	100135	671	0.997019374068554	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
4856974	4856974	PRJNA1123309_P_NODE_30164_length_296_cov_1.600897_g29784_i0	PRJNA1123309	30164	296	1.600897	4.73865512	Deinococcus	1298	Bacteria	Bacteria	398	3.059999999999999e-106	NTclustered	gi\|1823316025\|gb\|CP050119.1\|	1299	g29784	i0	92.171	21.3918918918919	281	22	95	0	3	283	5339	5059	Deinococcus radiodurans strain BNK-50 plasmid pCP1, complete sequence	blastn	6332	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
6656043	6656043	PRJNA1123309_P_NODE_24646_length_323_cov_4.892000_g24266_i0	PRJNA1123309	24646	323	4.892	15.80116	Deinococcus radiophilus	32062	Bacteria	Bacteria	529	1.1499999999999999e-145	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g24266	i0	98.658	276.767801857585	298	4	92	0	16	313	1813859	1813562	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	89396	529	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
13031968	13031968	PRJNA1123309_P_NODE_37031_length_278_cov_1.195122_g36651_i0	PRJNA1123309	37031	278	1.195122	3.32243916	Deinococcus deserti	310783	Bacteria	Bacteria	99	3.24e-16	NTclustered	gi\|226316800\|gb\|CP001114.1\|	546414	g36651	i0	87.209	9.66187050359712	86	11	31	0	186	271	714549	714634	Deinococcus deserti VCD115, complete genome	blastn	2686	99	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
15581059	15581059	PRJNA1123309_P_NODE_28213_length_305_cov_1.926724_g27833_i0	PRJNA1123309	28213	305	1.926724	5.8765082	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	398	3.169999999999999e-106	NTclustered	gi\|2905214251\|gb\|CP179946.1\|	3385567	g27833	i0	91.126	27.8360655737705	293	26	96	0	13	305	252928	252636	Deinococcus sp. VB343 chromosome 2, complete sequence	blastn	8490	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
22706002	22706002	PRJNA1123309_P_NODE_60858_length_245_cov_0.906977_g60478_i0	PRJNA1123309	60858	245	0.906977	2.22209365	Thermus	270	Bacteria	Bacteria	444	3.12e-120	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g60478	i0	100	1.95918367346939	240	0	98	0	2	241	1677439	1677678	Thermus scotoductus SA-01, complete genome	blastn	480	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
27470337	27470337	PRJNA1123309_P_NODE_49583_length_252_cov_0.871508_g49203_i0	PRJNA1123309	49583	252	0.871508	2.19620016	Bacteria	2	Bacteria	Bacteria	125	1.2099999999999999e-32	NR	WP_183984741.1	521158	g49203	i0	71.1	8.89285714285714	83	24	98.8	0	251	3	128	210	WP_183984741.1 glycosyltransferase [Deinobacterium chartae]	diamond	2241	126	0.992063492063492	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinobacterium	Deinobacterium chartae
29901538	29901538	PRJNA1123309_P_NODE_41611_length_266_cov_2.248705_g41231_i0	PRJNA1123309	41611	266	2.248705	5.9815553	root	1	Root_unresolved	Root_unresolved	94.7	4.23e-22	NR	MDO4264703.1	47478	g41231	i0	58.8	1.81578947368421	80	30	86.8	2	34	264	2	81	MDO4264703.1 NAD(P)H-dependent oxidoreductase [Deinococcus sp.]	diamond	483	95.5	0.991623036649215	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
31524052	31524052	PRJNA1123309_P_NODE_63296_length_244_cov_0.912281_g62916_i0	PRJNA1123309	63296	244	0.912281	2.22596564	Deinococcus piscis	394230	Bacteria	Bacteria	156	1.33e-45	NR	GHG08658.1	394230	g62916	i0	96.1	0.94672131147541	77	3	94.7	0	9	239	104	180	GHG08658.1 hypothetical protein GCM10017783_21530 [Deinococcus piscis]	diamond	231	156	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus piscis
32030151	32030151	PRJNA1123309_P_NODE_30458_length_295_cov_1.166667_g30078_i0	PRJNA1123309	30458	295	1.166667	3.44166765	Deinococcus sp.	47478	Bacteria	Bacteria	153	3.0699999999999992e-43	NR	WP_291427152.1	47478	g30078	i0	81.9	3.80338983050847	94	17	95.6	0	294	13	191	284	WP_291427152.1 transposase, partial [Deinococcus sp.]	diamond	1122	153	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
32145833	32145833	PRJNA1123309_P_NODE_16298_length_385_cov_1.105769_g15919_i0	PRJNA1123309	16298	385	1.105769	4.25721065	Bacteria	2	Bacteria	Bacteria	70.9	8.35e-13	NR	TYB95644.1	1955248	g15919	i0	45.7	1.70649350649351	70	37	54.5	1	22	231	54	122	TYB95644.1 MAG: glycine cleavage system protein GcvH [Kosmotoga sp.]	diamond	657	71.6	0.990223463687151	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Kosmotoga	Kosmotoga 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);;