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

17 rows where analysis = "blastn", bioproject = "PRJNA565778" 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
7513694	7513694	PRJNA565778_S_NODE_38266_length_174_cov_1.905109_g37970_i0	PRJNA565778	38266	174	1.905109	3.31488966	Fervidobacterium	2422	Bacteria	Bacteria	296	6.12e-76	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g37970	i0	98.802	26.0977011494253	167	1	96	1	1	167	103839	103674	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	4541	296	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
8788701	8788701	PRJNA565778_S_NODE_3627_length_529_cov_100.276423_g3427_i0	PRJNA565778	3627	529	100.276423	530.46227767	Deinococcus	1298	Bacteria	Bacteria	606	8.829999999999996e-169	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g3427	i0	88.911	192.015122873346	496	50	93	4	1	492	116408	116902	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	101576	612	0.990196078431373	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
12037452	12037452	PRJNA565778_S_NODE_37070_length_178_cov_1.659574_g36774_i0	PRJNA565778	37070	178	1.659574	2.95404172	Deinococcus taeanensis	2737050	Bacteria	Bacteria	195	2.36e-45	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g36774	i0	86.592	130.067415730337	179	21	100	3	1	178	1688	1512	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	23152	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
12614800	12614800	PRJNA565778_S_NODE_29250_length_203_cov_12.325301_g28954_i0	PRJNA565778	29250	203	12.325301	25.02036103	Truepera	332248	Bacteria	Bacteria	255	1.26e-63	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g28954	i0	92.655	404.935960591133	177	13	87	0	27	203	37	213	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	82202	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
12614808	12614808	PRJNA565778_S_NODE_31690_length_194_cov_461.993631_g31394_i0	PRJNA565778	31690	194	461.993631	896.26764414	Bacteria	2	Bacteria	Bacteria	276	9.13e-70	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g31394	i0	98.125	54.8298969072165	160	0	81	3	1	157	521553	521394	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	10637	276	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
14586843	14586843	PRJNA565778_S_NODE_10352_length_338_cov_2.468439_g10056_i0	PRJNA565778	10352	338	2.468439	8.34332382	Deinococcus taeanensis	2737050	Bacteria	Bacteria	538	2.0099999999999994e-148	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g10056	i0	95.562	233.949704142012	338	12	99	3	1	335	1561	1898	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	79075	538	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
14587210	14587210	PRJNA565778_S_NODE_39552_length_168_cov_1.274809_g39256_i0	PRJNA565778	39552	168	1.274809	2.14167912	Meiothermus ruber	277	Bacteria	Bacteria	289	9.879999999999999e-74	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g39256	i0	98.765	52.9404761904762	162	2	96	0	1	162	1859193	1859032	Meiothermus ruber DSM 1279, complete genome	blastn	8894	289	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
14587237	14587237	PRJNA565778_S_NODE_42132_length_154_cov_2.333333_g41836_i0	PRJNA565778	42132	154	2.333333	3.59333282	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	285	1.14e-72	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g41836	i0	100	192.811688311688	154	0	100	0	1	154	2417722	2417569	Deinococcus sp. NW-56 chromosome, complete genome	blastn	29693	285	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
17135800	17135800	PRJNA565778_S_NODE_16474_length_272_cov_132.595745_g16178_i0	PRJNA565778	16474	272	132.595745	360.6604264	Allomeiothermus silvanus	52022	Bacteria	Bacteria	401	2.1499999999999993e-107	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g16178	i0	99.545	0.808823529411765	220	1	81	0	38	257	720700	720481	Meiothermus silvanus DSM 9946, complete genome	blastn	220	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
17713737	17713737	PRJNA565778_S_NODE_39094_length_170_cov_3.406015_g38798_i0	PRJNA565778	39094	170	3.406015	5.7902255	Thermus	270	Bacteria	Bacteria	233	4.7299999999999995e-57	NTclustered	gi\|1955386990\|dbj\|AP024305.1\|	274	g38798	i0	97.778	24.6235294117647	135	3	79	0	10	144	89106	89240	Thermus thermophilus HB5008 DNA, complete genome	blastn	4186	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
18410309	18410309	PRJNA565778_S_NODE_36755_length_179_cov_1.345070_g36459_i0	PRJNA565778	36755	179	1.34507	2.4076753	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	220	3.93e-53	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g36459	i0	88.889	166.569832402235	180	19	100	1	1	179	1363157	1362978	Deinococcus sp. QL22 chromosome, complete genome	blastn	29816	220	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
18410454	18410454	PRJNA565778_S_NODE_8175_length_376_cov_2.056047_g7882_i0	PRJNA565778	8175	376	2.056047	7.73073672	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	678	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g7882	i0	99.202	340.659574468085	376	3	100	0	1	376	544147	544522	Deinococcus sp. NW-56 chromosome, complete genome	blastn	128088	678	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
18987058	18987058	PRJNA565778_S_NODE_15855_length_278_cov_2.182573_g15559_i0	PRJNA565778	15855	278	2.182573	6.06755294	Truepera	332248	Bacteria	Bacteria	390	4.77e-104	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g15559	i0	92.364	112.384892086331	275	19	98	1	6	278	1860	1586	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	31243	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
19684901	19684901	PRJNA565778_S_NODE_42096_length_154_cov_2.957265_g41800_i0	PRJNA565778	42096	154	2.957265	4.5541881	Trueperaceae bacterium	2026798	Bacteria	Bacteria	158	2.6e-34	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g41800	i0	88.976	6.72077922077922	127	14	82	0	28	154	8066	7940	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	1035	158	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
22235259	22235259	PRJNA565778_S_NODE_19538_length_250_cov_347.107981_g19242_i0	PRJNA565778	19538	250	347.107981	867.7699525	Oceanotoga sp. DSM 15011	2984951	Bacteria	Bacteria	99	2.87e-16	NTclustered	gi\|2321114327\|gb\|CP107547.1\|	2984951	g19242	i0	93.939	29.26	66	3	26	1	38	102	1061574	1061639	Oceanotoga sp. DSM 15011 chromosome, complete genome	blastn	7315	99	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Oceanotoga	Oceanotoga sp. DSM 15011
22235394	22235394	PRJNA565778_S_NODE_30278_length_199_cov_491.333333_g29982_i0	PRJNA565778	30278	199	491.333333	977.75333267	Thermus thermophilus	274	Bacteria	Bacteria	233	5.75e-57	NTclustered	gi\|2074862859\|dbj\|AP024933.1\|	274	g29982	i0	96.479	25.8291457286432	142	4	71	1	35	175	220100	219959	Thermus thermophilus AA3-7 DNA, complete genome	blastn	5140	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
24784368	24784368	PRJNA565778_S_NODE_18940_length_254_cov_312.373272_g18644_i0	PRJNA565778	18940	254	312.373272	793.42811088	Allomeiothermus silvanus	52022	Bacteria	Bacteria	350	7.3e-92	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g18644	i0	96.279	0.846456692913386	215	5	83	2	39	250	314472	314258	Meiothermus silvanus DSM 9946, complete genome	blastn	215	350	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus

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