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

5 rows where analysis = "blastn", bioproject = "PRJNA898105" 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
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.
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
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
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);;