metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA846110" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA846110" 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
833143	833143	PRJNA846110_P_NODE_28481_length_243_cov_0.905882_g28236_i0	PRJNA846110	28481	243	0.905882	2.20129326	Deinococcus geothermalis	68909	Bacteria	Bacteria	405	1.46e-108	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g28236	i0	97.083	0.987654320987654	240	7	99	0	4	243	1990909	1990670	Deinococcus geothermalis DSM 11300, complete genome	blastn	240	405	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
6335432	6335432	PRJNA846110_P_NODE_8525_length_362_cov_3.491349_g8281_i0	PRJNA846110	8525	362	3.491349	12.63868338	Deinococcus	1298	Bacteria	Bacteria	665	0	NTclustered	gi\|3093386\|emb\|AJ000002.1\|	68909	g8281	i0	100	103.096685082873	360	0	99	0	1	360	12	371	Deinococcus geothermalis 16S rRNA gene, strain E50053	blastn	37321	665	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
7211234	7211234	PRJNA846110_P_NODE_27466_length_245_cov_0.860465_g27221_i0	PRJNA846110	27466	245	0.860465	2.10813925	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	420	5.26e-113	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g27221	i0	97.551	34.7959183673469	245	6	100	0	1	245	2737956	2737712	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	8525	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
9761035	9761035	PRJNA846110_P_NODE_17368_length_276_cov_1.364532_g17123_i0	PRJNA846110	17368	276	1.364532	3.76610832	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	483	7.589999999999998e-132	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g17123	i0	98.188	26.7934782608696	276	5	100	0	1	276	867116	866841	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	7395	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
19082860	19082860	PRJNA846110_P_NODE_235_length_1817_cov_3.721904_g179_i0	PRJNA846110	235	1817	3.721904	67.62699568	Deinococcus	1298	Bacteria	Bacteria	3339	0	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g179	i0	99.835	219.946615299945	1817	3	100	0	1	1817	9	1825	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	399643	3345	0.998206278026906	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
19082891	19082891	PRJNA846110_P_NODE_28575_length_243_cov_0.905882_g28330_i0	PRJNA846110	28575	243	0.905882	2.20129326	root	1	Root_unresolved	Root_unresolved	449	6.65e-122	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g28330	i0	100	61.5802469135802	243	0	100	0	1	243	2123	1881	Thermus aquaticus DNA polymerase (PolI) gene	blastn	14964	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
25059129	25059129	PRJNA846110_P_NODE_12740_length_307_cov_0.863248_g12495_i0	PRJNA846110	12740	307	0.863248	2.65017136	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	508	1.41e-139	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g12495	i0	97.324	213.332247557003	299	8	97	0	1	299	544913	544615	Deinococcus sp. NW-56 chromosome, complete genome	blastn	65493	508	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
25457991	25457991	PRJNA846110_P_NODE_9280_length_350_cov_1.093863_g9036_i0	PRJNA846110	9280	350	1.093863	3.8285205	Deinococcus	1298	Bacteria	Bacteria	551	2.669999999999999e-152	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g9036	i0	95.143	202.32	350	16	100	1	1	350	73113	72765	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	70812	553	0.996383363471971	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);;