metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA924320" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA924320" 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
7277236	7277236	PRJNA924320_S_NODE_22326_length_222_cov_1.832370_g22184_i0	PRJNA924320	22326	222	1.83237	4.0678614	Thermus aquaticus	271	Bacteria	Bacteria	387	4.749999999999998e-103	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g22184	i0	99.528	1.66666666666667	212	1	95	0	11	222	621941	621730	Thermus aquaticus Y51MC23, complete genome	blastn	370	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
7630291	7630291	PRJNA924320_S_NODE_39666_length_178_cov_1.186047_g39524_i0	PRJNA924320	39666	178	1.186047	2.11116366	Thermus	270	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|1352798305\|gb\|CP020572.1\|	271	g39524	i0	100	47	178	0	100	0	1	178	35169	34992	Thermus aquaticus strain YT-1 plasmid p61, complete sequence	blastn	8366	329	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
8552357	8552357	PRJNA924320_S_NODE_55127_length_162_cov_0.902655_g54985_i0	PRJNA924320	55127	162	0.902655	1.4623011	Thermus aquaticus	271	Bacteria	Bacteria	289	9.44e-74	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g54985	i0	98.765	9.91975308641975	162	2	100	0	1	162	1366924	1366763	Thermus aquaticus Y51MC23, complete genome	blastn	1607	289	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
14927295	14927295	PRJNA924320_S_NODE_5072_length_420_cov_2.598383_g4930_i0	PRJNA924320	5072	420	2.598383	10.9132086	Thermus aquaticus	271	Bacteria	Bacteria	760	0	NTclustered	gi\|507890\|dbj\|D32013.1\|TTHDNAP	271	g4930	i0	99.286	28.1	420	3	100	0	1	420	2921	2502	Thermus aquaticus gene for DNA polymerase, complete cds	blastn	11802	760	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
14927343	14927343	PRJNA924320_S_NODE_56092_length_162_cov_0.893805_g55950_i0	PRJNA924320	56092	162	0.893805	1.4479641	Meiothermus ruber	277	Bacteria	Bacteria	167	4.609999999999999e-37	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g55950	i0	86.928	85.8086419753086	153	15	93	5	6	156	1237228	1237377	Meiothermus ruber DSM 1279, complete genome	blastn	13901	167	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
15280147	15280147	PRJNA924320_S_NODE_19892_length_232_cov_1.393443_g19750_i0	PRJNA924320	19892	232	1.393443	3.23278776	Thermus	270	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|219846310\|ref\|NR_025900.1\|	271	g19750	i0	100	103.004310344828	232	0	100	0	1	232	600	831	Thermus aquaticus strain YT-1 16S ribosomal RNA, partial sequence	blastn	23897	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
17477342	17477342	PRJNA924320_S_NODE_29194_length_201_cov_1.006579_g29052_i0	PRJNA924320	29194	201	1.006579	2.02322379	Thermus aquaticus	271	Bacteria	Bacteria	366	5.5e-97	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g29052	i0	99.502	149.542288557214	201	1	100	0	1	201	46579	46379	Thermus aquaticus Y51MC23, complete genome	blastn	30058	366	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
19103654	19103654	PRJNA924320_S_NODE_46355_length_167_cov_0.864407_g46213_i0	PRJNA924320	46355	167	0.864407	1.44355969	Thermus	270	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|10803422\|emb\|Y19223.3\|	271	g46213	i0	100	53.7664670658683	167	0	100	0	1	167	345	511	Thermus aquaticus rpoB gene for RNA polymerase beta subunit and rpoC gene for RNA polymerase beta' subunit	blastn	8979	309	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
21654379	21654379	PRJNA924320_S_NODE_1157_length_829_cov_1.865385_g1068_i0	PRJNA924320	1157	829	1.865385	15.46404165	root	1	Root_unresolved	Root_unresolved	1520	0	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g1068	i0	99.759	72.2038600723764	829	2	100	0	1	829	1119	1947	Thermus aquaticus DNA polymerase (PolI) gene	blastn	59857	1520	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
25478804	25478804	PRJNA924320_S_NODE_4460_length_446_cov_2.110831_g4319_i0	PRJNA924320	4460	446	2.110831	9.41430626	Deinococcus	1298	Bacteria	Bacteria	350	1.37e-91	NTclustered	gi\|485099143\|ref\|NR_102538.1\|	432329	g4319	i0	81.236	250.867713004484	453	67	99	14	6	446	466	20	Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence	blastn	111887	350	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris

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