metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA753704" 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
4559658	4559658	PRJNA753704_P_NODE_844_length_1158_cov_12.323502_g613_i0	PRJNA753704	844	1158	12.323502	142.70615316	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	2008	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g613	i0	98.017	206.022452504318	1160	16	100	7	1	1158	74997	73843	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	238574	2008	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
7109730	7109730	PRJNA753704_P_NODE_19606_length_274_cov_2.139303_g19245_i0	PRJNA753704	19606	274	2.139303	5.86169022	Deinococcus grandis	57498	Bacteria	Bacteria	472	1.63e-128	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g19245	i0	97.802	35.3503649635037	273	6	99	0	1	273	426825	426553	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	9686	472	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
10935076	10935076	PRJNA753704_P_NODE_21689_length_262_cov_1.693122_g21328_i0	PRJNA753704	21689	262	1.693122	4.43597964	Deinococcus geothermalis	68909	Bacteria	Bacteria	207	4.8200000000000004e-49	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g21328	i0	81.6	10.2977099236641	250	46	95	0	1	250	1295031	1294782	Deinococcus geothermalis DSM 11300, complete genome	blastn	2698	207	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
13484975	13484975	PRJNA753704_P_NODE_5951_length_470_cov_5.559194_g5590_i0	PRJNA753704	5951	470	5.559194	26.1282118	Meiothermus taiwanensis	172827	Bacteria	Bacteria	486	1.0599999999999998e-132	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g5590	i0	85.412	120.878723404255	473	64	100	5	1	470	258590	258120	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	56813	486	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
13955964	13955964	PRJNA753704_P_NODE_14011_length_319_cov_1.658537_g13650_i0	PRJNA753704	14011	319	1.658537	5.29073303	root	1	Root_unresolved	Root_unresolved	93.5	1.76e-14	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g13650	i0	91.429	6.06896551724138	70	3	21	3	1	68	2141053	2141121	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	1936	93.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
13956034	13956034	PRJNA753704_P_NODE_2511_length_693_cov_4.069355_g2169_i0	PRJNA753704	2511	693	4.069355	28.20063015	Meiothermus	65551	Bacteria	Bacteria	902	0	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g2169	i0	90.202	149.163059163059	694	65	100	3	1	693	945	1636	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	103370	902	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
17309153	17309153	PRJNA753704_P_NODE_20114_length_271_cov_1.787879_g19753_i0	PRJNA753704	20114	271	1.787879	4.84515209	Deinococcus peraridilitoris	432329	Bacteria	Bacteria	224	4.979999999999999e-54	NTclustered	gi\|429128598\|gb\|CP003382.1\|	937777	g19753	i0	84.716	50.2066420664207	229	30	84	4	1	228	3328583	3328359	Deinococcus peraridilitoris DSM 19664, complete genome	blastn	13606	224	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
17309201	17309201	PRJNA753704_P_NODE_24114_length_251_cov_3.820225_g23753_i0	PRJNA753704	24114	251	3.820225	9.58876475	Meiothermus taiwanensis	172827	Bacteria	Bacteria	303	5.69e-78	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g23753	i0	89.3	362.494023904382	243	25	97	1	1	243	258934	258693	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	90986	303	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
24957598	24957598	PRJNA753704_P_NODE_21880_length_261_cov_1.659574_g21519_i0	PRJNA753704	21880	261	1.659574	4.33148814	Allomeiothermus silvanus	52022	Bacteria	Bacteria	414	2.63e-111	NTclustered	gi\|296852006\|gb\|CP002043.1\|	526227	g21519	i0	96.063	0.973180076628352	254	10	97	0	8	261	340200	340453	Meiothermus silvanus DSM 9946 plasmid pMESIL01, complete sequence	blastn	254	414	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus

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