metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1158727" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1158727" 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
7415286	7415286	PRJNA1158727_P_NODE_114406_length_274_cov_1.348259_g106945_i0	PRJNA1158727	114406	274	1.348259	3.69422966	Thermus	270	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g106945	i0	100	45.3029197080292	274	0	100	0	1	274	156859	157132	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	12413	507	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
7415728	7415728	PRJNA1158727_P_NODE_91426_length_310_cov_2.493671_g83965_i0	PRJNA1158727	91426	310	2.493671	7.7303801	Deinococcus	1298	Bacteria	Bacteria	228	4.4799999999999984e-55	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g83965	i0	94	2.91612903225806	150	9	48	0	1	150	811451	811302	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	904	228	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
7957002	7957002	PRJNA1158727_P_NODE_135447_length_251_cov_0.865169_g127985_i0	PRJNA1158727	135447	251	0.865169	2.17157419	Allomeiothermus silvanus	52022	Bacteria	Bacteria	449	6.899999999999999e-122	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g127985	i0	99.197	0.99203187250996006	249	2	99	0	3	251	2132684	2132436	Meiothermus silvanus DSM 9946, complete genome	blastn	249	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
7957034	7957034	PRJNA1158727_P_NODE_137027_length_250_cov_1.740113_g129565_i0	PRJNA1158727	137027	250	1.740113	4.3502825	Deinococcus radiophilus	32062	Bacteria	Bacteria	294	3.41e-75	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g129565	i0	91.244	5.028	217	17	86	2	35	250	601343	601128	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	1257	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
15607255	15607255	PRJNA1158727_P_NODE_165893_length_233_cov_2.337500_g158431_i0	PRJNA1158727	165893	233	2.3375	5.446375	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	425	1.07e-114	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g158431	i0	99.571	14.0085836909871	233	1	100	0	1	233	2705114	2704882	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	3264	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
17615509	17615509	PRJNA1158727_P_NODE_82234_length_333_cov_1.280769_g74773_i0	PRJNA1158727	82234	333	1.280769	4.26496077	Deinococcus	1298	Bacteria	Bacteria	604	1.9199999999999991e-168	NTclustered	gi\|1514756464\|dbj\|LC433574.1\|	47478	g74773	i0	99.401	104.291291291291	334	1	100	1	1	333	464	797	Deinococcus sp. TM138 gene for 16S ribosomal RNA, partial sequence	blastn	34729	604	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
19430228	19430228	PRJNA1158727_P_NODE_151836_length_245_cov_0.895349_g144374_i0	PRJNA1158727	151836	245	0.895349	2.19360505	Deinococcus geothermalis	68909	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g144374	i0	99.184	80.5020408163265	245	2	100	0	1	245	89516	89272	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	19723	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
21439752	21439752	PRJNA1158727_P_NODE_97677_length_297_cov_1.843750_g90216_i0	PRJNA1158727	97677	297	1.84375	5.4759375	Deinococcus	1298	Bacteria	Bacteria	494	3.81e-135	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g90216	i0	96.633	201.367003367003	297	10	100	0	1	297	618	914	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	59806	494	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
22714575	22714575	PRJNA1158727_P_NODE_35578_length_691_cov_1.444984_g28307_i0	PRJNA1158727	35578	691	1.444984	9.98483944	Deinococcus	1298	Bacteria	Bacteria	1271	0	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g28307	i0	99.855	297.215629522431	691	1	100	0	1	691	1780	1090	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	205376	1271	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
24529619	24529619	PRJNA1158727_P_NODE_125000_length_261_cov_3.377660_g117539_i0	PRJNA1158727	125000	261	3.37766	8.8156926	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	460	3.3399999999999995e-125	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g117539	i0	98.467	59.3065134099617	261	4	100	0	1	261	68661	68401	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	15479	460	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum

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