metadata: contig_metadata: 11 rows where bioproject = "PRJNA1000943" and tax

11 rows where bioproject = "PRJNA1000943" 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
3549823	3549823	PRJNA1000943_P_NODE_14463_length_244_cov_0.912281_g14325_i0	PRJNA1000943	14463	244	0.912281	2.22596564	Deinococcus	1298	Bacteria	Bacteria	244	3.3799999999999997e-60	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g14325	i0	88.038	187.577868852459	209	22	85	3	38	244	1584	1791	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	45769	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
3971407	3971407	PRJNA1000943_P_NODE_14224_length_245_cov_0.906977_g14086_i0	PRJNA1000943	14224	245	0.906977	2.22209365	Deinococcus gobiensis	502394	Bacteria	Bacteria	161	3.52e-35	NTclustered	gi\|380001697\|gb\|CP002192.1\|	745776	g14086	i0	85	1.21224489795918	160	22	65	2	1	159	76491	76333	Deinococcus gobiensis I-0 plasmid P1, complete sequence	blastn	297	161	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
4827288	4827288	PRJNA1000943_P_NODE_4224_length_382_cov_2.766990_g4087_i0	PRJNA1000943	4224	382	2.76699	10.5699018	Deinococcus	1298	Bacteria	Bacteria	422	2.41e-113	NTclustered	gi\|470487735\|ref\|NR_076834.1\|	309887	g4087	i0	87.268	929.471204188482	377	39	97	7	1	372	1439	1067	Deinococcus maricopensis strain LB-34 23S ribosomal RNA gene, complete sequence	blastn	355058	422	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
11202544	11202544	PRJNA1000943_P_NODE_6729_length_313_cov_2.600000_g6591_i0	PRJNA1000943	6729	313	2.6	8.138	Bacteria	2	Bacteria	Bacteria	579	1.0899999999999999e-160	NTclustered	gi\|2866351997\|gb\|PQ721879.1\|	47478	g6591	i0	100	107.210862619808	313	0	100	0	1	313	546	858	Deinococcus sp. strain L174 16S ribosomal RNA gene, partial sequence	blastn	33557	579	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
13752727	13752727	PRJNA1000943_P_NODE_6631_length_316_cov_1.069959_g6493_i0	PRJNA1000943	6631	316	1.069959	3.38107044	Deinococcus	1298	Bacteria	Bacteria	562	1.11e-155	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g6493	i0	98.734	196.107594936709	316	4	100	0	1	316	73100	72785	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	61970	562	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
14173836	14173836	PRJNA1000943_P_NODE_9512_length_270_cov_1.715736_g9374_i0	PRJNA1000943	9512	270	1.715736	4.6324872	Marinithermus hydrothermalis	186192	Bacteria	Bacteria	71.3	6.83e-8	NTclustered	gi\|559113924\|tpe\|HG525821.1\|	869210	g9374	i0	92	0.814814814814815	50	4	19	0	206	255	89	40	TPA: Marinithermus hydrothermalis DSM 14884 tmRNA gene Marin_hydro_14884	blastn	220	71.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Marinithermus	Marinithermus hydrothermalis
15447915	15447915	PRJNA1000943_P_NODE_8333_length_286_cov_1.859155_g8195_i0	PRJNA1000943	8333	286	1.859155	5.3171833	Trueperaceae bacterium	2026798	Bacteria	Bacteria	392	1.3699999999999999e-104	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g8195	i0	92.937	386.867132867133	269	19	94	0	18	286	3600902	3601170	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	110644	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
16722054	16722054	PRJNA1000943_P_NODE_6094_length_327_cov_1.354331_g5956_i0	PRJNA1000943	6094	327	1.354331	4.42866237	Deinococcus grandis	57498	Bacteria	Bacteria	577	4.099999999999999e-160	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g5956	i0	98.471	193.633027522936	327	5	100	0	1	327	116473	116799	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	63318	577	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
18850943	18850943	PRJNA1000943_P_NODE_1675_length_586_cov_1.224172_g1539_i0	PRJNA1000943	1675	586	1.224172	7.17364792	Deinococcus	1298	Bacteria	Bacteria	715	0	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g1539	i0	88.756	215.704778156997	587	63	100	3	1	586	172233	171649	Deinococcus proteolyticus MRP, complete genome	blastn	126403	721	0.991678224687933	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
22676123	22676123	PRJNA1000943_P_NODE_3798_length_401_cov_2.731707_g3661_i0	PRJNA1000943	3798	401	2.731707	10.95414507	Deinococcus	1298	Bacteria	Bacteria	300	1.24e-76	NTclustered	gi\|485099143\|ref\|NR_102538.1\|	432329	g3661	i0	80.535	260.154613466334	411	63	99	13	1	400	483	79	Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence	blastn	104322	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
22676131	22676131	PRJNA1000943_P_NODE_5278_length_348_cov_1.283636_g5140_i0	PRJNA1000943	5278	348	1.283636	4.46705328	Truepera	332248	Bacteria	Bacteria	545	1.24e-150	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g5140	i0	94.857	139.238505747126	350	16	100	1	1	348	2106	1757	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	48455	545	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);;