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

20 rows where analysis = "blastn", bioproject = "PRJNA827593" 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
821544	821544	PRJNA827593_P_NODE_54481_length_269_cov_1.448980_g54182_i0	PRJNA827593	54481	269	1.44898	3.8977562	Deinococcus radiopugnans	57497	Bacteria	Bacteria	353	6.03e-93	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g54182	i0	90.37	44.1338289962825	270	24	100	2	1	269	132120	131852	Deinococcus swuensis strain DY59, complete genome	blastn	11872	353	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
2096874	2096874	PRJNA827593_P_NODE_47422_length_292_cov_1.054795_g47123_i0	PRJNA827593	47422	292	1.054795	3.0800014	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	429	1.07e-115	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g47123	i0	93.151	7.94178082191781	292	20	100	0	1	292	374307	374598	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	2319	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
5924684	5924684	PRJNA827593_P_NODE_54065_length_270_cov_1.563452_g53766_i0	PRJNA827593	54065	270	1.563452	4.2213204	Deinococcus ficus	317577	Bacteria	Bacteria	355	1.6799999999999996e-93	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g53766	i0	90.476	194.859259259259	273	20	100	5	1	270	2342890	2342621	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	52612	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
8474621	8474621	PRJNA827593_P_NODE_68387_length_239_cov_2.295181_g68088_i0	PRJNA827593	68387	239	2.295181	5.48548259	Deinococcus gobiensis	502394	Bacteria	Bacteria	377	3.12e-100	NTclustered	gi\|380002081\|gb\|CP002193.1\|	745776	g68088	i0	98.148	1.02092050209205	216	4	90	0	24	239	355414	355199	Deinococcus gobiensis I-0 plasmid P2, complete sequence	blastn	244	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
9748953	9748953	PRJNA827593_P_NODE_22508_length_445_cov_1.768817_g22209_i0	PRJNA827593	22508	445	1.768817	7.87123565	Thermus aquaticus	271	Bacteria	Bacteria	769	0	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g22209	i0	99.527	139.478651685393	423	1	95	1	24	445	44360	44782	Thermus aquaticus Y51MC23, complete genome	blastn	62068	769	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
9749236	9749236	PRJNA827593_P_NODE_38628_length_327_cov_1.818898_g38329_i0	PRJNA827593	38628	327	1.818898	5.94779646	Deinococcus sp. VB142	3112952	Bacteria	Bacteria	99	3.89e-16	NTclustered	gi\|2706841266\|gb\|CP149784.1\|	3112952	g38329	i0	80.769	2.26605504587156	130	21	39	4	26	153	83566	83439	Deinococcus sp. VB142 plasmid p1, complete sequence	blastn	741	99	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
9749727	9749727	PRJNA827593_P_NODE_66988_length_242_cov_1.822485_g66689_i0	PRJNA827593	66988	242	1.822485	4.4104137	Thermus sp. PS18	2849039	Bacteria	Bacteria	246	9.32e-61	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g66689	i0	85.837	1.9297520661157	233	31	96	2	10	241	314864	315095	Thermus sp. PS18 chromosome, complete genome	blastn	467	246	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
11432127	11432127	PRJNA827593_P_NODE_33329_length_356_cov_1.886926_g33030_i0	PRJNA827593	33329	356	1.886926	6.71745656	Deinococcus	1298	Bacteria	Bacteria	621	2.05e-173	NTclustered	gi\|1572647933\|gb\|MK511813.1\|	47478	g33030	i0	99.705	97.1207865168539	339	1	95	0	1	339	589	251	Deinococcus sp. strain BMS19D 16S ribosomal RNA gene, partial sequence	blastn	34575	621	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
11432153	11432153	PRJNA827593_P_NODE_39409_length_323_cov_2.744000_g39110_i0	PRJNA827593	39409	323	2.744	8.86312	Deinococcus	1298	Bacteria	Bacteria	488	1.9499999999999998e-133	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g39110	i0	95.455	196.978328173375	308	11	94	3	1	305	1456	1763	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	63624	488	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
12300886	12300886	PRJNA827593_P_NODE_66410_length_243_cov_1.358824_g66111_i0	PRJNA827593	66410	243	1.358824	3.30194232	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	163	9.7e-36	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g66111	i0	79.747	8.30452674897119	237	38	95	9	3	234	772905	773136	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	2018	163	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
13575179	13575179	PRJNA827593_P_NODE_64431_length_246_cov_1.121387_g64132_i0	PRJNA827593	64431	246	1.121387	2.75861202	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	259	1.22e-64	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g64132	i0	85.83	153.353658536585	247	32	100	3	1	246	543573	543329	Deinococcus sp. NW-56 chromosome, complete genome	blastn	37725	259	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
15256297	15256297	PRJNA827593_P_NODE_15772_length_544_cov_1.590234_g15475_i0	PRJNA827593	15772	544	1.590234	8.65087296	Deinococcus	1298	Bacteria	Bacteria	1005	0	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g15475	i0	100	47.0165441176471	544	0	100	0	1	544	630423	630966	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	25577	1005	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
16123716	16123716	PRJNA827593_P_NODE_33533_length_355_cov_1.226950_g33234_i0	PRJNA827593	33533	355	1.22695	4.3556725	Thermus aquaticus	271	Bacteria	Bacteria	577	4.4799999999999986e-160	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g33234	i0	98.765	44.1830985915493	324	4	91	0	10	333	48999	48676	Thermus aquaticus Y51MC23, complete genome	blastn	15685	577	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
18672303	18672303	PRJNA827593_P_NODE_25575_length_414_cov_1.806452_g25276_i0	PRJNA827593	25575	414	1.806452	7.47871128	Deinococcus yunweiensis	367282	Bacteria	Bacteria	228	6.159999999999999e-55	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g25276	i0	77.193	2.69565217391304	399	85	95	5	21	414	2742218	2741821	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	1116	228	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
21223008	21223008	PRJNA827593_P_NODE_24317_length_426_cov_1.745042_g24018_i0	PRJNA827593	24317	426	1.745042	7.43387892	Deinococcus metallilatus	1211322	Bacteria	Bacteria	427	5.839999999999999e-115	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g24018	i0	88.418	30.669014084507	354	41	83	0	31	384	2887362	2887009	Deinococcus metallilatus strain MA1002 chromosome	blastn	13065	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
21630429	21630429	PRJNA827593_P_NODE_57877_length_259_cov_2.897849_g57578_i0	PRJNA827593	57877	259	2.897849	7.50542891	Fervidobacterium	2422	Bacteria	Bacteria	113	1.07e-20	NTclustered	gi\|2793125101\|gb\|CP126499.1\|	2423	g57578	i0	93.421	26.3706563706564	76	5	29	0	9	84	1171855	1171780	Fervidobacterium islandicum strain H-21 chromosome, complete genome	blastn	6830	113	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
22497575	22497575	PRJNA827593_P_NODE_17698_length_510_cov_1.773455_g17400_i0	PRJNA827593	17698	510	1.773455	9.0446205	Deinococcus ficus	317577	Bacteria	Bacteria	863	0	NTclustered	gi\|1220365372\|gb\|CP021083.1\|	317577	g17400	i0	98.763	56.7235294117647	485	6	95	0	17	501	321348	320864	Deinococcus ficus strain CC-FR2-10 plasmid pDFI2, complete sequence	blastn	28929	863	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
23773298	23773298	PRJNA827593_P_NODE_19799_length_479_cov_1.278325_g19501_i0	PRJNA827593	19799	479	1.278325	6.12317675	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	228	7.219999999999997e-55	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g19501	i0	78.415	11.7891440501044	366	68	75	9	1	361	232824	233183	Deinococcus sp. D7000 chromosome, complete genome	blastn	5647	228	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
23773417	23773417	PRJNA827593_P_NODE_26019_length_410_cov_1.786350_g25720_i0	PRJNA827593	26019	410	1.78635	7.324035	Thermus aquaticus	271	Bacteria	Bacteria	658	0	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g25720	i0	96.259	4.37073170731707	401	15	98	0	10	410	1951599	1951199	Thermus aquaticus Y51MC23, complete genome	blastn	1792	658	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
23773959	23773959	PRJNA827593_P_NODE_57699_length_260_cov_1.561497_g57400_i0	PRJNA827593	57699	260	1.561497	4.0598922	Deinococcus geothermalis	68909	Bacteria	Bacteria	459	1.19e-124	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g57400	i0	98.462	14.9346153846154	260	4	100	0	1	260	1959582	1959841	Deinococcus geothermalis DSM 11300, complete genome	blastn	3883	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis

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