metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1195551" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1195551" 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
322647	322647	PRJNA1195551_S_NODE_9341_length_302_cov_3.505929_g8988_i0	PRJNA1195551	9341	302	3.505929	10.58790558	Deinococcus ficus	317577	Bacteria	Bacteria	340	5.3599999999999996e-89	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g8988	i0	87.255	190.132450331126	306	29	99	10	1	301	2342523	2342823	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	57420	340	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
2318483	2318483	PRJNA1195551_S_NODE_4642_length_397_cov_20.267241_g4289_i0	PRJNA1195551	4642	397	20.267241	80.46094677	Deinococcus	1298	Bacteria	Bacteria	710	0	NTclustered	gi\|2549460888\|gb\|OR304356.1\|	32062	g4289	i0	99.487	100.748110831234	390	2	98	0	8	397	415	804	Deinococcus radiophilus strain LMITABS01070 16S ribosomal RNA gene, partial sequence	blastn	39997	710	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
2873345	2873345	PRJNA1195551_S_NODE_15363_length_250_cov_6.945274_g15010_i0	PRJNA1195551	15363	250	6.945274	17.363185	Deinococcus aetherius	200252	Bacteria	Bacteria	418	1.9399999999999998e-112	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g15010	i0	96.8	183.632	250	8	100	0	1	250	83596	83845	Deinococcus aetherius ST0316 DNA, complete genome	blastn	45908	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
4149532	4149532	PRJNA1195551_S_NODE_33064_length_177_cov_1.218750_g32711_i0	PRJNA1195551	33064	177	1.21875	2.1571875	Deinococcus geothermalis	68909	Bacteria	Bacteria	320	3.71e-83	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g32711	i0	99.432	5.97175141242938	176	1	99	0	1	176	2416412	2416587	Deinococcus geothermalis DSM 11300, complete genome	blastn	1057	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
5425710	5425710	PRJNA1195551_S_NODE_17525_length_237_cov_1.106383_g17172_i0	PRJNA1195551	17525	237	1.106383	2.62212771	Deinococcus radiophilus	32062	Bacteria	Bacteria	219	1.9799999999999994e-52	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g17172	i0	86.207	0.991561181434599	203	27	86	1	29	231	123499	123298	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	235	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
6145921	6145921	PRJNA1195551_S_NODE_19985_length_223_cov_14.632184_g19632_i0	PRJNA1195551	19985	223	14.632184	32.62977032	Deinococcus	1298	Bacteria	Bacteria	412	7.88e-111	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g19632	i0	100	311.690582959641	223	0	100	0	1	223	69459	69237	Deinococcus swuensis strain DY59, complete genome	blastn	69507	412	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
9250497	9250497	PRJNA1195551_S_NODE_31768_length_180_cov_2.694656_g31415_i0	PRJNA1195551	31768	180	2.694656	4.8503808	Deinococcus taeanensis	2737050	Bacteria	Bacteria	259	8.38e-65	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g31415	i0	94.118	152.144444444444	170	10	94	0	1	170	1769	1600	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	27386	259	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
11801164	11801164	PRJNA1195551_S_NODE_7950_length_320_cov_21.498155_g7597_i0	PRJNA1195551	7950	320	21.498155	68.794096	Deinococcus radiopugnans	57497	Bacteria	Bacteria	551	2.429999999999999e-152	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g7597	i0	98.101	209.3125	316	6	99	0	5	320	69021	69336	Deinococcus swuensis strain DY59, complete genome	blastn	66980	551	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
14351599	14351599	PRJNA1195551_S_NODE_3152_length_474_cov_53.908235_g2801_i0	PRJNA1195551	3152	474	53.908235	255.5250339	Deinococcus radiophilus	32062	Bacteria	Bacteria	824	0	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g2801	i0	98.501	211.443037974684	467	7	99	0	1	467	1814592	1815058	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	100224	824	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
16899666	16899666	PRJNA1195551_S_NODE_21674_length_216_cov_1.497006_g21321_i0	PRJNA1195551	21674	216	1.497006	3.23353296	Deinococcus proteolyticus	55148	Bacteria	Bacteria	281	2.23e-71	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g21321	i0	90.995	91.8564814814815	211	15	97	4	1	209	25780	25572	Deinococcus proteolyticus MRP, complete genome	blastn	19841	281	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
18174223	18174223	PRJNA1195551_S_NODE_35115_length_172_cov_1.691057_g34762_i0	PRJNA1195551	35115	172	1.691057	2.90861804	Trueperaceae bacterium	2026798	Bacteria	Bacteria	279	6.08e-71	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g34762	i0	95.93	348.761627906977	172	7	100	0	1	172	2559296	2559467	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	59987	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
21999370	21999370	PRJNA1195551_S_NODE_38298_length_166_cov_1.333333_g37945_i0	PRJNA1195551	38298	166	1.333333	2.21333278	Deinococcus proteolyticus	55148	Bacteria	Bacteria	239	9.94e-59	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g37945	i0	93.252	0.981927710843373	163	9	98	2	5	166	1180181	1180020	Deinococcus proteolyticus MRP, complete genome	blastn	163	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
23274860	23274860	PRJNA1195551_S_NODE_43839_length_154_cov_3.400000_g43486_i0	PRJNA1195551	43839	154	3.4	5.236	Deinococcus yunweiensis	367282	Bacteria	Bacteria	202	1.19e-47	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g43486	i0	90.385	38.0064935064935	156	11	100	4	1	154	2671088	2670935	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	5853	202	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis

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