metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA615351" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA615351" 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
1150037	1150037	PRJNA615351_P_NODE_65441_length_542_cov_2.753452_g51783_i0	PRJNA615351	65441	542	2.753452	14.92370984	Deinococcus	1298	Bacteria	Bacteria	833	0	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g51783	i0	94.465	215.581180811808	542	28	100	1	1	542	71993	71454	Deinococcus puniceus strain DY1, complete genome	blastn	116845	833	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
1871820	1871820	PRJNA615351_P_NODE_48102_length_755_cov_3.284722_g36299_i0	PRJNA615351	48102	755	3.284722	24.7996511	Deinococcus ficus	317577	Bacteria	Bacteria	996	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g36299	i0	90.646	197.495364238411	759	58	100	9	1	755	2341927	2341178	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	149109	996	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
1871869	1871869	PRJNA615351_P_NODE_562_length_5364_cov_19.501783_g121_i2	PRJNA615351	562	5364	19.501783	1046.07564012	Deinococcus irradiatisoli	2202254	Bacteria	Bacteria	56.5	0.043	NTclustered	gi\|1392964945\|gb\|CP029494.1\|	2202254	g121	i2	100	0.00559284116331096	30	0	1	0	4951	4980	350343	350372	Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus irradiatisoli
3146452	3146452	PRJNA615351_P_NODE_167183_length_168_cov_1.962406_g153083_i0	PRJNA615351	167183	168	1.962406	3.29684208	Trueperaceae bacterium	2026798	Bacteria	Bacteria	195	2.22e-45	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g153083	i0	87.5	103.809523809524	168	21	100	0	1	168	2559879	2560046	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	17440	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
4423423	4423423	PRJNA615351_P_NODE_58764_length_611_cov_3.796875_g45639_i0	PRJNA615351	58764	611	3.796875	23.19890625	Trueperaceae bacterium	2026798	Bacteria	Bacteria	350	1.92e-91	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g45639	i0	79.644	211.945990180033	506	88	82	14	1	500	2558545	2559041	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	129499	350	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
4978052	4978052	PRJNA615351_P_NODE_112604_length_271_cov_70.970339_g98505_i0	PRJNA615351	112604	271	70.970339	192.32961869	root	1	Root_unresolved	Root_unresolved	466	7.49e-127	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g98505	i0	97.786	109.981549815498	271	5	99	1	1	270	850	580	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	29805	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
4978064	4978064	PRJNA615351_P_NODE_122544_length_243_cov_6.418269_g108444_i0	PRJNA615351	122544	243	6.418269	15.59639367	Deinococcus	1298	Bacteria	Bacteria	298	2.55e-76	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g108444	i0	88.934	215.353909465021	244	24	100	3	1	243	3060881	3061122	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	52331	300	0.993333333333333	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
4978083	4978083	PRJNA615351_P_NODE_138924_length_208_cov_1.861272_g124824_i0	PRJNA615351	138924	208	1.861272	3.87144576	Fervidobacterium	2422	Bacteria	Bacteria	379	7.359999999999998e-101	NTclustered	gi\|806984310\|ref\|NG_042008.1\|	2424	g124824	i0	99.519	162.918269230769	208	1	100	0	1	208	218	11	Fervidobacterium nodosum strain Rt17-B1 23S ribosomal RNA gene, complete sequence	blastn	33887	379	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
4978128	4978128	PRJNA615351_P_NODE_175424_length_160_cov_1.352000_g161324_i0	PRJNA615351	175424	160	1.352	2.1632	Fervidobacterium	2422	Bacteria	Bacteria	291	2.5799999999999998e-74	NTclustered	gi\|806984310\|ref\|NG_042008.1\|	2424	g161324	i0	99.375	101.29375	160	1	100	0	1	160	2277	2436	Fervidobacterium nodosum strain Rt17-B1 23S ribosomal RNA gene, complete sequence	blastn	16207	291	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
5699255	5699255	PRJNA615351_P_NODE_181645_length_154_cov_2.689076_g167545_i0	PRJNA615351	181645	154	2.689076	4.14117704	Trueperaceae bacterium	2026798	Bacteria	Bacteria	174	2.59e-39	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g167545	i0	87.261	13.0454545454545	157	15	100	4	1	154	2559863	2559709	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	2009	174	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
6973994	6973994	PRJNA615351_P_NODE_143846_length_199_cov_6.329268_g129746_i0	PRJNA615351	143846	199	6.329268	12.59524332	Deinococcus taeanensis	2737050	Bacteria	Bacteria	279	7.280000000000001e-71	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g129746	i0	92	329.804020100502	200	14	100	2	1	199	2533	2335	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	65631	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
18447505	18447505	PRJNA615351_P_NODE_113295_length_269_cov_3.166667_g99196_i0	PRJNA615351	113295	269	3.166667	8.51833423	uncultured Deinococci bacterium	310701	Bacteria	Bacteria	436	5.819999999999999e-118	NTclustered	gi\|339645757\|gb\|JN032374.1\|	310701	g99196	i0	95.971	96.6914498141264	273	3	100	6	1	269	1	269	Uncultured Deinococci bacterium clone WeeA_B08 16S ribosomal RNA gene, partial sequence	blastn	26010	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci				uncultured Deinococci bacterium
19001338	19001338	PRJNA615351_P_NODE_111375_length_275_cov_8.900000_g97276_i0	PRJNA615351	111375	275	8.9	24.475	Deinococcus	1298	Bacteria	Bacteria	497	2.7e-136	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g97276	i0	99.273	297.952727272727	275	2	100	0	1	275	71385	71111	Deinococcus swuensis strain DY59, complete genome	blastn	81937	497	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
19001405	19001405	PRJNA615351_P_NODE_166875_length_169_cov_0.888060_g152775_i0	PRJNA615351	166875	169	0.88806	1.5008214	Thermus	270	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|470468782\|ref\|NR_076136.1\|	37636	g152775	i0	100	148.005917159763	169	0	100	0	1	169	1387	1219	Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence	blastn	25013	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
19722102	19722102	PRJNA615351_P_NODE_11516_length_1917_cov_8.022317_g8275_i0	PRJNA615351	11516	1917	8.022317	153.78781689	Trueperaceae bacterium	2026798	Bacteria	Bacteria	1910	0	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g8275	i0	85.776	325.150756390193	1856	205	95	40	1	1812	2560715	2558875	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	623314	1910	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
20276347	20276347	PRJNA615351_P_NODE_120996_length_247_cov_8.084906_g106896_i0	PRJNA615351	120996	247	8.084906	19.96971782	Deinococcus	1298	Bacteria	Bacteria	307	4.32e-79	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g106896	i0	91.15	221.603238866397	226	20	91	0	11	236	69401	69176	Deinococcus swuensis strain DY59, complete genome	blastn	54736	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
21551996	21551996	PRJNA615351_P_NODE_94557_length_342_cov_5.527687_g80468_i0	PRJNA615351	94557	342	5.527687	18.90468954	Truepera	332248	Bacteria	Bacteria	431	3.55e-116	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g80468	i0	89.443	418.412280701754	341	36	99	0	1	341	11	351	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	143097	431	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
24821840	24821840	PRJNA615351_P_NODE_174400_length_161_cov_1.380952_g160300_i0	PRJNA615351	174400	161	1.380952	2.22333272	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g160300	i0	100	140.434782608696	161	0	100	0	1	161	409931	410091	Thermus sp. NEB1569 chromosome, complete genome	blastn	22610	298	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569

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