metadata: contig_metadata: 8 rows where bioproject = "PRJNA380660" and tax

8 rows where bioproject = "PRJNA380660" 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
402244	402244	PRJNA380660_P_NODE_11001_length_189_cov_2.850000_g10601_i0	PRJNA380660	11001	189	2.85	5.3865	Deinococcus radiopugnans	57497	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g10601	i0	100	211.084656084656	189	0	100	0	1	189	69384	69196	Deinococcus swuensis strain DY59, complete genome	blastn	39895	350	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
2349550	2349550	PRJNA380660_P_NODE_12382_length_161_cov_1.742424_g11982_i0	PRJNA380660	12382	161	1.742424	2.80530264	Deinococcus	1298	Bacteria	Bacteria	292	7.24e-75	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g11982	i0	99.379	144.763975155279	161	1	100	0	1	161	69032	68872	Deinococcus swuensis strain DY59, complete genome	blastn	23307	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
6779973	6779973	PRJNA380660_P_NODE_1946_length_607_cov_254.619377_g1615_i0	PRJNA380660	1946	607	254.619377	1545.53961839	Deinococcus ficus	317577	Bacteria	Bacteria	1031	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g1615	i0	97.368	226.05766062603	608	13	100	3	1	607	2341928	2342533	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	137217	1031	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
7452193	7452193	PRJNA380660_P_NODE_1926_length_609_cov_253.534483_g1596_i0	PRJNA380660	1926	609	253.534483	1544.02500147	Deinococcus	1298	Bacteria	Bacteria	968	0	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g1596	i0	95.545	226.533661740558	606	26	99	1	4	609	1092	488	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	137959	968	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
20803725	20803725	PRJNA380660_P_NODE_2677_length_512_cov_4.383023_g2311_i0	PRJNA380660	2677	512	4.383023	22.44107776	Deinococcus radiophilus	32062	Bacteria	Bacteria	819	0	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g2311	i0	96.215	231.130859375	502	16	98	2	1	502	1813360	1813858	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	118339	819	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
20803741	20803741	PRJNA380660_P_NODE_8297_length_240_cov_4.971564_g7897_i0	PRJNA380660	8297	240	4.971564	11.9317536	Deinococcus ficus	317577	Bacteria	Bacteria	359	1.1399999999999999e-94	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g7897	i0	96.33	232.033333333333	218	8	100	0	1	218	2340779	2340996	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	55688	359	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
22751065	22751065	PRJNA380660_P_NODE_8298_length_240_cov_4.810427_g7898_i0	PRJNA380660	8298	240	4.810427	11.5450248	Deinococcus	1298	Bacteria	Bacteria	387	5.21e-103	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g7898	i0	98.624	239.4375	218	3	100	0	23	240	1636979	1636762	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	57465	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
28544974	28544974	PRJNA380660_P_NODE_5327_length_339_cov_2.212903_g4928_i0	PRJNA380660	5327	339	2.212903	7.50174117	Nitrospinota/Tectimicrobiota group	1802340	Bacteria	Bacteria	47.4	0.00269	NR	WP_103312724.1	2054903	g4928	i0	46.6	1.88495575221239	58	26	51.3	2	157	330	306	358	WP_103312724.1 elongation factor G [Deinococcus koreensis]	diamond	639	47.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus koreensis

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