metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1253698" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1253698" 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
359614	359614	PRJNA1253698_S_NODE_9001_length_229_cov_6.311111_g8635_i0	PRJNA1253698	9001	229	6.311111	14.45244419	uncultured Deinococcales bacterium	310703	Bacteria	Bacteria	377	2.97e-100	NTclustered	gi\|336109605\|gb\|JN020214.1\|	310703	g8635	i0	98.148	81.9563318777293	216	4	94	0	14	229	1443	1228	Uncultured Deinococcales bacterium clone cher8_1B_2 small subunit ribosomal RNA gene, partial sequence	blastn	18768	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales			uncultured Deinococcales bacterium
1634459	1634459	PRJNA1253698_S_NODE_4462_length_329_cov_7.010714_g4096_i0	PRJNA1253698	4462	329	7.010714	23.06524906	Deinococcus sp. 35	457576	Bacteria	Bacteria	568	2.4899999999999995e-157	NTclustered	gi\|154268058\|gb\|EU024697.1\|	457576	g4096	i0	99.051	132.665653495441	316	3	96	0	4	319	715	400	Deinococcus sp. 35 16S ribosomal RNA gene, partial sequence	blastn	43647	568	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. 35
5463005	5463005	PRJNA1253698_S_NODE_24505_length_153_cov_5.346154_g24139_i0	PRJNA1253698	24505	153	5.346154	8.17961562	Trueperaceae bacterium	2026798	Bacteria	Bacteria	219	1.1699999999999999e-52	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g24139	i0	93.793	270.457516339869	145	9	95	0	9	153	9426	9570	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	41380	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
11256108	11256108	PRJNA1253698_S_NODE_3329_length_382_cov_4.324324_g2964_i0	PRJNA1253698	3329	382	4.324324	16.51891768	Truepera	332248	Bacteria	Bacteria	608	1.719999999999999e-169	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g2964	i0	95.312	200.609947643979	384	16	100	1	1	382	1796	2179	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	76633	608	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
24004856	24004856	PRJNA1253698_S_NODE_7059_length_258_cov_3.837321_g6693_i0	PRJNA1253698	7059	258	3.837321	9.90028818	Deinococcus	1298	Bacteria	Bacteria	303	5.87e-78	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g6693	i0	88.98	126.03488372093	245	27	95	0	14	258	296	52	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	32517	303	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis

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