metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1111077" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1111077" 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
214669	214669	PRJNA1111077_P_NODE_24981_length_270_cov_1.482234_g24760_i0	PRJNA1111077	24981	270	1.482234	4.0020318	Thermus caldilimi	2483360	Bacteria	Bacteria	267	8.12e-67	NTclustered	gi\|1608424790\|gb\|CP038452.1\|	2483360	g24760	i0	86.42	3.6	243	33	90	0	1	243	536950	536708	Thermus caldilimi strain YIM 78456 chromosome, complete genome	blastn	972	267	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus caldilimi
214738	214738	PRJNA1111077_P_NODE_28001_length_259_cov_1.317204_g27780_i0	PRJNA1111077	28001	259	1.317204	3.41155836	Deinococcus yunweiensis	367282	Bacteria	Bacteria	418	2.0199999999999998e-112	NTclustered	gi\|2890656794\|gb\|CP177253.1\|	367282	g27780	i0	95.753	1	259	11	100	0	1	259	445221	444963	Deinococcus yunweiensis strain KCTC 3955 plasmid pDYP1, complete sequence	blastn	259	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
5317564	5317564	PRJNA1111077_P_NODE_23565_length_275_cov_1.376238_g23344_i0	PRJNA1111077	23565	275	1.376238	3.7846545	Deinococcus metallilatus	1211322	Bacteria	Bacteria	368	2.21e-97	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g23344	i0	90.909	1	275	23	99	2	1	274	270034	269761	Deinococcus metallilatus strain MA1002 chromosome	blastn	275	368	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
5317676	5317676	PRJNA1111077_P_NODE_28085_length_258_cov_2.702703_g27864_i0	PRJNA1111077	28085	258	2.702703	6.97297374	Trueperaceae bacterium	2026798	Bacteria	Bacteria	355	1.6e-93	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g27864	i0	91.506	15	259	20	100	2	1	258	6986	6729	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	3870	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
7867243	7867243	PRJNA1111077_P_NODE_16207_length_309_cov_5.754237_g15986_i0	PRJNA1111077	16207	309	5.754237	17.78059233	Deinococcus aetherius	200252	Bacteria	Bacteria	147	1.29e-30	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g15986	i0	86.667	48.4239482200647	135	14	43	3	3	136	81648	81779	Deinococcus aetherius ST0316 DNA, complete genome	blastn	14963	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
7867642	7867642	PRJNA1111077_P_NODE_33087_length_247_cov_0.885057_g32866_i0	PRJNA1111077	33087	247	0.885057	2.18609079	Deinococcus yunweiensis	367282	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g32866	i0	98.381	2	247	4	100	0	1	247	1203984	1204230	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	494	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
8674298	8674298	PRJNA1111077_P_NODE_25187_length_269_cov_1.903061_g24966_i0	PRJNA1111077	25187	269	1.903061	5.11923409	Deinococcus	1298	Bacteria	Bacteria	87.9	6.76e-13	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g24966	i0	96.226	0.394052044609665	53	2	20	0	217	269	1104335	1104283	Deinococcus swuensis strain DY59, complete genome	blastn	106	87.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
10418038	10418038	PRJNA1111077_P_NODE_20289_length_286_cov_1.286385_g20068_i0	PRJNA1111077	20289	286	1.286385	3.6790611	Thermus scotoductus	37636	Bacteria	Bacteria	499	7.85e-137	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g20068	i0	99.634	18.6468531468531	273	1	95	0	1	273	993219	993491	Thermus scotoductus SA-01, complete genome	blastn	5333	499	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
10418069	10418069	PRJNA1111077_P_NODE_21529_length_282_cov_1.277512_g21308_i0	PRJNA1111077	21529	282	1.277512	3.60258384	Deinococcus aetherius	200252	Bacteria	Bacteria	255	1.85e-63	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g21308	i0	89.604	2.58510638297872	202	20	72	1	1	202	97646	97446	Deinococcus aetherius ST0316 DNA, complete genome	blastn	729	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
12968629	12968629	PRJNA1111077_P_NODE_28031_length_259_cov_1.010753_g27810_i0	PRJNA1111077	28031	259	1.010753	2.61785027	Thermus thermophilus	274	Bacteria	Bacteria	468	1.98e-127	NTclustered	gi\|383508497\|gb\|CP003252.1\|	798128	g27810	i0	99.228	41.1853281853282	259	2	100	0	1	259	615822	615564	Thermus thermophilus JL-18, complete genome	blastn	10667	468	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
14243397	14243397	PRJNA1111077_P_NODE_19612_length_288_cov_1.646512_g19391_i0	PRJNA1111077	19612	288	1.646512	4.74195456	Deinococcus yunweiensis	367282	Bacteria	Bacteria	531	2.81e-146	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g19391	i0	100	2.32291666666667	287	0	99	0	1	287	860656	860942	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	669	531	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
15048829	15048829	PRJNA1111077_P_NODE_28492_length_257_cov_1.532609_g28271_i0	PRJNA1111077	28492	257	1.532609	3.93880513	Bacteria	2	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|37223182\|gb\|AY379549.1\|	274	g28271	i0	100	133.828793774319	254	0	99	0	4	257	308	55	Thermus thermophilus TT700 23S ribosomal RNA, 5S ribosomal RNA, and tRNA-Gly genes, complete sequence	blastn	34394	470	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
18066384	18066384	PRJNA1111077_P_NODE_25855_length_267_cov_1.221649_g25634_i0	PRJNA1111077	25855	267	1.221649	3.26180283	Deinococcus yunweiensis	367282	Bacteria	Bacteria	483	7.31e-132	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g25634	i0	99.251	2	267	2	100	0	1	267	2399980	2399714	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	534	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
20615789	20615789	PRJNA1111077_P_NODE_22077_length_280_cov_1.458937_g21856_i0	PRJNA1111077	22077	280	1.458937	4.0850236	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	363	1.0499999999999999e-95	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g21856	i0	90.036	38.0178571428571	281	26	100	2	1	280	482569	482290	Thermus sp. NEB1569 chromosome, complete genome	blastn	10645	363	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
20616051	20616051	PRJNA1111077_P_NODE_32977_length_247_cov_0.885057_g32756_i0	PRJNA1111077	32977	247	0.885057	2.18609079	Meiothermus ruber	277	Bacteria	Bacteria	440	4.079999999999999e-119	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g32756	i0	98.785	7.52631578947368	247	3	100	0	1	247	850499	850253	Meiothermus ruber DSM 1279, complete genome	blastn	1859	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
21891513	21891513	PRJNA1111077_P_NODE_24378_length_272_cov_1.547739_g24157_i0	PRJNA1111077	24378	272	1.547739	4.20985008	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	361	3.65e-95	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g24157	i0	90.741	18.8639705882353	270	25	99	0	1	270	1803366	1803635	Deinococcus sp. NW-56 chromosome, complete genome	blastn	5131	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
23167199	23167199	PRJNA1111077_P_NODE_31239_length_249_cov_1.823864_g31018_i0	PRJNA1111077	31239	249	1.823864	4.54142136	Deinococcus yunweiensis	367282	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g31018	i0	98.394	7.93172690763052	249	4	100	0	1	249	1475532	1475284	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	1975	438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis

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