metadata: contig_metadata: 12 rows where bioproject = "PRJNA896973" and tax

12 rows where bioproject = "PRJNA896973" 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
1244026	1244026	PRJNA896973_S_NODE_141_length_1030_cov_4.109718_g135_i0	PRJNA896973	141	1030	4.109718	42.3300954	Deinococcus sp. RM	2316359	Bacteria	Bacteria	530	6.719999999999999e-185	NR	WP_119674972.1	2316359	g135	i0	97.8	0.803883495145631	276	4	79.8	1	187	1008	1	276	WP_119674972.1 diguanylate cyclase domain-containing protein [Deinococcus sp. RM]	diamond	828	530	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. RM
1244045	1244045	PRJNA896973_S_NODE_2221_length_266_cov_3.606218_g2207_i0	PRJNA896973	2221	266	3.606218	9.59253988	Deinococcus	1298	Bacteria	Bacteria	302	2.1900000000000002e-77	NTclustered	gi\|2890656794\|gb\|CP177253.1\|	367282	g2207	i0	98.256	42.0300751879699	172	3	82	0	1	172	13156	13327	Deinococcus yunweiensis strain KCTC 3955 plasmid pDYP1, complete sequence	blastn	11180	302	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
6348058	6348058	PRJNA896973_S_NODE_1665_length_301_cov_3.741228_g1651_i0	PRJNA896973	1665	301	3.741228	11.26109628	Deinococcus	1298	Bacteria	Bacteria	545	1.0499999999999999e-150	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g1651	i0	99.336	52.6112956810631	301	2	100	0	1	301	177839	178139	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	15836	545	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
12723560	12723560	PRJNA896973_P_NODE_29130_length_213_cov_9.492857_g29036_i0	PRJNA896973	29130	213	9.492857	20.21978541	root	1	Root_unresolved	Root_unresolved	394	2.7e-105	NTclustered	gi\|2444916559\|dbj\|LC733524.2\|	47478	g29036	i0	100	106.042253521127	213	0	100	0	1	213	1344	1132	Deinococcus sp. AKn-1 gene for 16S rRNA, partial sequence	blastn	22587	394	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
16176052	16176052	PRJNA896973_P_NODE_28193_length_241_cov_0.916667_g28099_i0	PRJNA896973	28193	241	0.916667	2.20916747	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	372	1.47e-98	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g28099	i0	95.359	1.77178423236515	237	5	98	2	1	237	2130147	2130377	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	427	372	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
16546553	16546553	PRJNA896973_P_NODE_3933_length_516_cov_6.749436_g3839_i0	PRJNA896973	3933	516	6.749436	34.82708976	Deinococcus	1298	Bacteria	Bacteria	939	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g3839	i0	99.804	219.12984496124	511	1	99	0	1	511	70050	69540	Deinococcus swuensis strain DY59, complete genome	blastn	113071	939	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
22549785	22549785	PRJNA896973_P_NODE_10838_length_333_cov_4.538462_g10744_i0	PRJNA896973	10838	333	4.538462	15.11307846	Deinococcus grandis	57498	Bacteria	Bacteria	604	1.9199999999999991e-168	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g10744	i0	99.399	234.474474474474	333	2	100	0	1	333	73693	74025	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	78080	604	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
22921722	22921722	PRJNA896973_S_NODE_578_length_487_cov_4.615942_g564_i0	PRJNA896973	578	487	4.615942	22.47963754	Deinococcus	1298	Bacteria	Bacteria	337	1.1699999999999996e-87	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g564	i0	92.116	30.7782340862423	241	15	49	4	1	239	585509	585747	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	14989	337	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
23825346	23825346	PRJNA896973_P_NODE_22079_length_250_cov_2.384181_g21985_i0	PRJNA896973	22079	250	2.384181	5.9604525	Deinococcus grandis	57498	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g21985	i0	98.4	194.932	250	4	100	0	1	250	116811	116562	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	48733	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
26929184	26929184	PRJNA896973_P_NODE_26282_length_244_cov_0.900585_g26188_i0	PRJNA896973	26282	244	0.900585	2.1974274	Trueperaceae bacterium	2026798	Bacteria	Bacteria	138	8.209999999999999e-37	NR	HEX7000611.1	2026798	g26188	i0	90.1	0.995901639344262	81	8	99.6	0	2	244	248	328	HEX7000611.1 folylpolyglutamate synthase/dihydrofolate synthase family protein [Trueperaceae bacterium]	diamond	243	138	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
29676356	29676356	PRJNA896973_P_NODE_14390_length_297_cov_1.102679_g14296_i0	PRJNA896973	14390	297	1.102679	3.27495663	Meiothermus hypogaeus	884155	Bacteria	Bacteria	43.1	0.0401	NR	WP_119342060.1	884155	g14296	i0	34.2	0.737373737373737	73	42	67.7	1	33	233	2	74	WP_119342060.1 lysophospholipid acyltransferase family protein [Meiothermus hypogaeus]	diamond	219	43.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus hypogaeus
31161213	31161213	PRJNA896973_S_NODE_1575_length_308_cov_2.838298_g1561_i0	PRJNA896973	1575	308	2.838298	8.74195784	Deinococcus radiotolerans	1309407	Bacteria	Bacteria	99.8	1.51e-24	NR	WP_189070423.1	1309407	g1561	i0	82	0.594155844155844	61	11	59.4	0	126	308	1	61	WP_189070423.1 ArsR/SmtB family transcription factor [Deinococcus radiotolerans]	diamond	183	99.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiotolerans

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