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

5 rows where analysis = "blastn", bioproject = "PRJNA929924" 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
1254169	1254169	PRJNA929924_P_NODE_15261_length_168_cov_2.361345_g15098_i0	PRJNA929924	15261	168	2.361345	3.9670596	Deinococcus	1298	Bacteria	Bacteria	263	5.989999999999999e-66	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g15098	i0	95.181	197.428571428571	166	8	100	0	1	166	423304	423469	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	33168	265	0.992452830188679	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
7632546	7632546	PRJNA929924_P_NODE_8506_length_303_cov_1.846457_g8343_i0	PRJNA929924	8506	303	1.846457	5.59476471	Truepera	332248	Bacteria	Bacteria	451	2.38e-122	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g8343	i0	93.98	898.47194719472	299	17	99	1	1	299	2634	2931	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	272237	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
10183007	10183007	PRJNA929924_P_NODE_6188_length_488_cov_4.298405_g6025_i0	PRJNA929924	6188	488	4.298405	20.9762164	Truepera	332248	Bacteria	Bacteria	634	3.719999999999999e-177	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g6025	i0	90.144	395.842213114754	487	48	99	0	1	487	24	510	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	193171	634	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
20380701	20380701	PRJNA929924_P_NODE_6536_length_450_cov_1.852868_g6373_i0	PRJNA929924	6536	450	1.852868	8.337906	Truepera	332248	Bacteria	Bacteria	566	1.2599999999999999e-156	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g6373	i0	89.556	74.22	450	42	99	4	1	446	1829	1381	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	33399	566	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
25481011	25481011	PRJNA929924_P_NODE_9280_length_268_cov_2.182648_g9117_i0	PRJNA929924	9280	268	2.182648	5.84949664	Truepera	332248	Bacteria	Bacteria	440	4.479999999999998e-119	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g9117	i0	96.269	202.242537313433	268	10	100	0	1	268	1809	2076	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	54201	440	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);;