metadata: contig_metadata: 17 rows where bioproject = "PRJNA631796", tax_phylum = "Deinococcota" and tax

17 rows where bioproject = "PRJNA631796", tax_phylum = "Deinococcota" and tax_superkingdom = "Bacteria"

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
603396	603396	PRJNA631796_S_NODE_1381_length_487_cov_2.683099_g1214_i0	PRJNA631796	1381	487	2.683099	13.06669213	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	784	0	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g1214	i0	95.697	341.041067761807	488	19	100	2	1	487	98384	98870	Deinococcus sp. AJ005 chromosome, complete genome	blastn	166087	784	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
2427250	2427250	PRJNA631796_P_NODE_1062_length_710_cov_2.221880_g815_i0	PRJNA631796	1062	710	2.22188	15.775348	Bacteria	2	Bacteria	Bacteria	182	1.06e-50	NR	WP_224605023.1	1656887	g815	i0	46.1	4.46619718309859	228	113	96.3	3	684	1	52	269	WP_224605023.1 S8 family peptidase [Deinococcus multiflagellatus]	diamond	3171	182	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus multiflagellatus
3703694	3703694	PRJNA631796_P_NODE_7103_length_255_cov_6.000000_g6825_i0	PRJNA631796	7103	255	6	15.3	Truepera	332248	Bacteria	Bacteria	326	1.2399999999999999e-84	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g6825	i0	89.764	431.533333333333	254	26	99	0	2	255	48	301	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	110041	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
4980262	4980262	PRJNA631796_S_NODE_110004_length_204_cov_1.580420_g109837_i0	PRJNA631796	110004	204	1.58042	3.2240568	Bacteria	2	Bacteria	Bacteria	374	3.339999999999999e-99	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g109837	i0	100	67.093137254902	202	0	99	0	3	204	503	302	Thermus aquaticus DNA polymerase (PolI) gene	blastn	13687	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
5706989	5706989	PRJNA631796_P_NODE_13005_length_201_cov_2.857143_g12727_i0	PRJNA631796	13005	201	2.857143	5.74285743	Deinococcus radiopugnans	57497	Bacteria	Bacteria	257	3.45e-64	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g12727	i0	95.122	104.119402985075	164	6	81	2	1	163	372468	372306	Deinococcus swuensis strain DY59, complete genome	blastn	20928	257	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
7529900	7529900	PRJNA631796_P_NODE_3846_length_355_cov_5.326531_g3568_i0	PRJNA631796	3846	355	5.326531	18.90918505	Deinococcus	1298	Bacteria	Bacteria	444	4.74e-120	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g3568	i0	96.642	166.49014084507	268	7	75	2	1	268	881461	881196	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	59104	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
8804972	8804972	PRJNA631796_P_NODE_387_length_1137_cov_13.812268_g247_i0	PRJNA631796	387	1137	13.812268	157.04548716	Deinococcus	1298	Bacteria	Bacteria	1910	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g247	i0	97.018	306.145118733509	1140	27	100	7	1	1137	1140	5	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	348087	1910	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
11355404	11355404	PRJNA631796_P_NODE_12189_length_204_cov_3.300699_g11911_i0	PRJNA631796	12189	204	3.300699	6.73342596	Truepera	332248	Bacteria	Bacteria	278	2.6999999999999998e-70	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g11911	i0	91.176	140.892156862745	204	18	100	0	1	204	1553	1756	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	28742	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
14632333	14632333	PRJNA631796_P_NODE_4352_length_332_cov_3.546125_g4074_i0	PRJNA631796	4352	332	3.546125	11.773135	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	444	4.42e-120	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g4074	i0	91.265	189.228915662651	332	20	99	8	1	329	543149	543474	Deinococcus sp. NW-56 chromosome, complete genome	blastn	62824	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
15180434	15180434	PRJNA631796_P_NODE_9272_length_225_cov_2.524390_g8994_i0	PRJNA631796	9272	225	2.52439	5.6798775	Truepera	332248	Bacteria	Bacteria	355	1.36e-93	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g8994	i0	95.111	637.413333333333	225	11	100	0	1	225	946502	946726	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	143418	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
18455454	18455454	PRJNA631796_P_NODE_1535_length_575_cov_2.447471_g1265_i0	PRJNA631796	1535	575	2.447471	14.07295825	Trueperaceae bacterium	2026798	Bacteria	Bacteria	763	0	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g1265	i0	90.55	490.19652173913	582	48	100	3	1	575	3600589	3601170	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	281863	763	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
18455468	18455468	PRJNA631796_P_NODE_455_length_1077_cov_10.688976_g291_i1	PRJNA631796	455	1077	10.688976	115.12027152	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	1812	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g291	i1	97.032	280.569173630455	1078	30	100	2	1	1077	2417696	2416620	Deinococcus sp. NW-56 chromosome, complete genome	blastn	302173	1812	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
19003491	19003491	PRJNA631796_P_NODE_8655_length_232_cov_1.461988_g8377_i0	PRJNA631796	8655	232	1.461988	3.39181216	Thermus	270	Bacteria	Bacteria	401	1.7899999999999994e-107	NTclustered	gi\|470468782\|ref\|NR_076136.1\|	37636	g8377	i0	97.845	142.620689655172	232	5	100	0	1	232	1467	1236	Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence	blastn	33088	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
19003494	19003494	PRJNA631796_P_NODE_8755_length_231_cov_1.300000_g8477_i0	PRJNA631796	8755	231	1.3	3.003	Deinococcus	1298	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|145033\|gb\|M21413.1\|DEIRGDA	1299	g8477	i0	100	137.787878787879	231	0	100	0	1	231	307	77	D.radiodurans 16S ribosomal RNA gene	blastn	31829	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
19730025	19730025	PRJNA631796_P_NODE_6916_length_259_cov_5.757576_g6638_i0	PRJNA631796	6916	259	5.757576	14.91212184	Deinococcus gobiensis	502394	Bacteria	Bacteria	468	1.98e-127	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g6638	i0	99.231	255.374517374517	260	1	100	1	1	259	112459	112200	Deinococcus gobiensis I-0, complete genome	blastn	66142	468	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
24829674	24829674	PRJNA631796_P_NODE_440_length_1085_cov_8.566406_g291_i0	PRJNA631796	440	1085	8.566406	92.9455051	Deinococcus ficus	317577	Bacteria	Bacteria	1694	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g291	i0	94.945	218.53732718894	1088	43	100	10	1	1085	2341133	2342211	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	237113	1694	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
29070599	29070599	PRJNA631796_S_NODE_132708_length_198_cov_3.087591_g132541_i0	PRJNA631796	132708	198	3.087591	6.11343018	Thermus oshimai	56957	Bacteria	Bacteria	50.1	4.45e-6	NR	GAA6761585.1	56957	g132541	i0	59.5	0.636363636363636	42	17	63.6	0	59	184	36	77	GAA6761585.1 hypothetical protein Thermus77923_23180 [Thermus oshimai]	diamond	126	50.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai

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