metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA685607" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA685607" 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
1176452	1176452	PRJNA685607_P_NODE_65341_length_251_cov_0.865169_g64982_i0	PRJNA685607	65341	251	0.865169	2.17157419	Deinococcus	1298	Bacteria	Bacteria	224	4.5599999999999996e-54	NTclustered	gi\|1220365372\|gb\|CP021083.1\|	317577	g64982	i0	83.402	4.61752988047809	241	40	96	0	1	241	137770	138010	Deinococcus ficus strain CC-FR2-10 plasmid pDFI2, complete sequence	blastn	1159	224	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
1942271	1942271	PRJNA685607_P_NODE_33682_length_318_cov_1.224490_g33323_i0	PRJNA685607	33682	318	1.22449	3.8938782	Deinococcus aetherius	200252	Bacteria	Bacteria	571	1.8499999999999996e-158	NTclustered	gi\|2281898870\|dbj\|AP026562.1\|	200252	g33323	i0	99.06	1.40566037735849	319	2	100	1	1	318	63500	63182	Deinococcus aetherius ST0316 plasmid pDAETH-2 DNA, complete genome	blastn	447	571	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
1942470	1942470	PRJNA685607_P_NODE_90562_length_243_cov_0.905882_g90203_i0	PRJNA685607	90562	243	0.905882	2.20129326	Deinococcus gobiensis	502394	Bacteria	Bacteria	154	5.84e-33	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g90203	i0	78.512	2.65020576131687	242	46	98	6	2	240	2291281	2291043	Deinococcus gobiensis I-0, complete genome	blastn	644	154	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
3217388	3217388	PRJNA685607_P_NODE_93443_length_242_cov_0.911243_g93084_i0	PRJNA685607	93443	242	0.911243	2.20520806	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	244	3.3499999999999997e-60	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g93084	i0	85.062	24.0454545454545	241	35	99	1	1	240	1992054	1991814	Deinococcus sp. QL22 chromosome, complete genome	blastn	5819	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
3728227	3728227	PRJNA685607_P_NODE_65403_length_251_cov_0.865169_g65044_i0	PRJNA685607	65403	251	0.865169	2.17157419	Deinococcus	1298	Bacteria	Bacteria	135	2.2e-27	NTclustered	gi\|2706840606\|gb\|CP149783.1\|	3112952	g65044	i0	81.875	1.27490039840637	160	29	64	0	92	251	365362	365203	Deinococcus sp. VB142 chromosome 2, complete sequence	blastn	320	135	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
5770107	5770107	PRJNA685607_P_NODE_92505_length_242_cov_0.911243_g92146_i0	PRJNA685607	92505	242	0.911243	2.20520806	Deinococcus metallilatus	1211322	Bacteria	Bacteria	135	2.1e-27	NTclustered	gi\|1609450184\|gb\|CP038510.1\|	1211322	g92146	i0	77.236	1.01652892561983	246	46	99	9	1	241	784876	784636	Deinococcus metallilatus strain MA1002 plasmid unnamed1, complete sequence	blastn	246	135	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
8829481	8829481	PRJNA685607_P_NODE_94647_length_241_cov_0.916667_g94288_i0	PRJNA685607	94647	241	0.916667	2.20916747	Thermaceae	188786	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g94288	i0	98.34	48.850622406639	241	4	100	0	1	241	1887935	1887695	Meiothermus ruber DSM 1279, complete genome	blastn	11773	424	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
9594935	9594935	PRJNA685607_P_NODE_50948_length_276_cov_1.458128_g50589_i0	PRJNA685607	50948	276	1.458128	4.02443328	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	359	1.34e-94	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g50589	i0	90.217	3.66304347826087	276	26	99	1	2	276	1592415	1592140	Deinococcus sp. QL22 chromosome, complete genome	blastn	1011	359	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
13930451	13930451	PRJNA685607_P_NODE_77411_length_247_cov_0.885057_g77052_i0	PRJNA685607	77411	247	0.885057	2.18609079	Truepera	332248	Bacteria	Bacteria	111	3.63e-20	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g77052	i0	83.333	5.49392712550607	126	15	50	5	1	123	1979908	1980030	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	1357	111	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
14695196	14695196	PRJNA685607_P_NODE_13952_length_430_cov_1.820728_g13594_i0	PRJNA685607	13952	430	1.820728	7.8291304	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g13594	i0	100	0.0674418604651163	29	0	7	0	301	329	1334995	1335023	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	29	54.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
17244236	17244236	PRJNA685607_P_NODE_25334_length_348_cov_0.956364_g24975_i0	PRJNA685607	25334	348	0.956364	3.32814672	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	377	4.79e-100	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g24975	i0	95.726	2.03448275862069	234	10	100	0	115	348	293389	293622	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	708	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
19793375	19793375	PRJNA685607_P_NODE_78276_length_247_cov_0.885057_g77917_i0	PRJNA685607	78276	247	0.885057	2.18609079	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	313	9.28e-81	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g77917	i0	89.474	5.49392712550607	247	26	100	0	1	247	1543237	1543483	Deinococcus sp. QL22 chromosome, complete genome	blastn	1357	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
22343547	22343547	PRJNA685607_P_NODE_22418_length_362_cov_1.041522_g22059_i0	PRJNA685607	22418	362	1.041522	3.77030964	Deinococcus radiopugnans	57497	Bacteria	Bacteria	237	8.830000000000001e-58	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g22059	i0	80.183	2.69060773480663	328	55	89	7	13	335	2266105	2265783	Deinococcus swuensis strain DY59, complete genome	blastn	974	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
23619247	23619247	PRJNA685607_P_NODE_69459_length_250_cov_0.870056_g69100_i0	PRJNA685607	69459	250	0.870056	2.17514	Deinococcus aetherius	200252	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2281898870\|dbj\|AP026562.1\|	200252	g69100	i0	99.2	1	250	2	100	0	1	250	517069	516820	Deinococcus aetherius ST0316 plasmid pDAETH-2 DNA, complete genome	blastn	250	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
23619348	23619348	PRJNA685607_P_NODE_93039_length_242_cov_0.911243_g92680_i0	PRJNA685607	93039	242	0.911243	2.20520806	Deinococcus geothermalis	68909	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g92680	i0	99.587	1.98760330578512	242	1	100	0	1	242	93169	92928	Deinococcus geothermalis DSM 11300, complete genome	blastn	481	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
25402869	25402869	PRJNA685607_P_NODE_50620_length_277_cov_1.132353_g50261_i0	PRJNA685607	50620	277	1.132353	3.13661781	Deinococcus	1298	Bacteria	Bacteria	292	1.38e-74	NTclustered	gi\|2444123840\|gb\|CP115166.1\|	328692	g50261	i0	86.131	6.63537906137184	274	34	98	4	5	276	276805	276534	Deinococcus aquaticus strain PB-314 plasmid pDATS01, complete sequence	blastn	1838	294	0.993197278911565	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus 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);;