metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA599208" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA599208" 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
3692939	3692939	PRJNA599208_P_NODE_2763_length_533_cov_149.358871_g2576_i0	PRJNA599208	2763	533	149.358871	796.08278243	Truepera	332248	Bacteria	Bacteria	689	0	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g2576	i0	90.44	394.786116322702	523	50	98	0	8	530	762248	761726	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	210421	689	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
3692993	3692993	PRJNA599208_P_NODE_9123_length_231_cov_3.020619_g8927_i0	PRJNA599208	9123	231	3.020619	6.97762989	Thermus	270	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g8927	i0	100	142.34632034632	231	0	100	0	1	231	13281	13051	Thermus thermophilus TF27 DNA, complete genome	blastn	32882	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
4399986	4399986	PRJNA599208_P_NODE_9104_length_231_cov_13.046392_g8908_i0	PRJNA599208	9104	231	13.046392	30.13716552	Deinococcus geothermalis	68909	Bacteria	Bacteria	363	8.4e-96	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g8908	i0	95.614	188.199134199134	228	7	98	3	6	231	2013466	2013692	Deinococcus geothermalis DSM 11300, complete genome	blastn	43474	363	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
10070053	10070053	PRJNA599208_P_NODE_288_length_2033_cov_18.841683_g173_i1	PRJNA599208	288	2033	18.841683	383.05141539	Truepera	332248	Bacteria	Bacteria	2115	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g173	i1	87.281	371.267584849975	1887	197	91	31	179	2033	171	2046	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	754787	2115	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
10070068	10070068	PRJNA599208_P_NODE_4508_length_388_cov_1.991453_g4313_i0	PRJNA599208	4508	388	1.991453	7.72683764	Thermus	270	Bacteria	Bacteria	682	0	NTclustered	gi\|1955386990\|dbj\|AP024305.1\|	274	g4313	i0	98.454	143.868556701031	388	4	100	2	1	388	352880	353265	Thermus thermophilus HB5008 DNA, complete genome	blastn	55821	682	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
15874918	15874918	PRJNA599208_P_NODE_1253_length_869_cov_15.197115_g1139_i0	PRJNA599208	1253	869	15.197115	132.06292935	Deinococcus geothermalis	68909	Bacteria	Bacteria	1561	0	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g1139	i0	99.306	228.937859608746	864	5	99	1	6	868	326014	326877	Deinococcus geothermalis DSM 11300, complete genome	blastn	198947	1561	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
19698833	19698833	PRJNA599208_P_NODE_8476_length_244_cov_14.599034_g8280_i0	PRJNA599208	8476	244	14.599034	35.62164296	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g8280	i0	99.59	269.831967213115	244	1	100	0	1	244	201288	201531	Deinococcus sp. AJ005 chromosome, complete genome	blastn	65839	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005

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