metadata: contig_metadata: 15 rows where bioproject = "PRJNA1095825" and tax

15 rows where bioproject = "PRJNA1095825" 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
200718	200718	PRJNA1095825_P_NODE_253101_length_248_cov_0.988571_g250038_i0	PRJNA1095825	253101	248	0.988571	2.45165608	Deinococcus radiomollis	468916	Bacteria	Bacteria	416	6.9e-112	NTclustered	gi\|2865409981\|gb\|CP129906.1\|	468916	g250038	i0	96.813	228.487903225806	251	5	100	3	1	248	1000946	1001196	Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome	blastn	56665	416	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
2294961	2294961	PRJNA1095825_P_NODE_253362_length_248_cov_0.880000_g250299_i0	PRJNA1095825	253362	248	0.88	2.1824	Deinococcus	1298	Bacteria	Bacteria	407	4.16e-109	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g250299	i0	96.721	21.3508064516129	244	8	98	0	1	244	2295300	2295543	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	5295	407	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
7853716	7853716	PRJNA1095825_P_NODE_276607_length_244_cov_0.900585_g273544_i0	PRJNA1095825	276607	244	0.900585	2.1974274	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	105	2.06e-25	NR	WP_386843102.1	536443	g273544	i0	90.5	1.69672131147541	84	4	98.4	1	242	3	43	126	WP_386843102.1 NUDIX domain-containing protein [Deinococcus taklimakanensis]	diamond	414	105	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
8672649	8672649	PRJNA1095825_P_NODE_204047_length_274_cov_0.950249_g200984_i0	PRJNA1095825	204047	274	0.950249	2.60368226	Deinococcus	1298	Bacteria	Bacteria	484	2.0899999999999994e-132	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g200984	i0	98.54	293.806569343066	274	4	100	0	1	274	879584	879857	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	80503	484	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
11223036	11223036	PRJNA1095825_P_NODE_285629_length_243_cov_0.905882_g282566_i0	PRJNA1095825	285629	243	0.905882	2.20129326	Thermus	270	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2090198728\|gb\|CP082325.1\|	274	g282566	i0	99.588	10	243	1	100	0	1	243	51789	51547	Thermus thermophilus strain N-1 plasmid unnamed2, complete sequence	blastn	2430	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
15047130	15047130	PRJNA1095825_P_NODE_206932_length_271_cov_2.535354_g203869_i0	PRJNA1095825	206932	271	2.535354	6.87080934	Truepera	332248	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g203869	i0	100	0.214022140221402	29	0	11	0	230	258	3108346	3108318	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
15047200	15047200	PRJNA1095825_P_NODE_241812_length_250_cov_0.870056_g238749_i0	PRJNA1095825	241812	250	0.870056	2.17514	Thermus	270	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g238749	i0	99.2	48.684	250	2	100	0	1	250	487378	487129	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	12171	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
16778772	16778772	PRJNA1095825_P_NODE_71434_length_448_cov_1.402667_g68371_i0	PRJNA1095825	71434	448	1.402667	6.28394816	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	726	0	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g68371	i0	95.982	212.247767857143	448	16	99	2	1	447	1507971	1508417	Deinococcus sp. QL22 chromosome, complete genome	blastn	95087	726	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
20602856	20602856	PRJNA1095825_P_NODE_80517_length_422_cov_1.338109_g77454_i0	PRJNA1095825	80517	422	1.338109	5.64681998	Deinococcus puniceus	1182568	Bacteria	Bacteria	623	6.869999999999999e-174	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g77454	i0	93.396	252.144549763033	424	23	100	5	1	422	70898	71318	Deinococcus puniceus strain DY1, complete genome	blastn	106405	623	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
27564246	27564246	PRJNA1095825_P_NODE_169104_length_300_cov_1.356828_g166041_i0	PRJNA1095825	169104	300	1.356828	4.070484	Deinococcus	1298	Bacteria	Bacteria	108	8.89e-26	NR	WP_295816647.1	158789	g166041	i0	50.9	5.26	106	45	99	2	298	2	211	316	WP_295816647.1 alpha/beta hydrolase [uncultured Deinococcus sp.]	diamond	1578	108	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
27983549	27983549	PRJNA1095825_P_NODE_209205_length_270_cov_1.233503_g206142_i0	PRJNA1095825	209205	270	1.233503	3.3304581	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	158	1.1e-42	NR	WP_104989975.1	2080419	g206142	i0	80	2	90	18	100	0	1	270	350	439	WP_104989975.1 EcoAI/FtnUII family type I restriction enzme subunit R [Deinococcus sp. NW-56]	diamond	540	158	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
28962644	28962644	PRJNA1095825_P_NODE_221348_length_261_cov_1.638298_g218285_i0	PRJNA1095825	221348	261	1.638298	4.27595778	Deinococcota bacterium	1913990	Bacteria	Bacteria	113	7.32e-30	NR	NBC95014.1	1913990	g218285	i0	62.5	0.919540229885057	80	30	92	0	240	1	1	80	NBC95014.1 DUF4065 domain-containing protein [Deinococcota bacterium]	diamond	240	113	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
29435707	29435707	PRJNA1095825_P_NODE_274530_length_245_cov_0.895349_g271467_i0	PRJNA1095825	274530	245	0.895349	2.19360505	Deinococcus sp. Leaf326	1736338	Bacteria	Bacteria	155	6.089999999999998e-42	NR	WP_056299193.1	1736338	g271467	i0	93.8	0.991836734693878	81	5	99.2	0	244	2	196	276	WP_056299193.1 VirB4 family type IV secretion system protein [Deinococcus sp. Leaf326]	diamond	243	155	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. Leaf326
30667921	30667921	PRJNA1095825_P_NODE_276833_length_244_cov_0.900585_g273770_i0	PRJNA1095825	276833	244	0.900585	2.1974274	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	162	1.02e-46	NR	WP_386842847.1	536443	g273770	i0	100	0.995901639344262	81	0	99.6	0	244	2	244	324	WP_386842847.1 3-dehydroquinate synthase [Deinococcus taklimakanensis]	diamond	243	162	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
30699419	30699419	PRJNA1095825_P_NODE_192394_length_282_cov_1.287081_g189331_i0	PRJNA1095825	192394	282	1.287081	3.62956842	Synergistales bacterium	2268201	Bacteria	Bacteria	79.3	7.15e-15	NR	MFA0889601.1	2268201	g189331	i0	66.7	1.81914893617021	57	19	60.6	0	171	1	1	57	MFA0889601.1 glycine/sarcosine/betaine reductase component B subunit [Synergistales bacterium]	diamond	513	79.3	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium

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