metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1132896" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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
2307109	2307109	PRJNA1132896_P_NODE_4382_length_283_cov_2.766667_g4291_i0	PRJNA1132896	4382	283	2.766667	7.8296676100000004	Deinococcus	1298	Bacteria	Bacteria	520	5.96e-143	NTclustered	gi\|105990360\|gb\|DQ514091.1\|	158789	g4291	i0	100	99.3003533568905	281	0	99	0	3	283	363	83	Uncultured Deinococcus sp. clone 100M2_A8 16S ribosomal RNA gene, partial sequence	blastn	28102	520	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
7409670	7409670	PRJNA1132896_P_NODE_3666_length_297_cov_1.026786_g3575_i0	PRJNA1132896	3666	297	1.026786	3.04955442	Deinococcus	1298	Bacteria	Bacteria	505	1.7599999999999995e-138	NTclustered	gi\|2549460888\|gb\|OR304356.1\|	32062	g3575	i0	97.306	101.835016835017	297	8	100	0	1	297	797	501	Deinococcus radiophilus strain LMITABS01070 16S ribosomal RNA gene, partial sequence	blastn	30245	505	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
15586557	15586557	PRJNA1132896_P_NODE_6953_length_251_cov_0.865169_g6862_i0	PRJNA1132896	6953	251	0.865169	2.17157419	Deinococcus taeanensis	2737050	Bacteria	Bacteria	307	4.4e-79	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g6862	i0	88.976	161.298804780876	254	21	100	7	1	251	1481	1730	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	40486	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
16334202	16334202	PRJNA1132896_P_NODE_8033_length_247_cov_1.770115_g7942_i0	PRJNA1132896	8033	247	1.770115	4.37218405	Truepera	332248	Bacteria	Bacteria	324	4.2799999999999995e-84	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g7942	i0	90.283	401.323886639676	247	24	100	0	1	247	525	771	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	99127	324	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
21960399	21960399	PRJNA1132896_P_NODE_3618_length_298_cov_3.048889_g3527_i0	PRJNA1132896	3618	298	3.048889	9.08568922	Trueperaceae bacterium	2026798	Bacteria	Bacteria	375	1.4499999999999995e-99	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g3527	i0	89.439	480.953020134228	303	25	99	2	3	298	3601123	3600821	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	143324	375	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
24509606	24509606	PRJNA1132896_P_NODE_7780_length_248_cov_0.880000_g7689_i0	PRJNA1132896	7780	248	0.88	2.1824	Trueperaceae bacterium	2026798	Bacteria	Bacteria	398	2.5e-106	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g7689	i0	95.565	181.375	248	11	100	0	1	248	2560637	2560390	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	44981	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
24509620	24509620	PRJNA1132896_P_NODE_900_length_545_cov_1.099576_g809_i0	PRJNA1132896	900	545	1.099576	5.9926892	Deinococcus altitudinis	468914	Bacteria	Bacteria	905	0	NTclustered	gi\|2865404944\|gb\|CP129415.1\|	468914	g809	i0	96.709	410.911926605505	547	12	99	6	1	544	413432	413975	Deinococcus altitudinis strain LMG 24022 chromosome, complete genome	blastn	223947	905	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis

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