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

13 rows where analysis = "blastn", bioproject = "PRJNA846086" 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
832882	832882	PRJNA846086_P_NODE_221_length_833_cov_2.605263_g166_i0	PRJNA846086	221	833	2.605263	21.70184079	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	1168	0	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g166	i0	92.188	573.501800720288	832	56	99	8	8	833	68618	69446	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	477727	1168	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
832913	832913	PRJNA846086_P_NODE_4181_length_246_cov_2.352601_g4115_i0	PRJNA846086	4181	246	2.352601	5.78739846	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	324	4.26e-84	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g4115	i0	90.65	535.439024390244	246	20	99	3	3	246	67852	68096	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	131718	324	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
5936076	5936076	PRJNA846086_P_NODE_5225_length_242_cov_0.911243_g5159_i0	PRJNA846086	5225	242	0.911243	2.20520806	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	283	7.1e-72	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g5159	i0	87.917	1.98347107438017	240	29	99	0	3	242	1101004	1100765	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	480	283	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
12311983	12311983	PRJNA846086_P_NODE_1010_length_366_cov_1.576792_g944_i0	PRJNA846086	1010	366	1.576792	5.77105872	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	671	0	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g944	i0	99.727	213.18306010929	366	1	100	0	1	366	1637230	1637595	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	78025	671	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
13586486	13586486	PRJNA846086_P_NODE_2251_length_273_cov_1.815000_g2185_i0	PRJNA846086	2251	273	1.815	4.95495	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	272	1.77e-68	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g2185	i0	84.871	59.6703296703297	271	39	99	2	4	273	69841	70110	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	16290	272	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
13586520	13586520	PRJNA846086_P_NODE_4231_length_246_cov_0.890173_g4165_i0	PRJNA846086	4231	246	0.890173	2.18982558	Deinococcus aquaticus	328692	Bacteria	Bacteria	283	7.239999999999999e-72	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g4165	i0	87.449	2.1260162601626	247	29	100	2	1	246	2676319	2676564	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	523	283	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
14860758	14860758	PRJNA846086_P_NODE_2792_length_258_cov_1.351351_g2726_i0	PRJNA846086	2792	258	1.351351	3.48648558	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g2726	i0	100	2	258	0	100	0	1	258	399432	399175	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	516	477	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
15259220	15259220	PRJNA846086_P_NODE_4652_length_245_cov_0.895349_g4586_i0	PRJNA846086	4652	245	0.895349	2.19360505	Fervidobacterium	2422	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1829530204\|gb\|CP050868.1\|	3022686	g4586	i0	98.776	7.88979591836735	245	3	100	0	1	245	171553	171309	Fervidobacterium pennivorans subsp. keratinolyticus strain T chromosome, complete genome	blastn	1933	436	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
16135622	16135622	PRJNA846086_P_NODE_733_length_432_cov_1.334262_g667_i0	PRJNA846086	733	432	1.334262	5.76401184	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	481	4.49e-131	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g667	i0	86.946	45.7222222222222	429	54	99	2	1	428	69475	69902	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	19752	481	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
18684178	18684178	PRJNA846086_P_NODE_5615_length_241_cov_0.916667_g5549_i0	PRJNA846086	5615	241	0.916667	2.20916747	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	364	2.4499999999999993e-96	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g5549	i0	94.492	1.95850622406639	236	13	98	0	6	241	50422	50187	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	472	364	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
20357549	20357549	PRJNA846086_P_NODE_1816_length_287_cov_1.598131_g1750_i0	PRJNA846086	1816	287	1.598131	4.58663597	Deinococcus	1298	Bacteria	Bacteria	520	6.049999999999999e-143	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g1750	i0	99.303	182.344947735192	287	2	100	0	1	287	74285	74571	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	52333	525	0.990476190476191	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
24182823	24182823	PRJNA846086_P_NODE_4459_length_245_cov_0.895349_g4393_i0	PRJNA846086	4459	245	0.895349	2.19360505	Deinococcus	1298	Bacteria	Bacteria	174	4.52e-39	NTclustered	gi\|2706840606\|gb\|CP149783.1\|	3112952	g4393	i0	79.592	10.8571428571429	245	48	99	2	2	245	335379	335136	Deinococcus sp. VB142 chromosome 2, complete sequence	blastn	2660	174	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
24182829	24182829	PRJNA846086_P_NODE_5159_length_243_cov_0.870588_g5093_i0	PRJNA846086	5159	243	0.870588	2.11552884	Deinococcus	1298	Bacteria	Bacteria	316	7.03e-82	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g5093	i0	90.535	210.59670781893	243	17	99	6	1	238	2671897	2672138	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	51175	316	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis

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