metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA400391" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA400391" 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
1081105	1081105	PRJNA400391_S_NODE_5041_length_176_cov_1.723404_g4980_i0	PRJNA400391	5041	176	1.723404	3.03319104	Deinococcus	1298	Bacteria	Bacteria	274	2.9099999999999997e-69	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g4980	i0	94.915	546.363636363636	177	6	100	3	1	176	1269	1095	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	96160	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
6184152	6184152	PRJNA400391_S_NODE_5265_length_172_cov_2.306569_g5204_i0	PRJNA400391	5265	172	2.306569	3.96729868	Deinococcus	1298	Bacteria	Bacteria	279	6.08e-71	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g5204	i0	97.561	192.598837209302	164	3	95	1	9	172	865	703	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	33127	281	0.99288256227758	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
15108839	15108839	PRJNA400391_S_NODE_6692_length_150_cov_1.304348_g6631_i0	PRJNA400391	6692	150	1.304348	1.956522	Bacteria	2	Bacteria	Bacteria	272	8.609999999999998e-69	NTclustered	gi\|1236765911\|gb\|MF359428.1\|	275	g6631	i0	100	101.006666666667	147	0	98	0	1	147	778	924	Thermus sp. strain InS-183 16S ribosomal RNA gene, partial sequence	blastn	15151	272	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
15716806	15716806	PRJNA400391_S_NODE_4953_length_178_cov_4.405594_g4892_i0	PRJNA400391	4953	178	4.405594	7.84195732	Deinococcus grandis	57498	Bacteria	Bacteria	302	1.35e-77	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g4892	i0	99.398	333.179775280899	166	1	93	0	13	178	73496	73661	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	59306	302	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
16383444	16383444	PRJNA400391_S_NODE_4173_length_197_cov_1.518519_g4112_i0	PRJNA400391	4173	197	1.518519	2.99148243	Deinococcus	1298	Bacteria	Bacteria	244	2.62e-60	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g4112	i0	89.691	98.5177664974619	194	17	97	3	1	192	70007	70199	Deinococcus swuensis strain DY59, complete genome	blastn	19408	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
19539898	19539898	PRJNA400391_S_NODE_5936_length_161_cov_1.349206_g5875_i0	PRJNA400391	5936	161	1.349206	2.17222166	Thermotoga profunda	1508420	Bacteria	Bacteria	75	2.85e-9	NTclustered	gi\|597439398\|dbj\|AP014510.1\|	1408160	g5875	i0	83.133	0.515527950310559	83	12	51	2	2	83	2163731	2163812	Thermotoga profunda AZM34c06 DNA, complete genome	blastn	83	75	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga profunda

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