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

10 rows where analysis = "blastn", bioproject = "PRJNA815356" and tax_phylum = "Deinococcota"

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
6331978	6331978	PRJNA815356_P_NODE_2545_length_418_cov_4.646377_g2382_i0	PRJNA815356	2545	418	4.646377	19.42185586	Deinococcus	1298	Bacteria	Bacteria	695	0	NTclustered	gi\|1514756464\|dbj\|LC433574.1\|	47478	g2382	i0	96.659	106.150717703349	419	13	100	1	1	418	435	17	Deinococcus sp. TM138 gene for 16S ribosomal RNA, partial sequence	blastn	44371	695	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
8880925	8880925	PRJNA815356_P_NODE_267_length_1191_cov_6.111807_g91_i1	PRJNA815356	267	1191	6.111807	72.79162137	Deinococcus	1298	Bacteria	Bacteria	1759	0	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g91	i1	93.317	208.549118387909	1197	70	100	8	1	1191	313	1505	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	248382	1759	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
12298255	12298255	PRJNA815356_P_NODE_10370_length_244_cov_0.912281_g10207_i0	PRJNA815356	10370	244	0.912281	2.22596564	Thermus aquaticus	271	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g10207	i0	98.361	38.0614754098361	244	4	100	0	1	244	881589	881346	Thermus aquaticus Y51MC23, complete genome	blastn	9287	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
17397500	17397500	PRJNA815356_P_NODE_6174_length_292_cov_2.712329_g6011_i0	PRJNA815356	6174	292	2.712329	7.92000068	Deinococcus geothermalis	68909	Bacteria	Bacteria	540	4.74e-149	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g6011	i0	100	381.157534246575	292	0	100	0	1	292	325876	326167	Deinococcus geothermalis DSM 11300, complete genome	blastn	111298	540	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
17397512	17397512	PRJNA815356_P_NODE_7414_length_271_cov_1.510101_g7251_i0	PRJNA815356	7414	271	1.510101	4.09237371	Thermus aquaticus	271	Bacteria	Bacteria	496	9.55e-136	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g7251	i0	99.631	3.16605166051661	271	1	100	0	1	271	1647945	1647675	Thermus aquaticus Y51MC23, complete genome	blastn	858	496	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
18670452	18670452	PRJNA815356_P_NODE_155_length_1493_cov_9.661972_g91_i0	PRJNA815356	155	1493	9.661972	144.25324196	Deinococcus sp. KNUC1210	2917691	Bacteria	Bacteria	2355	0	NTclustered	gi\|2197029603\|gb\|CP092190.1\|	2917691	g91	i0	96.066	215.230408573342	1449	51	97	5	48	1493	1426706	1428151	Deinococcus sp. KNUC1210 chromosome, complete genome	blastn	321339	2355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. KNUC1210
19945634	19945634	PRJNA815356_P_NODE_10356_length_244_cov_0.912281_g10193_i0	PRJNA815356	10356	244	0.912281	2.22596564	Thermus aquaticus	271	Bacteria	Bacteria	418	1.8799999999999994e-112	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g10193	i0	97.541	39.1393442622951	244	6	100	0	1	244	188011	187768	Thermus aquaticus Y51MC23, complete genome	blastn	9550	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
21221147	21221147	PRJNA815356_P_NODE_1917_length_472_cov_8.453634_g1755_i0	PRJNA815356	1917	472	8.453634	39.90115248	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	595	1.6899999999999995e-165	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g1755	i0	89.474	214.588983050847	475	44	100	6	1	472	1361413	1360942	Deinococcus sp. QL22 chromosome, complete genome	blastn	101286	595	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
21221241	21221241	PRJNA815356_P_NODE_9777_length_247_cov_0.896552_g9614_i0	PRJNA815356	9777	247	0.896552	2.21448344	Thermus aquaticus	271	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g9614	i0	98.381	18.004048582996	247	4	100	0	1	247	906000	905754	Thermus aquaticus Y51MC23, complete genome	blastn	4447	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
25454517	25454517	PRJNA815356_P_NODE_9140_length_251_cov_0.876404_g8977_i0	PRJNA815356	9140	251	0.876404	2.19977404	Truepera	332248	Bacteria	Bacteria	364	2.57e-96	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g8977	i0	92.829	530.05577689243	251	18	100	0	1	251	1189	939	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	133044	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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