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

19 rows where analysis = "diamond", bioproject = "PRJNA493827" 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
4932691	4932691	PRJNA493827_P_NODE_102664_length_338_cov_1.177358_g100466_i0	PRJNA493827	102664	338	1.177358	3.97947004	Synergistaceae bacterium	2053624	Bacteria	Bacteria	107	3.17e-24	NR	MDR3230624.1	2053624	g100466	i0	47.3	1.97041420118343	112	54	99.4	1	336	1	721	827	MDR3230624.1 ATP-dependent chaperone ClpB [Synergistaceae bacterium]	diamond	666	107	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
7484326	7484326	PRJNA493827_P_NODE_97286_length_347_cov_2.383212_g95088_i0	PRJNA493827	97286	347	2.383212	8.26974564	root	1	Root_unresolved	Root_unresolved	227	1.7999999999999998e-69	NR	AAX47270.1	271	g95088	i0	99.1	3.97694524495677	115	1	99.4	0	1	345	202	316	AAX47270.1 DNA polymerase large fragment, partial [Thermus aquaticus]	diamond	1380	229	0.991266375545852	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
10033030	10033030	PRJNA493827_P_NODE_109728_length_326_cov_2.604743_g107530_i0	PRJNA493827	109728	326	2.604743	8.49146218	Bacteria	2	Bacteria	Bacteria	172	2.9e-47	NR	1TAQ_A	271	g107530	i0	100	3.83742331288344	84	0	77.3	0	73	324	2	85	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1251	172	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
12583425	12583425	PRJNA493827_P_NODE_108770_length_328_cov_1.207843_g106572_i0	PRJNA493827	108770	328	1.207843	3.96172504	Bacteria	2	Bacteria	Bacteria	171	5.719999999999998e-47	NR	1TAQ_A	271	g106572	i0	100	2.46951219512195	90	0	82.3	0	327	58	743	832	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	810	171	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
20873429	20873429	PRJNA493827_P_NODE_201897_length_247_cov_1.655172_g199699_i0	PRJNA493827	201897	247	1.655172	4.08827484	Deinococcus yavapaiensis	309889	Bacteria	Bacteria	124	9.51e-33	NR	WP_110885680.1	309889	g199699	i0	80.5	0.995951417004049	82	16	99.6	0	247	2	21	102	WP_110885680.1 M55 family metallopeptidase [Deinococcus yavapaiensis]	diamond	246	124	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yavapaiensis
24057372	24057372	PRJNA493827_P_NODE_234259_length_241_cov_0.916667_g232061_i0	PRJNA493827	234259	241	0.916667	2.20916747	Thermus thermamylovorans	2509362	Bacteria	Bacteria	92.4	8.47e-20	NR	WP_130841922.1	2509362	g232061	i0	100	0.535269709543568	43	0	53.5	0	3	131	407	449	WP_130841922.1 glycogen synthase [Thermus thermamylovorans]	diamond	129	92.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermamylovorans
24698051	24698051	PRJNA493827_P_NODE_221120_length_243_cov_1.458824_g218922_i0	PRJNA493827	221120	243	1.458824	3.54494232	Deinococcus radiotolerans	1309407	Bacteria	Bacteria	146	6.6e-40	NR	WP_189070820.1	1309407	g218922	i0	97.2	0.888888888888889	72	2	88.9	0	216	1	1	72	WP_189070820.1 ABC transporter substrate-binding protein [Deinococcus radiotolerans]	diamond	216	146	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiotolerans
27266469	27266469	PRJNA493827_P_NODE_195083_length_249_cov_0.875000_g192885_i0	PRJNA493827	195083	249	0.875	2.17875	Truepera radiovictrix	332249	Bacteria	Bacteria	124	9.64e-32	NR	WP_013176792.1	332249	g192885	i0	69.1	0.975903614457831	81	25	97.6	0	5	247	123	203	WP_013176792.1 aminopeptidase [Truepera radiovictrix]	diamond	243	124	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
27677332	27677332	PRJNA493827_P_NODE_203784_length_247_cov_0.885057_g201586_i0	PRJNA493827	203784	247	0.885057	2.18609079	Calidithermus timidus	307124	Bacteria	Bacteria	72.4	6.49e-13	NR	WP_018465211.1	307124	g201586	i0	47.9	6.38866396761134	73	38	88.7	0	245	27	127	199	WP_018465211.1 SDR family NAD(P)-dependent oxidoreductase [Calidithermus timidus]	diamond	1578	72.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Calidithermus	Calidithermus timidus
29161245	29161245	PRJNA493827_P_NODE_191929_length_250_cov_0.870056_g189731_i0	PRJNA493827	191929	250	0.870056	2.17514	Trueperaceae bacterium	2026798	Bacteria	Bacteria	101	9.19e-24	NR	HNQ98407.1	2026798	g189731	i0	59.3	0.972	81	33	97.2	0	7	249	222	302	HNQ98407.1 phage tail tube protein [Trueperaceae bacterium]	diamond	243	101	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
29760842	29760842	PRJNA493827_P_NODE_27571_length_719_cov_2.563467_g25582_i0	PRJNA493827	27571	719	2.563467	18.43132773	Tepiditoga spiralis	2108365	Bacteria	Bacteria	68.6	2.51e-9	NR	WP_190613738.1	2108365	g25582	i0	35.8	0.617524339360223	148	80	59.2	6	718	293	75	213	WP_190613738.1 MFS transporter [Tepiditoga spiralis]	diamond	444	68.6	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Tepiditoga	Tepiditoga spiralis
30045082	30045082	PRJNA493827_P_NODE_198751_length_248_cov_0.880000_g196553_i0	PRJNA493827	198751	248	0.88	2.1824	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	157	3.43e-44	NR	WP_353542757.1	457454	g196553	i0	93.9	0.991935483870968	82	5	99.2	0	3	248	206	287	WP_353542757.1 lasso peptide biosynthesis B2 protein [Deinococcus xinjiangensis]	diamond	246	157	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
30060733	30060733	PRJNA493827_P_NODE_229791_length_242_cov_0.911243_g227593_i0	PRJNA493827	229791	242	0.911243	2.20520806	Deinococcus	1298	Bacteria	Bacteria	66.6	1.4e-10	NR	WP_184110545.1	1141878	g227593	i0	65.5	1.37603305785124	55	17	65.7	1	161	3	14	68	WP_184110545.1 hypothetical protein [Deinococcus metalli]	diamond	333	66.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metalli
30139603	30139603	PRJNA493827_P_NODE_194712_length_249_cov_0.875000_g192514_i0	PRJNA493827	194712	249	0.875	2.17875	Deinococcus seoulensis	1837379	Bacteria	Bacteria	46.6	2.77e-4	NR	WP_189066929.1	1837379	g192514	i0	95.5	0.518072289156627	22	1	26.5	0	184	249	26	47	WP_189066929.1 CopG family ribbon-helix-helix protein [Deinococcus seoulensis]	diamond	129	46.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus seoulensis
30187144	30187144	PRJNA493827_P_NODE_190672_length_250_cov_0.870056_g188474_i0	PRJNA493827	190672	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	60.1	3.02e-8	NR	WP_347241856.1	275	g188474	i0	44.3	4.08	70	36	82.8	2	245	39	177	244	WP_347241856.1 hypothetical protein [Thermus sp.]	diamond	1020	60.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
30250699	30250699	PRJNA493827_P_NODE_60272_length_453_cov_1.500000_g58076_i0	PRJNA493827	60272	453	1.5	6.795	FCB group	1783270	Bacteria	Bacteria	63.5	1.15e-9	NR	WP_024821140.1	81467	g58076	i0	62.2	0.880794701986755	45	17	29.8	0	62	196	49	93	WP_024821140.1 RidA family protein [Aminobacterium mobile]	diamond	399	63.5	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminobacterium	Aminobacterium mobile
30361661	30361661	PRJNA493827_P_NODE_33292_length_644_cov_4.679510_g31155_i0	PRJNA493827	33292	644	4.67951	30.1360444	Marinitoga sp. 38H-ov	1755814	Bacteria	Bacteria	47.8	0.0219	NR	WP_165145512.1	1755814	g31155	i0	26	1.59782608695652	123	85	56.4	3	525	163	68	186	WP_165145512.1 AAA domain-containing protein [Marinitoga sp. 38H-ov]	diamond	1029	47.8	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga sp. 38H-ov
30740259	30740259	PRJNA493827_P_NODE_187394_length_251_cov_0.865169_g185196_i0	PRJNA493827	187394	251	0.865169	2.17157419	uncultured Deinococcus sp.	158789	Bacteria	Bacteria	65.1	4.85e-10	NR	WP_295821270.1	158789	g185196	i0	100	0.370517928286853	31	0	37.1	0	250	158	329	359	WP_295821270.1 glycosyltransferase [uncultured Deinococcus sp.]	diamond	93	65.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
32290233	32290233	PRJNA493827_P_NODE_47119_length_523_cov_2.280000_g44930_i0	PRJNA493827	47119	523	2.28	11.9244	Thermus aquaticus	271	Bacteria	Bacteria	342	3e-113	NR	AAX47270.1	271	g44930	i0	100	5.82791586998088	171	0	98.1	0	513	1	1	171	AAX47270.1 DNA polymerase large fragment, partial [Thermus aquaticus]	diamond	3048	342	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus

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