metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA492363" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA492363" and tax_phylum = "Deinococcota"

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
25565776	25565776	PRJNA492363_S_NODE_12825_length_275_cov_0.911215_g12004_i0	PRJNA492363	12825	275	0.911215	2.50584125	Deinococcus altitudinis	468914	Bacteria	Bacteria	196	1.1e-45	NTclustered	gi\|2865404944\|gb\|CP129415.1\|	468914	g12004	i0	88.024	65.5272727272727	167	18	60	2	32	197	1131875	1132040	Deinococcus altitudinis strain LMG 24022 chromosome, complete genome	blastn	18020	196	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
25624934	25624934	PRJNA492363_S_NODE_13169_length_272_cov_1.113744_g12348_i0	PRJNA492363	13169	272	1.113744	3.02938368	Thermus	270	Bacteria	Bacteria	350	7.9e-92	NTclustered	gi\|1953559172\|dbj\|AP024270.1\|	274	g12348	i0	100	39.9338235294118	189	0	92	0	22	210	916359	916171	Thermus thermophilus HB5018 DNA, complete genome	blastn	10862	350	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
25625286	25625286	PRJNA492363_S_NODE_95265_length_204_cov_0.895105_g94444_i0	PRJNA492363	95265	204	0.895105	1.8260142	Truepera	332248	Bacteria	Bacteria	178	2.81e-40	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g94444	i0	83.598	3.81372549019608	189	31	93	0	4	192	356126	355938	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	778	178	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
25703201	25703201	PRJNA492363_S_NODE_86082_length_209_cov_0.864865_g85261_i0	PRJNA492363	86082	209	0.864865	1.80756785	Trueperaceae bacterium	2026798	Bacteria	Bacteria	147	8.169999999999998e-31	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g85261	i0	100	38.5693779904306	79	0	38	0	29	107	4125794	4125872	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	8061	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
25703276	25703276	PRJNA492363_S_NODE_89530_length_207_cov_1.623288_g88709_i0	PRJNA492363	89530	207	1.623288	3.36020616	Deinococcus yunweiensis	367282	Bacteria	Bacteria	339	1.2399999999999998e-88	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g88709	i0	99.462	1.79710144927536	186	1	90	0	21	206	2449265	2449080	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	372	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
25761279	25761279	PRJNA492363_S_NODE_17954_length_250_cov_1.962963_g17133_i0	PRJNA492363	17954	250	1.962963	4.9074075	Truepera	332248	Bacteria	Bacteria	213	9.81e-51	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g17133	i0	82.773	5.088	238	41	95	0	7	244	1529932	1529695	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	1272	213	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
25761588	25761588	PRJNA492363_S_NODE_93042_length_205_cov_1.854167_g92221_i0	PRJNA492363	93042	205	1.854167	3.80104235	Truepera	332248	Bacteria	Bacteria	137	4.8e-28	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g92221	i0	98.701	51.6195121951219	77	1	38	0	27	103	2187189	2187113	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	10582	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
25975445	25975445	PRJNA492363_S_NODE_8316_length_327_cov_1.439850_g7495_i0	PRJNA492363	8316	327	1.43985	4.7083095	Meiothermus taiwanensis WR-22	172827	Bacteria	Bacteria	195	4.83e-45	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g7495	i0	83.568	2.00305810397554	213	29	64	5	2	211	206695	206486	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	655	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
26033541	26033541	PRJNA492363_S_NODE_71676_length_222_cov_2.888199_g70855_i0	PRJNA492363	71676	222	2.888199	6.41180178	Truepera	332248	Bacteria	Bacteria	172	1.45e-38	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g70855	i0	83.889	175.621621621622	180	29	81	0	11	190	1623759	1623938	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	38988	172	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
26033566	26033566	PRJNA492363_S_NODE_77860_length_217_cov_1.756410_g77039_i0	PRJNA492363	77860	217	1.75641	3.8114097	Truepera	332248	Bacteria	Bacteria	167	6.56e-37	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g77039	i0	90.476	140.668202764977	126	12	58	0	25	150	2611146	2611271	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	30525	167	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
26033595	26033595	PRJNA492363_S_NODE_83948_length_210_cov_0.906040_g83127_i0	PRJNA492363	83948	210	0.90604	1.902684	Deinococcus	1298	Bacteria	Bacteria	220	4.77e-53	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g83127	i0	85.646	12.8809523809524	209	30	99	0	2	210	1863420	1863628	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	2705	220	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
26111759	26111759	PRJNA492363_S_NODE_95109_length_204_cov_1.328671_g94288_i0	PRJNA492363	95109	204	1.328671	2.71048884	Deinococcus metallilatus	1211322	Bacteria	Bacteria	122	1.34e-23	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g94288	i0	82.963	211.254901960784	135	23	66	0	55	189	1682402	1682536	Deinococcus metallilatus strain MA1002 chromosome	blastn	43096	122	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
26111816	26111816	PRJNA492363_S_NODE_9701_length_309_cov_1.040323_g8880_i0	PRJNA492363	9701	309	1.040323	3.21459807	Deinococcus radiomollis	468916	Bacteria	Bacteria	268	2.63e-67	NTclustered	gi\|2865409981\|gb\|CP129906.1\|	468916	g8880	i0	84.116	126.142394822006	277	44	90	0	1	277	2726899	2727175	Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome	blastn	38978	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
26169336	26169336	PRJNA492363_S_NODE_11085_length_291_cov_1.069565_g10264_i0	PRJNA492363	11085	291	1.069565	3.11243415	Truepera	332248	Bacteria	Bacteria	252	2.48e-62	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g10264	i0	85.246	137.343642611684	244	36	84	0	36	279	1882703	1882946	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	39967	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
26169634	26169634	PRJNA492363_S_NODE_74637_length_220_cov_1.610063_g73816_i0	PRJNA492363	74637	220	1.610063	3.5421386	Truepera	332248	Bacteria	Bacteria	237	5.01e-58	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g73816	i0	86.574	1.97727272727273	216	27	98	2	3	217	136880	137094	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	435	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
26305554	26305554	PRJNA492363_S_NODE_89702_length_207_cov_1.178082_g88881_i0	PRJNA492363	89702	207	1.178082	2.43862974	Truepera	332248	Bacteria	Bacteria	228	2.8e-55	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g88881	i0	93.464	204.285024154589	153	10	74	0	35	187	3253051	3252899	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	42287	228	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
26383365	26383365	PRJNA492363_S_NODE_76999_length_218_cov_1.222930_g76178_i0	PRJNA492363	76999	218	1.22293	2.6659874	Deinococcus psychrotolerans	2489213	Bacteria	Bacteria	117	6.740000000000001e-22	NTclustered	gi\|1527206539\|gb\|CP034184.1\|	2489213	g76178	i0	87.255	17.8256880733945	102	13	47	0	115	216	338596	338697	Deinococcus psychrotolerans strain S14-83 chromosome 2, complete sequence	blastn	3886	117	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus psychrotolerans
26441674	26441674	PRJNA492363_S_NODE_91223_length_206_cov_2.082759_g90402_i0	PRJNA492363	91223	206	2.082759	4.29048354	Thermus	270	Bacteria	Bacteria	279	7.59e-71	NTclustered	gi\|2701833777\|dbj\|AP031329.1\|	274	g90402	i0	92.784	14.6165048543689	194	12	93	2	1	192	231877	232070	Thermus thermophilus TF24 plasmid pTF24b DNA, complete sequence	blastn	3011	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
26520004	26520004	PRJNA492363_S_NODE_94992_length_204_cov_1.391608_g94171_i0	PRJNA492363	94992	204	1.391608	2.83888032	Deinococcus yunweiensis	367282	Bacteria	Bacteria	333	5.679999999999999e-87	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g94171	i0	96.078	2.84313725490196	204	8	100	0	1	204	1214832	1215035	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	580	333	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
26577192	26577192	PRJNA492363_S_NODE_13376_length_270_cov_1.837321_g12555_i0	PRJNA492363	13376	270	1.837321	4.9607667	Truepera	332248	Bacteria	Bacteria	158	5.1e-34	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g12555	i0	80.189	156.548148148148	212	40	78	2	35	245	545059	544849	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	42268	158	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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