metadata: contig_metadata: 14 rows where bioproject = "PRJNA753704" and tax

14 rows where bioproject = "PRJNA753704" 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
4559658	4559658	PRJNA753704_P_NODE_844_length_1158_cov_12.323502_g613_i0	PRJNA753704	844	1158	12.323502	142.70615316	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	2008	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g613	i0	98.017	206.022452504318	1160	16	100	7	1	1158	74997	73843	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	238574	2008	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
7109730	7109730	PRJNA753704_P_NODE_19606_length_274_cov_2.139303_g19245_i0	PRJNA753704	19606	274	2.139303	5.86169022	Deinococcus grandis	57498	Bacteria	Bacteria	472	1.63e-128	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g19245	i0	97.802	35.3503649635037	273	6	99	0	1	273	426825	426553	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	9686	472	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
10935076	10935076	PRJNA753704_P_NODE_21689_length_262_cov_1.693122_g21328_i0	PRJNA753704	21689	262	1.693122	4.43597964	Deinococcus geothermalis	68909	Bacteria	Bacteria	207	4.8200000000000004e-49	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g21328	i0	81.6	10.2977099236641	250	46	95	0	1	250	1295031	1294782	Deinococcus geothermalis DSM 11300, complete genome	blastn	2698	207	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
13484975	13484975	PRJNA753704_P_NODE_5951_length_470_cov_5.559194_g5590_i0	PRJNA753704	5951	470	5.559194	26.1282118	Meiothermus taiwanensis	172827	Bacteria	Bacteria	486	1.0599999999999998e-132	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g5590	i0	85.412	120.878723404255	473	64	100	5	1	470	258590	258120	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	56813	486	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
13955964	13955964	PRJNA753704_P_NODE_14011_length_319_cov_1.658537_g13650_i0	PRJNA753704	14011	319	1.658537	5.29073303	root	1	Root_unresolved	Root_unresolved	93.5	1.76e-14	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g13650	i0	91.429	6.06896551724138	70	3	21	3	1	68	2141053	2141121	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	1936	93.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
13956034	13956034	PRJNA753704_P_NODE_2511_length_693_cov_4.069355_g2169_i0	PRJNA753704	2511	693	4.069355	28.20063015	Meiothermus	65551	Bacteria	Bacteria	902	0	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g2169	i0	90.202	149.163059163059	694	65	100	3	1	693	945	1636	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	103370	902	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
17309153	17309153	PRJNA753704_P_NODE_20114_length_271_cov_1.787879_g19753_i0	PRJNA753704	20114	271	1.787879	4.84515209	Deinococcus peraridilitoris	432329	Bacteria	Bacteria	224	4.979999999999999e-54	NTclustered	gi\|429128598\|gb\|CP003382.1\|	937777	g19753	i0	84.716	50.2066420664207	229	30	84	4	1	228	3328583	3328359	Deinococcus peraridilitoris DSM 19664, complete genome	blastn	13606	224	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
17309201	17309201	PRJNA753704_P_NODE_24114_length_251_cov_3.820225_g23753_i0	PRJNA753704	24114	251	3.820225	9.58876475	Meiothermus taiwanensis	172827	Bacteria	Bacteria	303	5.69e-78	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g23753	i0	89.3	362.494023904382	243	25	97	1	1	243	258934	258693	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	90986	303	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
18582970	18582970	PRJNA753704_P_NODE_26935_length_245_cov_0.906977_g26574_i0	PRJNA753704	26935	245	0.906977	2.22209365	Meiothermus	65551	Bacteria	Bacteria	154	2.54e-45	NR	WP_299430933.1	157471	g26574	i0	93.8	7.93469387755102	81	5	99.2	0	243	1	74	154	WP_299430933.1 dihydrolipoyllysine-residue succinyltransferase, partial [uncultured Meiothermus sp.]	diamond	1944	155	0.993548387096774	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	uncultured Meiothermus sp.
24957598	24957598	PRJNA753704_P_NODE_21880_length_261_cov_1.659574_g21519_i0	PRJNA753704	21880	261	1.659574	4.33148814	Allomeiothermus silvanus	52022	Bacteria	Bacteria	414	2.63e-111	NTclustered	gi\|296852006\|gb\|CP002043.1\|	526227	g21519	i0	96.063	0.973180076628352	254	10	97	0	8	261	340200	340453	Meiothermus silvanus DSM 9946 plasmid pMESIL01, complete sequence	blastn	254	414	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
27147285	27147285	PRJNA753704_P_NODE_26162_length_247_cov_0.896552_g25801_i0	PRJNA753704	26162	247	0.896552	2.21448344	Deinococcus misasensis	392413	Bacteria	Bacteria	149	1.85e-39	NR	WP_034341935.1	392413	g25801	i0	100	2.69635627530364	74	0	89.9	0	246	25	915	988	WP_034341935.1 FtsK/SpoIIIE family DNA translocase [Deinococcus misasensis]	diamond	666	149	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus misasensis
28189673	28189673	PRJNA753704_P_NODE_13926_length_320_cov_1.263158_g13565_i0	PRJNA753704	13926	320	1.263158	4.0421056	Deinococcus misasensis	392413	Bacteria	Bacteria	203	3.64e-63	NR	WP_034334846.1	392413	g13565	i0	99.1	0.99375	106	1	99.4	0	318	1	56	161	WP_034334846.1 MerR family transcriptional regulator [Deinococcus misasensis]	diamond	318	203	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus misasensis
31295031	31295031	PRJNA753704_P_NODE_28055_length_243_cov_0.917647_g27694_i0	PRJNA753704	28055	243	0.917647	2.22988221	Deinococcus	1298	Bacteria	Bacteria	164	6.92e-45	NR	WP_051963750.1	392413	g27694	i0	100	2.96296296296296	80	0	98.8	0	242	3	1100	1179	WP_051963750.1 ribonuclease R [Deinococcus misasensis]	diamond	720	164	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus misasensis
31380246	31380246	PRJNA753704_P_NODE_25496_length_248_cov_1.748571_g25135_i0	PRJNA753704	25496	248	1.748571	4.33645608	Deinococcus cellulosilyticus	401558	Bacteria	Bacteria	152	8.269999999999998e-41	NR	WP_146889961.1	401558	g25135	i0	97.6	0.991935483870968	82	2	99.2	0	1	246	344	425	WP_146889961.1 tetratricopeptide repeat protein [Deinococcus cellulosilyticus]	diamond	246	152	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cellulosilyticus

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