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

10 rows where analysis = "blastn", bioproject = "PRJNA1004255" 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
2276105	2276105	PRJNA1004255_S_NODE_3802_length_288_cov_8.844898_g3594_i0	PRJNA1004255	3802	288	8.844898	25.47330624	Truepera	332248	Bacteria	Bacteria	274	5.22e-69	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g3594	i0	92.632	380.239583333333	190	14	66	0	1	190	762059	762248	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	109509	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
4828971	4828971	PRJNA1004255_S_NODE_10264_length_199_cov_2.660256_g10056_i0	PRJNA1004255	10264	199	2.660256	5.29390944	Deinococcus	1298	Bacteria	Bacteria	318	1.54e-82	NTclustered	gi\|2304456361\|gb\|CP104213.1\|	1889240	g10056	i0	96.373	205.497487437186	193	7	97	0	1	193	319460	319652	Deinococcus rubellus strain Ant6 chromosome, complete genome	blastn	40894	318	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus rubellus
4828986	4828986	PRJNA1004255_S_NODE_18404_length_152_cov_1.724771_g18196_i0	PRJNA1004255	18404	152	1.724771	2.62165192	Deinococcus	1298	Bacteria	Bacteria	259	6.82e-65	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g18196	i0	97.368	15	152	4	100	0	1	152	2361272	2361121	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	2280	259	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
5256134	5256134	PRJNA1004255_S_NODE_12585_length_181_cov_10.289855_g12377_i0	PRJNA1004255	12585	181	10.289855	18.62463755	Trueperaceae bacterium	2026798	Bacteria	Bacteria	243	8.5e-60	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g12377	i0	93.293	243.458563535912	164	11	91	0	18	181	2559565	2559402	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	44066	243	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
11204301	11204301	PRJNA1004255_S_NODE_8729_length_213_cov_2.152941_g8521_i0	PRJNA1004255	8729	213	2.152941	4.58576433	Deinococcus	1298	Bacteria	Bacteria	388	1.26e-103	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g8521	i0	99.531	30.2488262910798	213	1	100	0	1	213	2585575	2585787	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	6443	388	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
11631819	11631819	PRJNA1004255_S_NODE_3850_length_287_cov_4.967213_g3642_i0	PRJNA1004255	3850	287	4.967213	14.25590131	Deinococcus radiomollis	468916	Bacteria	Bacteria	486	6.139999999999999e-133	NTclustered	gi\|2865409981\|gb\|CP129906.1\|	468916	g3642	i0	97.213	172.142857142857	287	8	100	0	1	287	1002745	1002459	Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome	blastn	49405	486	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
12479798	12479798	PRJNA1004255_S_NODE_13830_length_174_cov_3.496183_g13622_i0	PRJNA1004255	13830	174	3.496183	6.08335842	root	1	Root_unresolved	Root_unresolved	265	1.73e-66	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g13622	i0	100	111.672413793103	143	0	82	0	1	143	920055	920197	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	19431	265	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
12479833	12479833	PRJNA1004255_S_NODE_9670_length_204_cov_3.049689_g9462_i0	PRJNA1004255	9670	204	3.049689	6.22136556	Deinococcus	1298	Bacteria	Bacteria	311	2.66e-80	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g9462	i0	94.118	15.0049019607843	204	12	100	0	1	204	517586	517383	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	3061	311	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
13754410	13754410	PRJNA1004255_S_NODE_7911_length_222_cov_2.100559_g7703_i0	PRJNA1004255	7911	222	2.100559	4.66324098	Pyramidobacter	638847	Bacteria	Bacteria	259	1.08e-64	NTclustered	gi\|167996909\|gb\|EU379932.1\|	352165	g7703	i0	87.838	58.0225225225225	222	25	100	2	1	222	2638	2419	Synergistes sp. W5455 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, 23S ribosomal RNA gene, 23S-5S ribosomal RNA intergenic spacer, and 5S ribosomal RNA gene, complete sequence	blastn	12881	259	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
16303499	16303499	PRJNA1004255_S_NODE_6153_length_244_cov_3.432836_g5945_i0	PRJNA1004255	6153	244	3.432836	8.37611984	Truepera	332248	Bacteria	Bacteria	270	5.58e-68	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g5945	i0	86.777	49.0409836065574	242	32	99	0	1	242	451	210	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	11966	270	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);;