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

17 rows where bioproject = "PRJNA1180292" 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
1592558	1592558	PRJNA1180292_P_NODE_5562_length_296_cov_1.233184_g5430_i0	PRJNA1180292	5562	296	1.233184	3.65022464	Deinococcus aetherius	200252	Bacteria	Bacteria	435	2.34e-117	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g5430	i0	94.097	73.5878378378378	288	13	97	3	1	286	5198	4913	Deinococcus aetherius ST0316 DNA, complete genome	blastn	21782	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
4869341	4869341	PRJNA1180292_P_NODE_4384_length_330_cov_3.976654_g4252_i0	PRJNA1180292	4384	330	3.976654	13.1229582	Deinococcus	1298	Bacteria	Bacteria	494	4.29e-135	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g4252	i0	96.358	265.815151515152	302	7	91	4	2	301	714914	715213	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	87719	494	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
7971103	7971103	PRJNA1180292_P_NODE_13127_length_242_cov_0.923077_g12995_i0	PRJNA1180292	13127	242	0.923077	2.23384634	Deinococcus gobiensis	502394	Bacteria	Bacteria	163	9.65e-36	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g12995	i0	80	6.10743801652893	225	42	92	2	1	222	2230189	2229965	Deinococcus gobiensis I-0, complete genome	blastn	1478	163	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
9245700	9245700	PRJNA1180292_P_NODE_10588_length_247_cov_0.896552_g10456_i0	PRJNA1180292	10588	247	0.896552	2.21448344	Deinococcus aetherius	200252	Bacteria	Bacteria	113	2.26e-28	NR	WP_264775767.1	200252	g10456	i0	83.6	0.813765182186235	67	11	81.4	0	236	36	64	130	WP_264775767.1 PRC and DUF2382 domain-containing protein [Deinococcus aetherius]	diamond	201	113	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
11796501	11796501	PRJNA1180292_P_NODE_4730_length_319_cov_1.650407_g4598_i0	PRJNA1180292	4730	319	1.650407	5.26479833	Deinococcus aetherius	200252	Bacteria	Bacteria	468	2.51e-127	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g4598	i0	93.125	16.742946708464	320	21	100	1	1	319	308346	308665	Deinococcus aetherius ST0316 DNA, complete genome	blastn	5341	468	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
11796512	11796512	PRJNA1180292_P_NODE_5730_length_291_cov_1.431193_g5598_i0	PRJNA1180292	5730	291	1.431193	4.16477163	Deinococcus aetherius	200252	Bacteria	Bacteria	255	1.91e-63	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g5598	i0	94.048	2.77319587628866	168	10	58	0	124	291	76944	76777	Deinococcus aetherius ST0316 DNA, complete genome	blastn	807	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
15620698	15620698	PRJNA1180292_P_NODE_8513_length_252_cov_0.871508_g8381_i0	PRJNA1180292	8513	252	0.871508	2.19620016	Deinococcus aetherius	200252	Bacteria	Bacteria	425	1.17e-114	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g8381	i0	97.222	32.5396825396825	252	6	100	1	1	252	398467	398217	Deinococcus aetherius ST0316 DNA, complete genome	blastn	8200	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
18169483	18169483	PRJNA1180292_P_NODE_13295_length_227_cov_2.525974_g13163_i0	PRJNA1180292	13295	227	2.525974	5.73396098	Deinococcus metallilatus	1211322	Bacteria	Bacteria	392	1.0499999999999997e-104	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g13163	i0	98.214	33.8986784140969	224	4	99	0	3	226	2536391	2536168	Deinococcus metallilatus strain MA1002 chromosome	blastn	7695	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
18892782	18892782	PRJNA1180292_P_NODE_7155_length_264_cov_1.408377_g7023_i0	PRJNA1180292	7155	264	1.408377	3.71811528	Deinococcus	1298	Bacteria	Bacteria	479	9.33e-131	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g7023	i0	99.248	161.352272727273	266	0	100	1	1	264	1792290	1792025	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	42597	479	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
19443922	19443922	PRJNA1180292_P_NODE_8516_length_252_cov_0.871508_g8384_i0	PRJNA1180292	8516	252	0.871508	2.19620016	Deinococcus aetherius	200252	Bacteria	Bacteria	385	1.98e-102	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g8384	i0	94.4	40.3531746031746	250	14	99	0	1	250	846789	847038	Deinococcus aetherius ST0316 DNA, complete genome	blastn	10169	385	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
22718144	22718144	PRJNA1180292_P_NODE_3518_length_365_cov_2.585616_g3386_i0	PRJNA1180292	3518	365	2.585616	9.4374984	Deinococcus	1298	Bacteria	Bacteria	669	0	NTclustered	gi\|2678098150\|gb\|PP359631.1\|	47478	g3386	i0	99.726	106.093150684932	365	1	100	0	1	365	25	389	Deinococcus sp. strain BFCQ1 16S ribosomal RNA gene, partial sequence	blastn	38724	669	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
25267524	25267524	PRJNA1180292_P_NODE_9560_length_249_cov_1.636364_g9428_i0	PRJNA1180292	9560	249	1.636364	4.07454636	Deinococcus	1298	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g9428	i0	99.598	208.74297188755	249	1	100	0	1	249	1792859	1792611	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	51977	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
27166874	27166874	PRJNA1180292_P_NODE_9342_length_250_cov_0.881356_g9210_i0	PRJNA1180292	9342	250	0.881356	2.20339	Fervidobacterium sp.	1871331	Bacteria	Bacteria	123	3.0999999999999996e-32	NR	HUM43420.1	1871331	g9210	i0	69.9	0.996	83	25	99.6	0	1	249	22	104	HUM43420.1 hypothetical protein [Fervidobacterium sp.]	diamond	249	123	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
28588293	28588293	PRJNA1180292_P_NODE_12027_length_244_cov_0.912281_g11895_i0	PRJNA1180292	12027	244	0.912281	2.22596564	Thermotogaceae bacterium	2268206	Bacteria	Bacteria	53.5	5.71e-6	NR	HEW91548.1	2268206	g11895	i0	32.5	1.02049180327869	83	50	95.9	2	7	240	264	345	HEW91548.1 glycosyltransferase [Thermotogaceae bacterium]	diamond	249	53.5	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae		Thermotogaceae bacterium
30596748	30596748	PRJNA1180292_P_NODE_10113_length_248_cov_0.891429_g9981_i0	PRJNA1180292	10113	248	0.891429	2.21074392	Bacteria candidate phyla	1783234	Bacteria	Bacteria	111	1.69e-26	NR	HCI29861.1	1871331	g9981	i0	72.6	2.66129032258065	73	20	88.3	0	222	4	1	73	HCI29861.1 helicase [Fervidobacterium sp.]	diamond	660	111	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
32000425	32000425	PRJNA1180292_P_NODE_12658_length_243_cov_0.917647_g12526_i0	PRJNA1180292	12658	243	0.917647	2.22988221	Allomeiothermus silvanus	52022	Bacteria	Bacteria	71.6	1.85e-12	NR	WP_013159700.1	52022	g12526	i0	68.9	0.555555555555556	45	14	55.6	0	143	9	43	87	WP_013159700.1 putative CRISPR-associated protein [Allomeiothermus silvanus]	diamond	135	71.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
32538551	32538551	PRJNA1180292_P_NODE_5439_length_299_cov_1.769912_g5307_i0	PRJNA1180292	5439	299	1.769912	5.29203688	Deinococcus aetherius	200252	Bacteria	Bacteria	48.9	4.66e-4	NR	WP_264778178.1	200252	g5307	i0	78.6	0.280936454849498	28	6	28.1	0	212	295	372	399	WP_264778178.1 hypothetical protein [Deinococcus aetherius]	diamond	84	48.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius

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