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

8 rows where analysis = "blastn", bioproject = "PRJNA906294" 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
4718459	4718459	PRJNA906294_P_NODE_93884_length_436_cov_1.374656_g89770_i0	PRJNA906294	93884	436	1.374656	5.99350016	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	534	3.43e-147	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g89770	i0	89.016	272.080275229358	437	40	99	8	2	435	543557	543126	Deinococcus sp. NW-56 chromosome, complete genome	blastn	118627	534	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
5076812	5076812	PRJNA906294_P_NODE_207584_length_249_cov_0.875000_g203468_i0	PRJNA906294	207584	249	0.875	2.17875	Deinococcus	1298	Bacteria	Bacteria	420	5.36e-113	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g203468	i0	97.177	1.99196787148594	248	7	99	0	2	249	2162648	2162401	Deinococcus swuensis strain DY59, complete genome	blastn	496	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
5076905	5076905	PRJNA906294_P_NODE_229184_length_241_cov_2.375000_g225068_i0	PRJNA906294	229184	241	2.375	5.72375	Deinococcus	1298	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g225068	i0	100	34.5145228215768	241	0	100	0	1	241	1430274	1430514	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	8318	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
5077060	5077060	PRJNA906294_P_NODE_63064_length_591_cov_2.704633_g58987_i0	PRJNA906294	63064	591	2.704633	15.98438103	Truepera	332248	Bacteria	Bacteria	409	3.01e-109	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g58987	i0	88.69	82.9830795262267	336	37	98	1	1	335	1503	1838	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	49043	409	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
15276744	15276744	PRJNA906294_P_NODE_54472_length_661_cov_2.564626_g50442_i0	PRJNA906294	54472	661	2.564626	16.95217786	Truepera	332248	Bacteria	Bacteria	900	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g50442	i0	91.796	482.32223903177	646	53	98	0	1	646	552	1197	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	318815	900	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
16190361	16190361	PRJNA906294_P_NODE_197733_length_257_cov_2.239130_g193617_i0	PRJNA906294	197733	257	2.23913	5.7545641	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	444	3.299999999999998e-120	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g193617	i0	98.054	190.066147859922	257	2	99	3	3	257	544576	544321	Deinococcus sp. NW-56 chromosome, complete genome	blastn	48847	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
20375178	20375178	PRJNA906294_P_NODE_67836_length_559_cov_3.954733_g63742_i0	PRJNA906294	67836	559	3.954733	22.10695747	Deinococcus	1298	Bacteria	Bacteria	1027	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g63742	i0	99.821	366.150268336315	559	1	100	0	1	559	2148306	2147748	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	204678	1027	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
21289684	21289684	PRJNA906294_P_NODE_204937_length_251_cov_0.865169_g200821_i0	PRJNA906294	204937	251	0.865169	2.17157419	Trueperaceae bacterium	2026798	Bacteria	Bacteria	313	9.45e-81	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g200821	i0	89.2	10.1155378486056	250	27	99	0	2	251	6985	6736	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	2539	313	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);;