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

16 rows where bioproject = "PRJNA1067443" 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
1456055	1456055	PRJNA1067443_P_NODE_15122_length_256_cov_1.912568_g15104_i0	PRJNA1067443	15122	256	1.912568	4.89617408	Deinococcus aquaticus	328692	Bacteria	Bacteria	342	1.2299999999999997e-89	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g15104	i0	90.769	19.71484375	260	19	100	5	1	256	916853	916595	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	5047	342	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
1456202	1456202	PRJNA1067443_P_NODE_22382_length_241_cov_1.571429_g22364_i0	PRJNA1067443	22382	241	1.571429	3.78714389	Deinococcus radiodurans	1299	Bacteria	Bacteria	91.7	2.24e-19	NR	WP_034349876.1	1299	g22364	i0	71.6	2.00414937759336	81	16	99.6	3	2	241	523	597	WP_034349876.1 excinuclease ABC subunit UvrA [Deinococcus radiodurans]	diamond	483	91.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
2731847	2731847	PRJNA1067443_P_NODE_123_length_1043_cov_12.976289_g114_i0	PRJNA1067443	123	1043	12.976289	135.34269427	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	1604	0	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g114	i0	98.994	44.9664429530201	895	9	100	0	149	1043	500011	499117	Thermus sp. NEB1569 chromosome, complete genome	blastn	46900	1604	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
8666588	8666588	PRJNA1067443_P_NODE_11327_length_277_cov_1.813725_g11309_i0	PRJNA1067443	11327	277	1.813725	5.02401825	Deinococcus	1298	Bacteria	Bacteria	379	1.03e-100	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g11309	i0	91.606	3.5884476534296	274	23	100	0	1	274	128715	128988	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	994	379	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
12935481	12935481	PRJNA1067443_P_NODE_8831_length_294_cov_8.063348_g8813_i0	PRJNA1067443	8831	294	8.063348	23.70624312	Deinococcus geothermalis	68909	Bacteria	Bacteria	492	1.36e-134	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g8813	i0	98.909	0.935374149659864	275	3	94	0	20	294	2129760	2129486	Deinococcus geothermalis DSM 11300, complete genome	blastn	275	492	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
14210179	14210179	PRJNA1067443_P_NODE_19452_length_246_cov_0.890173_g19434_i0	PRJNA1067443	19452	246	0.890173	2.18982558	Deinococcus	1298	Bacteria	Bacteria	107	1.3500000000000002e-26	NR	MDO4264464.1	47478	g19434	i0	83.3	3.59756097560976	60	10	73.2	0	245	66	167	226	MDO4264464.1 bifunctional DNA-formamidopyrimidine glycosylase/DNA-(apurinic or apyrimidinic site) lyase [Deinococcus sp.]	diamond	885	107	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
15484180	15484180	PRJNA1067443_P_NODE_18413_length_248_cov_0.880000_g18395_i0	PRJNA1067443	18413	248	0.88	2.1824	Deinococcus aetherius	200252	Bacteria	Bacteria	300	7.26e-77	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g18395	i0	91.743	4.08064516129032	218	15	88	1	31	248	1345694	1345480	Deinococcus aetherius ST0316 DNA, complete genome	blastn	1012	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
21415414	21415414	PRJNA1067443_P_NODE_14917_length_257_cov_2.059783_g14899_i0	PRJNA1067443	14917	257	2.059783	5.29364231	Thermus	270	Bacteria	Bacteria	320	5.8e-83	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g14899	i0	89.105	12	257	28	100	0	1	257	695477	695221	Thermus thermophilus TF27 DNA, complete genome	blastn	3084	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
21858327	21858327	PRJNA1067443_P_NODE_21258_length_243_cov_0.905882_g21240_i0	PRJNA1067443	21258	243	0.905882	2.20129326	Deinococcus aetherius	200252	Bacteria	Bacteria	359	1.15e-94	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g21240	i0	93.388	82.6707818930041	242	16	99	0	2	243	2371366	2371607	Deinococcus aetherius ST0316 DNA, complete genome	blastn	20089	359	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
27161848	27161848	PRJNA1067443_P_NODE_15842_length_253_cov_1.655556_g15824_i0	PRJNA1067443	15842	253	1.655556	4.18855668	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	140	1.2e-36	NR	WP_353543144.1	457454	g15824	i0	78.6	1.99209486166008	84	18	99.6	0	253	2	509	592	WP_353543144.1 CRISPR-associated helicase Cas3' [Deinococcus xinjiangensis]	diamond	504	140	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
27825508	27825508	PRJNA1067443_P_NODE_9284_length_290_cov_1.341014_g9266_i0	PRJNA1067443	9284	290	1.341014	3.8889406	Deinococcus proteolyticus	55148	Bacteria	Bacteria	121	5.73e-31	NR	WP_013623081.1	55148	g9266	i0	77.1	1.69655172413793	83	19	85.9	0	38	286	167	249	WP_013623081.1 1-phosphofructokinase [Deinococcus proteolyticus]	diamond	492	121	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
28835736	28835736	PRJNA1067443_P_NODE_18508_length_247_cov_3.856322_g18490_i0	PRJNA1067443	18508	247	3.856322	9.52511534	Deinococcus sp. 12RED42	2745872	Bacteria	Bacteria	89.4	1.72e-19	NR	WP_230288396.1	2745872	g18490	i0	86.3	1.31174089068826	51	7	61.9	0	153	1	6	56	WP_230288396.1 GNAT family N-acetyltransferase, partial [Deinococcus sp. 12RED42]	diamond	324	89.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. 12RED42
30004192	30004192	PRJNA1067443_P_NODE_9531_length_288_cov_1.813953_g9513_i0	PRJNA1067443	9531	288	1.813953	5.22418464	Deinococcus sp.	47478	Bacteria	Bacteria	157	3.5699999999999995e-47	NR	WP_303101259.1	47478	g9513	i0	83.3	2	96	16	100	0	288	1	32	127	WP_303101259.1 type II toxin-antitoxin system VapC family toxin [Deinococcus sp.]	diamond	576	157	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
31268001	31268001	PRJNA1067443_P_NODE_12155_length_272_cov_2.175879_g12137_i0	PRJNA1067443	12155	272	2.175879	5.91839088	Deinococcus navajonensis	309884	Bacteria	Bacteria	146	4.22e-40	NR	WP_380038373.1	309884	g12137	i0	77.8	0.992647058823529	90	20	99.3	0	270	1	211	300	WP_380038373.1 phage terminase large subunit [Deinococcus navajonensis]	diamond	270	146	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus navajonensis
32438730	32438730	PRJNA1067443_P_NODE_3059_length_414_cov_4.181818_g3041_i0	PRJNA1067443	3059	414	4.181818	17.31272652	Thermus sp.	275	Bacteria	Bacteria	149	1.42e-39	NR	WP_370533049.1	275	g3041	i0	87.7	0.528985507246377	73	9	52.9	0	412	194	91	163	WP_370533049.1 FGGY-family carbohydrate kinase [Thermus sp.]	diamond	219	149	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
32816900	32816900	PRJNA1067443_P_NODE_19300_length_246_cov_1.387283_g19282_i0	PRJNA1067443	19300	246	1.387283	3.41271618	Deinococcus lacus	392561	Bacteria	Bacteria	93.2	3.66e-20	NR	WP_380083922.1	392561	g19282	i0	74.2	0.75609756097561	62	16	75.6	0	190	5	79	140	WP_380083922.1 serine protease [Deinococcus lacus]	diamond	186	93.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus lacus

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