metadata: contig_metadata: 10 rows where bioproject = "PRJNA431371" and tax

10 rows where bioproject = "PRJNA431371" 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
1088115	1088115	PRJNA431371_P_NODE_9201_length_410_cov_1.121662_g9128_i0	PRJNA431371	9201	410	1.121662	4.5988142	Deinococcus	1298	Bacteria	Bacteria	501	3.25e-137	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g9128	i0	88.835	192.6	412	41	100	5	1	410	1886024	1886432	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	78966	501	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
1702937	1702937	PRJNA431371_P_NODE_16642_length_315_cov_0.950413_g16569_i0	PRJNA431371	16642	315	0.950413	2.99380095	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	520	6.719999999999999e-143	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g16569	i0	99.648	165.222222222222	284	1	100	0	32	315	56955	56672	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	52045	520	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
11906683	11906683	PRJNA431371_P_NODE_1110_length_904_cov_2.256318_g1048_i0	PRJNA431371	1110	904	2.256318	20.39711472	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	1559	0	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g1048	i0	97.792	344.99889380531	906	17	100	3	1	904	1638345	1637441	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	311879	1559	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
12566848	12566848	PRJNA431371_P_NODE_28390_length_248_cov_0.880000_g28317_i0	PRJNA431371	28390	248	0.88	2.1824	Thermus	270	Bacteria	Bacteria	230	9.65e-56	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g28317	i0	97.761	58.6290322580645	134	2	54	1	1	134	2296954	2296822	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	14540	230	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
20829968	20829968	PRJNA431371_P_NODE_2857_length_657_cov_0.922945_g2784_i0	PRJNA431371	2857	657	0.922945	6.06374865	Deinococcus aquaticus	328692	Bacteria	Bacteria	614	6.649999999999999e-171	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g2784	i0	84.308	11.2770167427702	650	78	99	7	8	657	700828	700203	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	7409	614	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
23380501	23380501	PRJNA431371_P_NODE_31179_length_246_cov_0.884393_g31106_i0	PRJNA431371	31179	246	0.884393	2.17560678	Thermus brockianus	56956	Bacteria	Bacteria	265	2.62e-66	NTclustered	gi\|2199615985\|dbj\|AP025593.1\|	56956	g31106	i0	94.253	34.9349593495935	174	8	99	2	72	244	1657831	1658003	Thermus brockianus SNM4-1 DNA, complete genome	blastn	8594	265	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
27377014	27377014	PRJNA431371_P_NODE_643_length_1068_cov_6.336683_g587_i0	PRJNA431371	643	1068	6.336683	67.67577444	Deinococci	188787	Bacteria	Bacteria	300	1.43e-94	NR	RTG94146.1	37636	g587	i0	55.7	15.9887640449438	327	126	91.9	7	998	18	80	387	RTG94146.1 peptidase S8 [Thermus scotoductus]	diamond	17076	303	0.99009900990099	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
27770949	27770949	PRJNA431371_P_NODE_29204_length_247_cov_0.885057_g29131_i0	PRJNA431371	29204	247	0.885057	2.18609079	Thermus brockianus	56956	Bacteria	Bacteria	43.9	0.015	NR	WP_071676650.1	56956	g29131	i0	41.7	0.728744939271255	60	28	71.7	2	36	212	493	546	WP_071676650.1 hypothetical protein [Thermus brockianus]	diamond	180	43.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
30675917	30675917	PRJNA431371_P_NODE_27813_length_249_cov_0.875000_g27740_i0	PRJNA431371	27813	249	0.875	2.17875	Deinococcus budaensis	1665626	Bacteria	Bacteria	132	7.189999999999999e-34	NR	WP_184030208.1	1665626	g27740	i0	88.9	0.975903614457831	81	9	97.6	0	245	3	142	222	WP_184030208.1 helix-hairpin-helix domain-containing protein [Deinococcus budaensis]	diamond	243	132	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
31909059	31909059	PRJNA431371_P_NODE_11017_length_377_cov_2.782895_g10944_i0	PRJNA431371	11017	377	2.782895	10.49151415	Synergistaceae bacterium	2053624	Bacteria	Bacteria	52.4	1.94e-5	NR	MBQ6001342.1	2053624	g10944	i0	68.6	0.86737400530504	35	11	27.9	0	8	112	4	38	MBQ6001342.1 sel1 repeat family protein [Synergistaceae bacterium]	diamond	327	52.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae 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);;