metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA898105" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA898105" 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
6348226	6348226	PRJNA898105_P_NODE_4785_length_276_cov_1.320197_g4585_i0	PRJNA898105	4785	276	1.320197	3.64374372	Thermus	270	Bacteria	Bacteria	499	7.54e-137	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g4585	i0	99.275	56.1268115942029	276	2	100	0	1	276	1166085	1166360	Thermus scotoductus SA-01, complete genome	blastn	15491	499	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
7251965	7251965	PRJNA898105_P_NODE_4486_length_281_cov_1.413462_g4286_i0	PRJNA898105	4486	281	1.413462	3.97182822	uncultured Deinococcus sp.	158789	Bacteria	Bacteria	442	1.3199999999999993e-119	NTclustered	gi\|389546625\|gb\|JQ401553.1\|	158789	g4286	i0	95.018	105.174377224199	281	14	100	0	1	281	638	358	Uncultured Deinococcus sp. clone CNY_01678 16S ribosomal RNA gene, partial sequence	blastn	29554	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
8526635	8526635	PRJNA898105_P_NODE_3267_length_323_cov_2.208000_g3067_i0	PRJNA898105	3267	323	2.208	7.13184	Jonquetella anthropi	428712	Bacteria	Bacteria	398	3.3799999999999996e-106	NTclustered	gi\|194410714\|gb\|EU840722.1\|	428712	g3067	i0	98.661	975.628482972136	224	3	69	0	1	224	2406	2183	Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence	blastn	315128	398	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Jonquetella	Jonquetella anthropi
12723806	12723806	PRJNA898105_P_NODE_7730_length_244_cov_0.900585_g7530_i0	PRJNA898105	7730	244	0.900585	2.1974274	Fervidobacterium	2422	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g7530	i0	100	3	244	0	100	0	1	244	1120332	1120089	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	732	451	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
16546751	16546751	PRJNA898105_P_NODE_5393_length_265_cov_1.333333_g5193_i0	PRJNA898105	5393	265	1.333333	3.53333245	Deinococcus	1298	Bacteria	Bacteria	484	2.0199999999999998e-132	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g5193	i0	99.623	28.622641509434	265	1	100	0	1	265	873446	873182	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	7585	484	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
18725278	18725278	PRJNA898105_P_NODE_4155_length_286_cov_1.840376_g3955_i0	PRJNA898105	4155	286	1.840376	5.26347536	Jonquetella anthropi	428712	Bacteria	Bacteria	368	2.31e-97	NTclustered	gi\|194410714\|gb\|EU840722.1\|	428712	g3955	i0	100	147.716783216783	199	0	70	0	1	199	813	615	Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence	blastn	42247	368	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Jonquetella	Jonquetella anthropi
19095761	19095761	PRJNA898105_P_NODE_5275_length_267_cov_1.463918_g5075_i0	PRJNA898105	5275	267	1.463918	3.90866106	Deinococcus	1298	Bacteria	Bacteria	488	1.5699999999999998e-133	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g5075	i0	99.625	249.483146067416	267	1	100	0	1	267	1013	747	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	66612	488	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
23825967	23825967	PRJNA898105_P_NODE_1479_length_503_cov_2.237209_g1281_i0	PRJNA898105	1479	503	2.237209	11.25316127	Jonquetella anthropi	428712	Bacteria	Bacteria	918	0	NTclustered	gi\|194410714\|gb\|EU840722.1\|	428712	g1281	i0	99.602	92.0178926441352	503	2	100	0	1	503	27	529	Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence	blastn	46285	918	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Jonquetella	Jonquetella anthropi
25470979	25470979	PRJNA898105_P_NODE_880_length_697_cov_3.243590_g693_i0	PRJNA898105	880	697	3.24359	22.6078223	Truepera	332248	Bacteria	Bacteria	902	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g693	i0	90.762	182.691535150646	682	53	97	8	2	677	1920	1243	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	127336	902	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);;