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

5 rows where analysis = "blastn", bioproject = "PRJNA408129" 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
1082764	1082764	PRJNA408129_S_NODE_941_length_391_cov_16023.533898_g923_i0	PRJNA408129	941	391	16023.533898	62652.01754118	Truepera	332248	Bacteria	Bacteria	296	1.56e-75	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g923	i0	92.683	226.682864450128	205	15	52	0	157	361	10	214	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	88633	296	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
2358137	2358137	PRJNA408129_S_NODE_15222_length_194_cov_8.464968_g15204_i0	PRJNA408129	15222	194	8.464968	16.42203792	Allomeiothermus	2935559	Bacteria	Bacteria	311	2.5000000000000004e-80	NTclustered	gi\|470486339\|ref\|NR_076751.1\|	52022	g15204	i0	97.79	125.087628865979	181	3	93	1	4	184	1791	1612	Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence	blastn	24267	311	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
4245569	4245569	PRJNA408129_S_NODE_33264_length_153_cov_4.663793_g33246_i0	PRJNA408129	33264	153	4.663793	7.13560329	Deinococcus proteolyticus	55148	Bacteria	Bacteria	185	1.18e-42	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g33246	i0	92.308	63.3398692810458	130	10	85	0	12	141	91779	91650	Deinococcus proteolyticus MRP, complete genome	blastn	9691	185	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
9346506	9346506	PRJNA408129_S_NODE_2008_length_333_cov_7.500000_g1990_i0	PRJNA408129	2008	333	7.5	24.975	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	586	6.959999999999998e-163	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g1990	i0	98.784	21.5405405405405	329	4	99	0	5	333	2579347	2579019	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	7173	586	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
23370597	23370597	PRJNA408129_S_NODE_35699_length_150_cov_3.566372_g35681_i0	PRJNA408129	35699	150	3.566372	5.349558	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	263	5.18e-66	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g35681	i0	98.649	0.986666666666667	148	2	99	0	1	148	2172675	2172822	Deinococcus sp. QL22 chromosome, complete genome	blastn	148	263	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22

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