metadata: contig_metadata: 17 rows where bioproject = "PRJNA674050" and tax

17 rows where bioproject = "PRJNA674050" 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
2441721	2441721	PRJNA674050_P_NODE_6062_length_335_cov_1.320611_g5859_i0	PRJNA674050	6062	335	1.320611	4.42404685	Truepera	332248	Bacteria	Bacteria	457	5.729999999999999e-124	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g5859	i0	93.485	552.970149253731	307	20	92	0	29	335	1197	891	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	185245	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
3194864	3194864	PRJNA674050_P_NODE_31863_length_246_cov_0.901734_g31660_i0	PRJNA674050	31863	246	0.901734	2.21826564	Allomeiothermus silvanus	52022	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g31660	i0	99.593	1.22764227642276	246	1	100	0	1	246	41989	42234	Meiothermus silvanus DSM 9946, complete genome	blastn	302	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
3717993	3717993	PRJNA674050_P_NODE_14563_length_277_cov_5.769608_g14360_i0	PRJNA674050	14563	277	5.769608	15.98181416	Deinococcus	1298	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g14360	i0	100	220.537906137184	274	0	99	0	1	274	1885982	1886255	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	61089	512	0.990234375	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
3718069	3718069	PRJNA674050_P_NODE_4683_length_356_cov_3.420495_g4480_i0	PRJNA674050	4683	356	3.420495	12.1769622	Deinococcus	1298	Bacteria	Bacteria	652	0	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g4480	i0	99.719	209.851123595506	356	1	100	0	1	356	1454614	1454969	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	74707	652	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
7022579	7022579	PRJNA674050_P_NODE_30286_length_247_cov_0.896552_g30083_i0	PRJNA674050	30286	247	0.896552	2.21448344	Allomeiothermus silvanus	52022	Bacteria	Bacteria	440	4.079999999999999e-119	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g30083	i0	98.785	1	247	3	100	0	1	247	1813801	1813555	Meiothermus silvanus DSM 9946, complete genome	blastn	247	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
8297407	8297407	PRJNA674050_P_NODE_34327_length_245_cov_0.901163_g34124_i0	PRJNA674050	34327	245	0.901163	2.20784935	Allomeiothermus silvanus	52022	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|296852006\|gb\|CP002043.1\|	526227	g34124	i0	97.959	1	245	5	100	0	1	245	312262	312506	Meiothermus silvanus DSM 9946 plasmid pMESIL01, complete sequence	blastn	245	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
8819343	8819343	PRJNA674050_P_NODE_10267_length_298_cov_1.960000_g10064_i0	PRJNA674050	10267	298	1.96	5.8408	Deinococcus	1298	Bacteria	Bacteria	540	4.85e-149	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g10064	i0	99.329	106	298	2	100	0	1	298	715	418	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	31588	540	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
9572624	9572624	PRJNA674050_P_NODE_34268_length_245_cov_0.901163_g34065_i0	PRJNA674050	34268	245	0.901163	2.20784935	Allomeiothermus silvanus	52022	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|296852313\|gb\|CP002044.1\|	526227	g34065	i0	97.959	1	245	5	100	0	1	245	15518	15274	Meiothermus silvanus DSM 9946 plasmid pMESIL02, complete sequence	blastn	245	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
13397851	13397851	PRJNA674050_P_NODE_26011_length_250_cov_0.875706_g25808_i0	PRJNA674050	26011	250	0.875706	2.189265	Deinococcus sp. VB142	3112952	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g25808	i0	99.6	10.572	250	1	100	0	1	250	1763882	1764131	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	2643	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
15946933	15946933	PRJNA674050_P_NODE_38893_length_242_cov_0.923077_g38690_i0	PRJNA674050	38893	242	0.923077	2.23384634	Allomeiothermus silvanus	52022	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g38690	i0	98.347	1	242	4	100	0	1	242	3000325	3000566	Meiothermus silvanus DSM 9946, complete genome	blastn	242	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
17222193	17222193	PRJNA674050_P_NODE_35234_length_244_cov_0.912281_g35031_i0	PRJNA674050	35234	244	0.912281	2.22596564	Allomeiothermus silvanus	52022	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g35031	i0	99.59	1	244	1	100	0	1	244	1621467	1621710	Meiothermus silvanus DSM 9946, complete genome	blastn	244	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
18496203	18496203	PRJNA674050_P_NODE_275_length_1382_cov_5.018335_g177_i0	PRJNA674050	275	1382	5.018335	69.3533897	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	2471	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g177	i0	98.987	203.929088277858	1382	11	100	3	1	1382	75104	73726	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	281830	2471	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
22843802	22843802	PRJNA674050_P_NODE_31118_length_247_cov_0.879310_g30915_i0	PRJNA674050	31118	247	0.87931	2.1718957	Thermus	270	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g30915	i0	99.595	11.165991902834	247	1	100	0	1	247	1969569	1969323	Thermus scotoductus SA-01, complete genome	blastn	2758	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
23596906	23596906	PRJNA674050_P_NODE_33299_length_245_cov_1.430233_g33096_i0	PRJNA674050	33299	245	1.430233	3.50407085	Allomeiothermus silvanus	52022	Bacteria	Bacteria	278	3.35e-70	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g33096	i0	98.113	0.648979591836735	159	3	65	0	1	159	710969	710811	Meiothermus silvanus DSM 9946, complete genome	blastn	159	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
25392812	25392812	PRJNA674050_P_NODE_4640_length_357_cov_1.485915_g4437_i0	PRJNA674050	4640	357	1.485915	5.30471655	Thermus	270	Bacteria	Bacteria	449	1.0299999999999999e-121	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g4437	i0	97.701	82.9103641456583	261	6	75	0	2	262	1021123	1021383	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	29599	453	0.991169977924945	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
30207854	30207854	PRJNA674050_P_NODE_18952_length_262_cov_1.296296_g18749_i0	PRJNA674050	18952	262	1.296296	3.39629552	Thermus scotoductus	37636	Bacteria	Bacteria	100	1.5399999999999999e-24	NR	WP_126200485.1	37636	g18749	i0	97.9	0.538167938931298	47	1	53.8	0	2	142	31	77	WP_126200485.1 hypothetical protein [Thermus scotoductus]	diamond	141	100	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
31135996	31135996	PRJNA674050_P_NODE_38355_length_243_cov_0.894118_g38152_i0	PRJNA674050	38355	243	0.894118	2.17270674	Thermaceae	188786	Bacteria	Bacteria	127	8.05e-32	NR	WP_295428882.1	275	g38152	i0	73.4	3.98765432098765	79	20	97.5	1	241	5	676	753	WP_295428882.1 Eco57I restriction-modification methylase domain-containing protein [Thermus sp.]	diamond	969	127	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.

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