metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA605033" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA605033" 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
12624951	12624951	PRJNA605033_P_NODE_78030_length_222_cov_2.593583_g76461_i0	PRJNA605033	78030	222	2.593583	5.75775426	Thermus thalpophilus	2908147	Bacteria	Bacteria	88.2	9.72e-20	NR	GAA6756963.1	2908147	g76461	i0	66.2	1	74	15	100	1	1	222	25	88	GAA6756963.1 hypothetical protein Thermus77420_24400 [Thermus thalpophilus]	diamond	222	88.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thalpophilus
26840375	26840375	PRJNA605033_P_NODE_194221_length_168_cov_2.105263_g192652_i0	PRJNA605033	194221	168	2.105263	3.53684184	Bacteria	2	Bacteria	Bacteria	58.2	3.83e-9	NR	MBQ7217111.1	2053624	g192652	i0	50.9	6.375	53	26	94.6	0	161	3	8	60	MBQ7217111.1 hypothetical protein [Synergistaceae bacterium]	diamond	1071	58.5	0.994871794871795	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
27016717	27016717	PRJNA605033_P_NODE_192942_length_169_cov_1.194030_g191373_i0	PRJNA605033	192942	169	1.19403	2.0179107	Deinococcus cellulosilyticus	401558	Bacteria	Bacteria	70.1	3.1e-12	NR	WP_222594821.1	401558	g191373	i0	64.3	4.95266272189349	56	20	99.4	0	168	1	331	386	WP_222594821.1 sugar ABC transporter ATP-binding protein [Deinococcus cellulosilyticus]	diamond	837	70.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cellulosilyticus
27111506	27111506	PRJNA605033_P_NODE_103922_length_222_cov_1.887701_g102353_i0	PRJNA605033	103922	222	1.887701	4.19069622	Deinococcus hopiensis	309885	Bacteria	Bacteria	72	1.32e-12	NR	WP_084046960.1	309885	g102353	i0	42.2	1.37837837837838	102	30	98.6	1	220	2	352	453	WP_084046960.1 ABC transporter substrate-binding protein [Deinococcus hopiensis]	diamond	306	72	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus hopiensis
27251274	27251274	PRJNA605033_P_NODE_115523_length_222_cov_1.695187_g113954_i0	PRJNA605033	115523	222	1.695187	3.76331514	Bacteria	2	Bacteria	Bacteria	45.8	0.00223	NR	WP_183984721.1	521158	g113954	i0	91.7	1.63513513513514	24	2	32.4	0	222	151	192	215	WP_183984721.1 isoaspartyl peptidase/L-asparaginase family protein [Deinobacterium chartae]	diamond	363	46.2	0.991341991341991	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinobacterium	Deinobacterium chartae
27585562	27585562	PRJNA605033_P_NODE_111404_length_222_cov_1.770053_g109835_i0	PRJNA605033	111404	222	1.770053	3.92951766	uncultured Truepera sp.	543023	Bacteria	Bacteria	57.8	1.6e-8	NR	CAA9567977.1	543023	g109835	i0	84	0.337837837837838	25	4	33.8	0	222	148	81	105	CAA9567977.1 MAG: Succinate dehydrogenase cytochrome b-556 subunit [uncultured Truepera sp.]	diamond	75	57.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
27680585	27680585	PRJNA605033_P_NODE_100644_length_222_cov_1.946524_g99075_i0	PRJNA605033	100644	222	1.946524	4.32128328	Deinococcus sp. YIM 134	47478	Bacteria	Bacteria	50.1	6.59e-5	NR	WP_331826047.1	3118910	g99075	i0	95.8	0.324324324324324	24	1	32.4	0	220	149	238	261	WP_331826047.1 AraC family transcriptional regulator [Deinococcus sp. YIM 134068]	diamond	72	50.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus lichenicola
28848342	28848342	PRJNA605033_P_NODE_40368_length_254_cov_6.205479_g38800_i0	PRJNA605033	40368	254	6.205479	15.76191666	Truepera sp.	2478917	Bacteria	Bacteria	128	2.38e-33	NR	MBS3967465.1	2478917	g38800	i0	67.9	1.98425196850394	84	27	99.2	0	3	254	210	293	MBS3967465.1 class I mannose-6-phosphate isomerase [Truepera sp.]	diamond	504	128	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera sp.
28911393	28911393	PRJNA605033_P_NODE_83708_length_222_cov_2.368984_g82139_i0	PRJNA605033	83708	222	2.368984	5.25914448	Truepera radiovictrix	332249	Bacteria	Bacteria	46.6	0.00129	NR	WP_013178840.1	332249	g82139	i0	84	0.337837837837838	25	4	33.8	0	148	222	57	81	WP_013178840.1 DNA polymerase I [Truepera radiovictrix]	diamond	75	46.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
28974919	28974919	PRJNA605033_P_NODE_102788_length_222_cov_1.903743_g101219_i0	PRJNA605033	102788	222	1.903743	4.22630946	Deinococcota bacterium	1913990	Bacteria	Bacteria	62.8	2.36e-9	NR	MDQ3399126.1	1913990	g101219	i0	46.6	0.986486486486487	73	38	98.6	1	220	2	207	278	MDQ3399126.1 replication initiation protein [Deinococcota bacterium]	diamond	219	62.8	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
29763952	29763952	PRJNA605033_P_NODE_100831_length_222_cov_1.941176_g99262_i0	PRJNA605033	100831	222	1.941176	4.30941072	Thermus scotoductus	37636	Bacteria	Bacteria	53.5	4.58e-6	NR	WP_126212131.1	37636	g99262	i0	100	0.675675675675676	25	0	33.8	0	222	148	126	150	WP_126212131.1 helicase-related protein, partial [Thermus scotoductus]	diamond	150	53.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
30333273	30333273	PRJNA605033_P_NODE_119152_length_222_cov_1.582888_g117583_i0	PRJNA605033	119152	222	1.582888	3.51401136	Deinococcus aestuarii	2774531	Bacteria	Bacteria	50.8	2.7e-5	NR	WP_216329126.1	2774531	g117583	i0	92	0.337837837837838	25	2	33.8	0	221	147	182	206	WP_216329126.1 DUF1345 domain-containing protein [Deinococcus aestuarii]	diamond	75	50.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii
31565685	31565685	PRJNA605033_P_NODE_85616_length_222_cov_2.304813_g84047_i0	PRJNA605033	85616	222	2.304813	5.11668486	Thermus tengchongensis	1214928	Bacteria	Bacteria	89.4	1.07e-19	NR	WP_135261095.1	1214928	g84047	i0	66.2	1	74	2	100	1	1	222	77	127	WP_135261095.1 hypothetical protein [Thermus tengchongensis]	diamond	222	89.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus tengchongensis
31944848	31944848	PRJNA605033_P_NODE_238057_length_153_cov_1.016949_g236488_i0	PRJNA605033	238057	153	1.016949	1.55593197	Meiothermus sp.	1955249	Bacteria	Bacteria	41.2	0.04	NR	MCX7784070.1	1955249	g236488	i0	52.4	0.823529411764706	42	20	82.4	0	1	126	553	594	MCX7784070.1 hypothetical protein [Meiothermus sp.]	diamond	126	41.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp.
32008362	32008362	PRJNA605033_P_NODE_67898_length_222_cov_3.379679_g66329_i0	PRJNA605033	67898	222	3.379679	7.50288738	uncultured Truepera sp.	543023	Bacteria	Bacteria	69.3	1.11e-11	NR	CAA9566628.1	543023	g66329	i0	57.9	1.02702702702703	76	29	98.6	1	220	2	328	403	CAA9566628.1 MAG: RNA polymerase sigma factor RpoD [uncultured Truepera sp.]	diamond	228	69.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
32021525	32021525	PRJNA605033_P_NODE_78158_length_222_cov_2.588235_g76589_i0	PRJNA605033	78158	222	2.588235	5.7458817	Deinococcus	1298	Bacteria	Bacteria	48.5	2.58e-4	NR	WP_043801530.1	502394	g76589	i0	84	1.35135135135135	25	4	33.8	0	222	148	151	175	WP_043801530.1 LCP family protein [Deinococcus gobiensis]	diamond	300	48.9	0.991820040899796	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
32134995	32134995	PRJNA605033_P_NODE_236118_length_153_cov_2.330508_g234549_i0	PRJNA605033	236118	153	2.330508	3.56567724	Thermovirgaceae bacterium	3041276	Bacteria	Bacteria	52.4	4.23e-6	NR	MDT8283972.1	3041276	g234549	i0	54.3	3.33333333333333	46	19	90.2	2	140	3	29	72	MDT8283972.1 DNA polymerase III subunit gamma/tau [Thermovirgaceae bacterium]	diamond	510	52.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Thermovirgaceae		Thermovirgaceae bacterium
32829717	32829717	PRJNA605033_P_NODE_110900_length_222_cov_1.780749_g109331_i0	PRJNA605033	110900	222	1.780749	3.95326278	Deinococcus enclensis	1049582	Bacteria	Bacteria	50.4	5.38e-5	NR	WP_307468987.1	1049582	g109331	i0	100	0.324324324324324	24	0	32.4	0	73	2	544	567	WP_307468987.1 VirB4 family type IV secretion system protein [Deinococcus enclensis]	diamond	72	50.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus enclensis
32892490	32892490	PRJNA605033_P_NODE_108740_length_222_cov_1.812834_g107171_i0	PRJNA605033	108740	222	1.812834	4.02449148	Deinococcus budaensis	1665626	Bacteria	Bacteria	51.2	2.89e-5	NR	WP_184030145.1	1665626	g107171	i0	100	0.337837837837838	25	0	33.8	0	75	1	292	316	WP_184030145.1 glycosyltransferase [Deinococcus budaensis]	diamond	75	51.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis

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