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

11 rows where bioproject = "PRJNA688931" 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
2453325	2453325	PRJNA688931_P_NODE_15422_length_262_cov_4.244131_g15209_i0	PRJNA688931	15422	262	4.244131	11.11962322	Deinococcus	1298	Bacteria	Bacteria	411	3.419999999999999e-110	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g15209	i0	95.367	262.095419847328	259	11	100	1	1	259	1454023	1454280	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	68669	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
2453351	2453351	PRJNA688931_P_NODE_29022_length_189_cov_1.042857_g28809_i0	PRJNA688931	29022	189	1.042857	1.97099973	Deinococcus	1298	Bacteria	Bacteria	333	5.169999999999999e-87	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g28809	i0	98.413	268.407407407407	189	3	100	0	1	189	423047	422859	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	50729	333	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
4496682	4496682	PRJNA688931_P_NODE_4784_length_510_cov_1.711497_g4572_i0	PRJNA688931	4784	510	1.711497	8.7286347	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	680	0	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g4572	i0	91.142	732.617647058824	508	35	99	7	1	506	1637546	1638045	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	373635	680	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
5006396	5006396	PRJNA688931_P_NODE_27324_length_195_cov_1.404110_g27111_i0	PRJNA688931	27324	195	1.40411	2.7380145	Fervidobacterium	2422	Bacteria	Bacteria	355	1.15e-93	NTclustered	gi\|444439378\|ref\|NR_074093.1\|	2424	g27111	i0	99.487	109.979487179487	195	1	100	0	1	195	650	844	Fervidobacterium nodosum strain Rt17-B1 16S ribosomal RNA, partial sequence	blastn	21446	355	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
13422384	13422384	PRJNA688931_P_NODE_25351_length_203_cov_1.292208_g25138_i0	PRJNA688931	25351	203	1.292208	2.62318224	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	178	2.8e-40	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g25138	i0	82.775	202.068965517241	209	26	100	10	1	203	544584	544788	Deinococcus sp. NW-56 chromosome, complete genome	blastn	41020	178	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
14697365	14697365	PRJNA688931_P_NODE_18372_length_239_cov_1.689474_g18159_i0	PRJNA688931	18372	239	1.689474	4.03784286	Deinococcus metallilatus	1211322	Bacteria	Bacteria	291	4.18e-74	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g18159	i0	91.163	275.924686192469	215	18	90	1	25	239	329263	329476	Deinococcus metallilatus strain MA1002 chromosome	blastn	65946	291	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
14697493	14697493	PRJNA688931_P_NODE_33932_length_172_cov_2.089431_g33719_i0	PRJNA688931	33932	172	2.089431	3.59382132	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	307	2.79e-79	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g33719	i0	98.837	271.052325581395	172	2	100	0	1	172	1637335	1637164	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	46621	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
17755961	17755961	PRJNA688931_P_NODE_35154_length_169_cov_1.016667_g34941_i0	PRJNA688931	35154	169	1.016667	1.71816723	Deinococcus	1298	Bacteria	Bacteria	274	2.7699999999999997e-69	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g34941	i0	95.858	204.668639053254	169	7	100	0	1	169	73136	73304	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	34589	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
24894611	24894611	PRJNA688931_P_NODE_18920_length_235_cov_3.537634_g18707_i0	PRJNA688931	18920	235	3.537634	8.3134399	Deinococcus metallilatus	1211322	Bacteria	Bacteria	342	1.12e-89	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g18707	i0	94.977	170.753191489362	219	10	93	1	17	235	329519	329736	Deinococcus metallilatus strain MA1002 chromosome	blastn	40127	342	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
27966605	27966605	PRJNA688931_P_NODE_17525_length_245_cov_1.806122_g17312_i0	PRJNA688931	17525	245	1.806122	4.4249989	Kosmotoga sp.	1955248	Bacteria	Bacteria	70.5	3.19e-13	NR	TYB88804.1	1955248	g17312	i0	52.6	2.26530612244898	57	27	69.8	0	243	73	75	131	TYB88804.1 MAG: MaoC family dehydratase [Kosmotoga sp.]	diamond	555	70.5	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Kosmotoga	Kosmotoga sp.
29967519	29967519	PRJNA688931_P_NODE_10531_length_325_cov_1.293478_g10318_i0	PRJNA688931	10531	325	1.293478	4.2038035	Deinococcus	1298	Bacteria	Bacteria	135	3.38e-36	NR	WP_027463593.1	317577	g10318	i0	69.6	8.34461538461538	102	28	94.2	1	308	3	1	99	WP_027463593.1 malate dehydrogenase [Deinococcus ficus]	diamond	2712	135	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus

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