metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA438687" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA438687" 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
1091184	1091184	PRJNA438687_S_NODE_4461_length_210_cov_7.205714_g4371_i0	PRJNA438687	4461	210	7.205714	15.1319994	Deinococcus	1298	Bacteria	Bacteria	366	5.7900000000000005e-97	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g4371	i0	98.095	285.714285714286	210	4	100	0	1	210	1792184	1792393	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	60000	366	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
1710224	1710224	PRJNA438687_S_NODE_6382_length_173_cov_25.289855_g6292_i0	PRJNA438687	6382	173	25.289855	43.75144915	uncultured Synergistota bacterium	447826	Bacteria	Bacteria	292	7.87e-75	NTclustered	gi\|401555891\|gb\|JX010942.1\|	447826	g6292	i0	97.11	101.913294797688	173	5	100	0	1	173	655	483	Uncultured Synergistetes bacterium clone 7P51 16S ribosomal RNA gene, partial sequence	blastn	17631	292	1	Bacteria	Thermotogati	Synergistota					uncultured Synergistota bacterium
3642148	3642148	PRJNA438687_S_NODE_3563_length_235_cov_6.130000_g3473_i0	PRJNA438687	3563	235	6.13	14.4055	Deinococcus	1298	Bacteria	Bacteria	390	3.93e-104	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g3473	i0	98.636	192.221276595745	220	3	94	0	16	235	2148327	2148546	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	45172	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
4919323	4919323	PRJNA438687_S_NODE_3164_length_251_cov_5.787037_g3074_i0	PRJNA438687	3164	251	5.787037	14.52546287	Deinococcus	1298	Bacteria	Bacteria	357	4.3e-94	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g3074	i0	93.033	175.338645418327	244	17	97	0	1	244	1793159	1793402	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	44010	357	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
7469175	7469175	PRJNA438687_S_NODE_4706_length_204_cov_88.491124_g4616_i0	PRJNA438687	4706	204	88.491124	180.52189296	Deinococcus	1298	Bacteria	Bacteria	339	1.22e-88	NTclustered	gi\|1168717715\|emb\|LT718630.1\|	55148	g4616	i0	97.015	100.470588235294	201	6	99	0	1	201	681	481	Deinococcus proteolyticus partial 16S rRNA gene, strain FeSTC10-34	blastn	20496	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
11294308	11294308	PRJNA438687_S_NODE_3589_length_234_cov_88.085427_g3499_i0	PRJNA438687	3589	234	88.085427	206.11989918	root	1	Root_unresolved	Root_unresolved	427	2.9799999999999993e-115	NTclustered	gi\|2444916559\|dbj\|LC733524.2\|	47478	g3499	i0	99.573	105.957264957265	234	1	100	0	1	234	697	464	Deinococcus sp. AKn-1 gene for 16S rRNA, partial sequence	blastn	24794	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
11914113	11914113	PRJNA438687_S_NODE_7650_length_156_cov_4.264463_g7560_i0	PRJNA438687	7650	156	4.264463	6.65256228	Deinococcus radiophilus	32062	Bacteria	Bacteria	278	1.95e-70	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g7560	i0	98.718	227.307692307692	156	2	100	0	1	156	1814959	1814804	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	35460	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
16393710	16393710	PRJNA438687_S_NODE_1233_length_355_cov_3.503125_g1143_i0	PRJNA438687	1233	355	3.503125	12.43609375	Deinococcus	1298	Bacteria	Bacteria	520	7.659999999999999e-143	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g1143	i0	93.017	248.833802816901	358	22	100	3	1	355	70726	70369	Deinococcus swuensis strain DY59, complete genome	blastn	88336	520	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
18287001	18287001	PRJNA438687_S_NODE_6015_length_179_cov_1.944444_g5925_i0	PRJNA438687	6015	179	1.944444	3.48055476	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	174	3.1e-39	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g5925	i0	85.976	4.37430167597765	164	21	91	2	1	163	69683	69845	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	783	174	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
20836920	20836920	PRJNA438687_S_NODE_5757_length_184_cov_1.127517_g5667_i0	PRJNA438687	5757	184	1.127517	2.07463128	Deinococcus peraridilitoris	432329	Bacteria	Bacteria	159	8.989999999999998e-35	NTclustered	gi\|429132235\|gb\|CP003383.1\|	937777	g5667	i0	83.24	26.3423913043478	179	24	96	5	9	184	446243	446418	Deinococcus peraridilitoris DSM 19664 plasmid pDEIPE01, complete sequence	blastn	4847	159	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
23387454	23387454	PRJNA438687_S_NODE_1719_length_321_cov_7.251748_g1629_i0	PRJNA438687	1719	321	7.251748	23.27811108	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	261	4.6e-65	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g1629	i0	81.905	132.255451713396	315	51	98	6	9	321	2281806	2282116	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	42454	261	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);;