metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1005695" 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
4829154	4829154	PRJNA1005695_P_NODE_34504_length_253_cov_1.600000_g33652_i0	PRJNA1005695	34504	253	1.6	4.048	Deinococcus	1298	Bacteria	Bacteria	154	6.12e-33	NTclustered	gi\|470487735\|ref\|NR_076834.1\|	309887	g33652	i0	78.423	336.308300395257	241	49	95	3	7	246	1253	1491	Deinococcus maricopensis strain LB-34 23S ribosomal RNA gene, complete sequence	blastn	85086	154	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
5256537	5256537	PRJNA1005695_P_NODE_38025_length_246_cov_0.901734_g37173_i0	PRJNA1005695	38025	246	0.901734	2.21826564	Allomeiothermus silvanus	52022	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g37173	i0	98.374	1	246	4	100	0	1	246	2449208	2449453	Meiothermus silvanus DSM 9946, complete genome	blastn	246	433	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
6104332	6104332	PRJNA1005695_P_NODE_39485_length_243_cov_0.917647_g38633_i0	PRJNA1005695	39485	243	0.917647	2.22988221	Deinococcus	1298	Bacteria	Bacteria	252	2.01e-62	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g38633	i0	85.484	142.938271604938	248	28	100	7	1	243	467	223	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	34734	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
9080979	9080979	PRJNA1005695_P_NODE_25968_length_294_cov_1.520362_g25116_i0	PRJNA1005695	25968	294	1.520362	4.46986428	Tepiditoga spiralis	2108365	Bacteria	Bacteria	204	7.119999999999998e-48	NTclustered	gi\|1898704378\|dbj\|AP018712.1\|	2108365	g25116	i0	80.364	6.36394557823129	275	48	93	6	17	288	259862	259591	Tepiditoga spiralis sy52 DNA, complete genome	blastn	1871	204	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Tepiditoga	Tepiditoga spiralis
12479898	12479898	PRJNA1005695_P_NODE_18810_length_348_cov_1.869091_g17958_i0	PRJNA1005695	18810	348	1.869091	6.50443668	Deinococcus	1298	Bacteria	Bacteria	643	4.279999999999998e-180	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g17958	i0	100	105.98275862069	348	0	100	0	1	348	838	491	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	36882	643	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
12907140	12907140	PRJNA1005695_P_NODE_17151_length_365_cov_1.568493_g16299_i0	PRJNA1005695	17151	365	1.568493	5.72499945	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	652	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g16299	i0	98.904	196.575342465753	365	4	100	0	1	365	74442	74078	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	71750	652	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
12907370	12907370	PRJNA1005695_P_NODE_40611_length_238_cov_2.630303_g39759_i0	PRJNA1005695	40611	238	2.630303	6.26012114	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g39759	i0	100	469.294117647059	238	0	100	0	1	238	68285	68522	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	111692	440	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
14182316	14182316	PRJNA1005695_P_NODE_39292_length_243_cov_2.347059_g38440_i0	PRJNA1005695	39292	243	2.347059	5.70335337	Deinococcus yunweiensis	367282	Bacteria	Bacteria	411	3.14e-110	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g38440	i0	97.119	208.131687242798	243	7	100	0	1	243	2672526	2672284	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	50576	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
16303708	16303708	PRJNA1005695_P_NODE_5273_length_691_cov_2.399676_g4468_i0	PRJNA1005695	5273	691	2.399676	16.58176116	Deinococcus	1298	Bacteria	Bacteria	1105	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g4468	i0	95.429	271.593342981187	700	20	100	10	1	691	1792541	1791845	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	187671	1105	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
20554832	20554832	PRJNA1005695_P_NODE_39977_length_242_cov_0.923077_g39125_i0	PRJNA1005695	39977	242	0.923077	2.23384634	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	435	1.85e-117	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g39125	i0	99.17	168.896694214876	241	2	99	0	1	241	1362335	1362575	Deinococcus sp. QL22 chromosome, complete genome	blastn	40873	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
21830326	21830326	PRJNA1005695_P_NODE_30158_length_272_cov_1.346734_g29306_i0	PRJNA1005695	30158	272	1.346734	3.66311648	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	431	2.74e-116	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g29306	i0	95.238	113.908088235294	273	12	100	1	1	272	69609	69337	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	30983	431	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum

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