metadata: contig_metadata: 6 rows where bioproject = "PRJNA879221" and tax

6 rows where bioproject = "PRJNA879221" 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
2132665	2132665	PRJNA879221_P_NODE_63682_length_241_cov_0.916667_g63542_i0	PRJNA879221	63682	241	0.916667	2.20916747	Thermus sp. PS18	2849039	Bacteria	Bacteria	329	8.95e-86	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g63542	i0	91.286	30.7261410788382	241	21	100	0	1	241	2101605	2101845	Thermus sp. PS18 chromosome, complete genome	blastn	7405	329	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
4685186	4685186	PRJNA879221_P_NODE_23804_length_361_cov_2.399306_g23664_i0	PRJNA879221	23804	361	2.399306	8.66149466	Meiothermus sp. Pnk-1	873128	Bacteria	Bacteria	144	1.47e-39	NR	WP_110525983.1	873128	g23664	i0	64.5	0.889196675900277	107	37	88.9	1	23	343	195	300	WP_110525983.1 DNA adenine methylase [Meiothermus sp. Pnk-1]	diamond	321	144	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp. Pnk-1
13610956	13610956	PRJNA879221_P_NODE_63971_length_241_cov_0.916667_g63831_i0	PRJNA879221	63971	241	0.916667	2.20916747	Thermus thermophilus	274	Bacteria	Bacteria	326	1.16e-84	NTclustered	gi\|2199618697\|dbj\|AP025605.1\|	274	g63831	i0	97.396	19.8755186721992	192	4	79	1	20	210	105289	105480	Thermus thermophilus SNM1-7 plasmid pTthSNM1-7c DNA, complete sequence	blastn	4790	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
27844814	27844814	PRJNA879221_P_NODE_40584_length_273_cov_0.840000_g40444_i0	PRJNA879221	40584	273	0.84	2.2932	Thermus oshimai	56957	Bacteria	Bacteria	79.7	2.48e-17	NR	GAA6741984.1	56957	g40444	i0	53.7	0.736263736263736	67	31	73.6	0	270	70	13	79	GAA6741984.1 hypothetical protein Thermus77359_21710 [Thermus oshimai]	diamond	201	79.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
32015125	32015125	PRJNA879221_P_NODE_12458_length_514_cov_1.047619_g12319_i0	PRJNA879221	12458	514	1.047619	5.38476166	Fervidobacterium sp.	1871331	Bacteria	Bacteria	77.4	4.83e-13	NR	HCI29565.1	1871331	g12319	i0	28.3	1.07392996108949	184	112	96.9	5	503	6	48	229	HCI29565.1 hypothetical protein [Fervidobacterium sp.]	diamond	552	77.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
32078397	32078397	PRJNA879221_P_NODE_5898_length_775_cov_5.454416_g5772_i0	PRJNA879221	5898	775	5.454416	42.271724	Deinobacterium chartae	521158	Bacteria	Bacteria	202	1.69e-58	NR	WP_183985712.1	521158	g5772	i0	62.5	1.21935483870968	160	60	61.9	0	3	482	270	429	WP_183985712.1 hypothetical protein [Deinobacterium chartae]	diamond	945	202	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinobacterium	Deinobacterium chartae

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