metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA255848" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA255848" 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
368705	368705	PRJNA255848_P_NODE_42381_length_164_cov_0.886957_g42063_i0	PRJNA255848	42381	164	0.886957	1.45460948	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	302	1.23e-77	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g42063	i0	100	0.99390243902439	163	0	99	0	2	164	62237	62399	Thermus sp. NEB1569 chromosome, complete genome	blastn	163	302	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
3607568	3607568	PRJNA255848_P_NODE_6423_length_431_cov_2.903141_g6105_i0	PRJNA255848	6423	431	2.903141	12.51253771	Deinococcus	1298	Bacteria	Bacteria	785	0	NTclustered	gi\|2425458098\|gb\|OQ221948.1\|	47478	g6105	i0	99.536	109.816705336427	431	2	100	0	1	431	418	848	Deinococcus sp. strain 934 16S ribosomal RNA gene, partial sequence	blastn	47331	785	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
4195823	4195823	PRJNA255848_P_NODE_35344_length_167_cov_0.864407_g35026_i0	PRJNA255848	35344	167	0.864407	1.44355969	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	307	2.71e-79	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g35026	i0	100	56.5508982035928	166	0	99	0	2	167	459913	460078	Thermus sp. NEB1569 chromosome, complete genome	blastn	9444	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
7434972	7434972	PRJNA255848_P_NODE_47586_length_161_cov_0.910714_g47268_i0	PRJNA255848	47586	161	0.910714	1.46624954	Deinococcus	1298	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|83699285\|dbj\|AB244334.1\|	362240	g47268	i0	100	106.391304347826	161	0	100	0	1	161	257	97	Deinococcus sp. DaeR-4 gene for 16S rRNA, partial sequence	blastn	17129	298	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. DaeR-4
13122502	13122502	PRJNA255848_P_NODE_36131_length_167_cov_0.864407_g35813_i0	PRJNA255848	36131	167	0.864407	1.44355969	Allomeiothermus silvanus	52022	Bacteria	Bacteria	89.8	1.07e-13	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g35813	i0	86.42	0.48502994011976	81	11	49	0	87	167	2427526	2427446	Meiothermus silvanus DSM 9946, complete genome	blastn	81	89.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
13810408	13810408	PRJNA255848_P_NODE_32291_length_175_cov_1.047619_g31973_i0	PRJNA255848	32291	175	1.047619	1.83333325	Deinococcus	1298	Bacteria	Bacteria	261	2.25e-65	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g31973	i0	94.643	180.982857142857	168	9	96	0	1	168	69618	69785	Deinococcus puniceus strain DY1, complete genome	blastn	31672	261	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
14397795	14397795	PRJNA255848_P_NODE_5892_length_454_cov_2.340741_g5574_i0	PRJNA255848	5892	454	2.340741	10.62696414	Deinococcus ficus	317577	Bacteria	Bacteria	784	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g5574	i0	98.009	195.114537444934	452	7	99	2	4	454	2341710	2341260	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	88582	784	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
15084361	15084361	PRJNA255848_P_NODE_12132_length_292_cov_3.000000_g11814_i0	PRJNA255848	12132	292	3	8.76	Deinococcus	1298	Bacteria	Bacteria	540	4.74e-149	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g11814	i0	100	98.1335616438356	292	0	100	0	1	292	26386	26095	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	28655	540	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
18220296	18220296	PRJNA255848_P_NODE_14315_length_265_cov_1.532407_g13997_i0	PRJNA255848	14315	265	1.532407	4.06087855	Deinococcus ficus	317577	Bacteria	Bacteria	473	4.3599999999999987e-129	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g13997	i0	98.872	181.690566037736	266	2	100	1	1	265	2340938	2340673	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	48148	473	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
18220405	18220405	PRJNA255848_P_NODE_42895_length_163_cov_0.894737_g42577_i0	PRJNA255848	42895	163	0.894737	1.45842131	Allomeiothermus silvanus	52022	Bacteria	Bacteria	268	1.24e-67	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g42577	i0	96.319	1	163	6	100	0	1	163	335894	336056	Meiothermus silvanus DSM 9946, complete genome	blastn	163	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
20183105	20183105	PRJNA255848_P_NODE_46436_length_161_cov_1.821429_g46118_i0	PRJNA255848	46436	161	1.821429	2.93250069	Thermus	270	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2440484278\|gb\|CP046617.1\|	88190	g46118	i0	100	9.54658385093168	161	0	100	0	1	161	858922	859082	Thermus antranikianii strain JCM 19900 chromosome, complete genome	blastn	1537	298	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
22045363	22045363	PRJNA255848_P_NODE_5518_length_471_cov_1.618483_g5203_i0	PRJNA255848	5518	471	1.618483	7.62305493	Deinococcus ficus	317577	Bacteria	Bacteria	821	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g5203	i0	98.701	248.662420382166	462	6	98	0	10	471	2342728	2342267	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	117120	821	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
25282950	25282950	PRJNA255848_P_NODE_15240_length_256_cov_2.077295_g14922_i0	PRJNA255848	15240	256	2.077295	5.3178752	Deinococcus	1298	Bacteria	Bacteria	446	9.139999999999999e-121	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g14922	i0	98.054	306.84375	257	4	100	1	1	256	916	1172	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	78552	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti

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