metadata: contig_metadata: 6 rows where bioproject = "PRJNA1167252", tax_kingdom = "Thermotogati" and tax

6 rows where bioproject = "PRJNA1167252", tax_kingdom = "Thermotogati" and tax_phylum = "Deinococcota"

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
9967883	9967883	PRJNA1167252_P_NODE_14268_length_325_cov_2.126984_g13995_i0	PRJNA1167252	14268	325	2.126984	6.912698	Truepera	332248	Bacteria	Bacteria	252	2.81e-62	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g13995	i0	80.781	834.295384615385	333	54	100	8	1	325	177	507	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	271146	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
13067970	13067970	PRJNA1167252_P_NODE_17031_length_296_cov_1.008969_g16758_i0	PRJNA1167252	17031	296	1.008969	2.98654824	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	536	6.2199999999999986e-148	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g16758	i0	99.324	197.456081081081	296	2	100	0	1	296	57563	57268	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	58447	536	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
14343842	14343842	PRJNA1167252_P_NODE_8412_length_439_cov_2.144809_g8139_i0	PRJNA1167252	8412	439	2.144809	9.41571151	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	811	0	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g8139	i0	100	199.321184510251	439	0	100	0	1	439	58230	57792	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	87502	811	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
16342414	16342414	PRJNA1167252_P_NODE_21633_length_260_cov_1.251337_g21360_i0	PRJNA1167252	21633	260	1.251337	3.2534762	Truepera	332248	Bacteria	Bacteria	346	9.71e-91	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g21360	i0	90.53	114.457692307692	264	21	100	3	1	260	1830	1567	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	29759	346	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
31450306	31450306	PRJNA1167252_P_NODE_24696_length_250_cov_0.881356_g24423_i0	PRJNA1167252	24696	250	0.881356	2.20339	Thermaceae	188786	Bacteria	Bacteria	119	3.5499999999999996e-30	NR	WP_027877899.1	65552	g24423	i0	63.9	2.988	83	30	99.6	0	1	249	62	144	WP_027877899.1 glucose-1-phosphate thymidylyltransferase [Meiothermus cerbereus]	diamond	747	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus cerbereus
32853162	32853162	PRJNA1167252_P_NODE_26340_length_247_cov_0.896552_g26067_i0	PRJNA1167252	26340	247	0.896552	2.21448344	Trueperaceae bacterium	2026798	Bacteria	Bacteria	112	5.440000000000001e-27	NR	MBW6454337.1	2026798	g26067	i0	64.2	0.983805668016194	81	29	98.4	0	245	3	113	193	MBW6454337.1 hypothetical protein [Trueperaceae bacterium]	diamond	243	112	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium

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