metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJEB3181" and tax

16 rows where analysis = "blastn", bioproject = "PRJEB3181" 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
55973	55973	PRJEB3181_P_NODE_20341_length_182_cov_1.099338_g20077_i0	PRJEB3181	20341	182	1.099338	2.00079516	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2238962615\|gb\|CP097154.1\|	2939437	g20077	i0	96.875	0.351648351648352	32	1	18	0	129	160	164633	164602	Deinococcus sp. QL22 plasmid unnamed6, complete sequence	blastn	64	54.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
4816708	4816708	PRJEB3181_P_NODE_844_length_624_cov_366.575042_g723_i0	PRJEB3181	844	624	366.575042	2287.42826208	Deinococcus	1298	Bacteria	Bacteria	440	1.1299999999999999e-118	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g723	i0	83.068	456.88782051282	502	67	79	14	125	617	2	494	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	285098	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
5158347	5158347	PRJEB3181_P_NODE_6425_length_327_cov_4.716216_g6167_i0	PRJEB3181	6425	327	4.716216	15.42202632	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	560	4.13e-155	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g6167	i0	97.554	188.850152905199	327	8	100	0	1	327	1886414	1886088	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	61754	560	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
6091930	6091930	PRJEB3181_P_NODE_13305_length_231_cov_503.510000_g13041_i0	PRJEB3181	13305	231	503.51	1163.1081	Deinococcus	1298	Bacteria	Bacteria	303	5.16e-78	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g13041	i0	90.476	193.064935064935	231	21	100	1	1	231	423543	423314	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	44598	303	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
8642013	8642013	PRJEB3181_P_NODE_13347_length_231_cov_5.275000_g13083_i0	PRJEB3181	13347	231	5.275	12.18525	Truepera	332248	Bacteria	Bacteria	320	5.12e-83	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g13083	i0	92.76	619.528138528139	221	16	96	0	1	221	762247	762027	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	143111	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
8983270	8983270	PRJEB3181_S_NODE_8248_length_219_cov_4.592391_g7955_i0	PRJEB3181	8248	219	4.592391	10.05733629	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	361	2.83e-95	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g7955	i0	96.364	518.269406392694	220	7	100	1	1	219	1637693	1637912	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	113501	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
9916999	9916999	PRJEB3181_P_NODE_24208_length_164_cov_2.270677_g23943_i0	PRJEB3181	24208	164	2.270677	3.72391028	Deinococcus	1298	Bacteria	Bacteria	158	2.82e-34	NTclustered	gi\|485099143\|ref\|NR_102538.1\|	432329	g23943	i0	87.97	53.8170731707317	133	16	81	0	32	164	1837	1705	Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence	blastn	8826	158	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
11192230	11192230	PRJEB3181_S_NODE_4309_length_286_cov_1.665339_g4016_i0	PRJEB3181	4309	286	1.665339	4.76286954	Truepera	332248	Bacteria	Bacteria	385	2.29e-102	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g4016	i0	91.756	593.91958041958	279	20	97	3	1	278	762247	761971	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	169861	385	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
12809568	12809568	PRJEB3181_S_NODE_11451_length_190_cov_1.787097_g11158_i0	PRJEB3181	11451	190	1.787097	3.3954843	Deinococcus sp. KNUC1210	2917691	Bacteria	Bacteria	193	9.22e-45	NTclustered	gi\|2197029603\|gb\|CP092190.1\|	2917691	g11158	i0	85	43.5526315789474	200	18	100	9	1	190	1427041	1426844	Deinococcus sp. KNUC1210 chromosome, complete genome	blastn	8275	193	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. KNUC1210
12809617	12809617	PRJEB3181_S_NODE_18011_length_153_cov_2.855932_g17718_i0	PRJEB3181	18011	153	2.855932	4.36957596	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	241	2.49e-59	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g17718	i0	100	79.6535947712418	130	0	85	0	24	153	1636123	1636252	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	12187	241	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
16291567	16291567	PRJEB3181_S_NODE_3333_length_313_cov_19.953237_g3040_i0	PRJEB3181	3333	313	19.953237	62.45363181	Deinococcus	1298	Bacteria	Bacteria	507	5.2e-139	NTclustered	gi\|1192789104\|gb\|KY744731.1\|	47478	g3040	i0	95.847	101.380191693291	313	13	100	0	1	313	510	198	Deinococcus sp. strain 16B18A 16S ribosomal RNA gene, partial sequence	blastn	31732	512	0.990234375	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
16632857	16632857	PRJEB3181_P_NODE_3374_length_412_cov_532.506562_g3140_i0	PRJEB3181	3374	412	532.506562	2193.92703544	Deinococcus ficus	317577	Bacteria	Bacteria	403	9.49e-108	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g3140	i0	95.635	121.81067961165	252	9	61	2	162	412	2491731	2491981	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	50186	403	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
17566665	17566665	PRJEB3181_S_NODE_10214_length_199_cov_4.079268_g9921_i0	PRJEB3181	10214	199	4.079268	8.11774332	Deinococcus	1298	Bacteria	Bacteria	331	1.9800000000000002e-86	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g9921	i0	96.97	245.08040201005	198	5	99	1	1	198	74045	73849	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	48771	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
17566672	17566672	PRJEB3181_S_NODE_12894_length_180_cov_1.613793_g12601_i0	PRJEB3181	12894	180	1.613793	2.9048274	Thermanaerovibrio	81461	Bacteria	Bacteria	104	4.16e-18	NTclustered	gi\|470485441\|ref\|NR_076701.1\|	81462	g12601	i0	90.909	1.71111111111111	77	7	43	0	84	160	1468	1392	Thermanaerovibrio acidaminovorans strain Su883 23S ribosomal RNA gene, complete sequence	blastn	308	104	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Thermanaerovibrio	Thermanaerovibrio acidaminovorans
19181434	19181434	PRJEB3181_P_NODE_27876_length_151_cov_2.483333_g27611_i0	PRJEB3181	27876	151	2.483333	3.74983283	Deinococcus irradiatisoli	2202254	Bacteria	Bacteria	263	5.23e-66	NTclustered	gi\|1392964945\|gb\|CP029494.1\|	2202254	g27611	i0	98.013	308.622516556291	151	3	100	0	1	151	397529	397679	Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome	blastn	46602	263	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus irradiatisoli
20115333	20115333	PRJEB3181_S_NODE_11976_length_186_cov_1.947020_g11683_i0	PRJEB3181	11976	186	1.94702	3.6214572	Deinococcus	1298	Bacteria	Bacteria	305	1.11e-78	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g11683	i0	100	176.279569892473	165	0	89	0	1	165	73124	72960	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	32788	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis

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