metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA770826" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA770826" 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
746943	746943	PRJNA770826_P_NODE_43681_length_162_cov_0.920354_g43510_i0	PRJNA770826	43681	162	0.920354	1.49097348	Trueperaceae bacterium	2026798	Bacteria	Bacteria	239	9.64e-59	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g43510	i0	93.21	407.493827160494	162	11	100	0	1	162	2559566	2559405	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	66014	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
3298129	3298129	PRJNA770826_P_NODE_39483_length_163_cov_0.912281_g39312_i0	PRJNA770826	39483	163	0.912281	1.48701803	Trueperaceae bacterium	2026798	Bacteria	Bacteria	196	5.93e-46	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g39312	i0	88.344	264.20245398773	163	19	100	0	1	163	9390	9552	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	43065	196	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
4575115	4575115	PRJNA770826_P_NODE_13244_length_221_cov_1.279070_g13073_i0	PRJNA770826	13244	221	1.27907	2.8267447	Trueperaceae bacterium	2026798	Bacteria	Bacteria	359	1.03e-94	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g13073	i0	95.928	303.638009049774	221	9	100	0	1	221	3601170	3600950	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	67104	359	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
7125617	7125617	PRJNA770826_P_NODE_25246_length_168_cov_2.184874_g25075_i0	PRJNA770826	25246	168	2.184874	3.67058832	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	239	1.01e-58	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g25075	i0	92.262	49.4821428571429	168	13	100	0	1	168	545162	545329	Deinococcus sp. NW-56 chromosome, complete genome	blastn	8313	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
8859879	8859879	PRJNA770826_P_NODE_20547_length_178_cov_7.170543_g20376_i0	PRJNA770826	20547	178	7.170543	12.76356654	Thermotoga	2335	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|752579342\|gb\|CP007633.1\|	126738	g20376	i0	100	0.337078651685393	30	0	17	0	39	68	273020	273049	Thermotoga sp. RQ7, complete genome	blastn	60	56.5	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga sp. RQ7
10135321	10135321	PRJNA770826_P_NODE_9548_length_261_cov_2.339623_g9377_i0	PRJNA770826	9548	261	2.339623	6.10641603	Deinococcus	1298	Bacteria	Bacteria	344	3.51e-90	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g9377	i0	90.421	188.919540229885	261	25	100	0	1	261	544552	544292	Deinococcus sp. NW-56 chromosome, complete genome	blastn	49308	346	0.994219653179191	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
13500653	13500653	PRJNA770826_P_NODE_291_length_1365_cov_2.415653_g235_i0	PRJNA770826	291	1365	2.415653	32.97366345	Deinococcus grandis	57498	Bacteria	Bacteria	1882	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g235	i0	91.63	246.16043956044	1374	95	100	18	1	1365	423374	424736	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	336009	1882	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
18598613	18598613	PRJNA770826_P_NODE_19255_length_184_cov_2.622222_g19084_i0	PRJNA770826	19255	184	2.622222	4.82488848	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	233	5.22e-57	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g19084	i0	89.785	144.826086956522	186	13	100	6	1	184	543317	543136	Deinococcus sp. NW-56 chromosome, complete genome	blastn	26648	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
22884422	22884422	PRJNA770826_P_NODE_2638_length_535_cov_1.965021_g2469_i0	PRJNA770826	2638	535	1.965021	10.51286235	Deinococcus	1298	Bacteria	Bacteria	686	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g2469	i0	91.27	198.566355140187	504	42	99	2	1	502	2342490	2341987	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	106233	691	0.992764109985528	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
25433355	25433355	PRJNA770826_P_NODE_10240_length_252_cov_1.280788_g10069_i0	PRJNA770826	10240	252	1.280788	3.22758576	Truepera	332248	Bacteria	Bacteria	411	3.269999999999999e-110	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g10069	i0	96.386	184.761904761905	249	9	99	0	1	249	1855	2103	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	46560	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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