metadata: contig_metadata: 5 rows where bioproject = "PRJNA195897" and tax

5 rows where bioproject = "PRJNA195897" 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
1055326	1055326	PRJNA195897_P_NODE_3001_length_284_cov_1.548936_g2968_i0	PRJNA195897	3001	284	1.548936	4.39897824	Deinococcus	1298	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|3093386\|emb\|AJ000002.1\|	68909	g2968	i0	99.648	107.880281690141	284	1	100	0	1	284	304	21	Deinococcus geothermalis 16S rRNA gene, strain E50053	blastn	30638	520	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
3605769	3605769	PRJNA195897_P_NODE_5723_length_203_cov_1.837662_g5690_i0	PRJNA195897	5723	203	1.837662	3.73045386	Deinococcus	1298	Bacteria	Bacteria	364	2e-96	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g5690	i0	99.015	251.251231527094	203	2	100	0	1	203	1513	1311	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	51004	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
4883277	4883277	PRJNA195897_P_NODE_5864_length_202_cov_1.013072_g5831_i0	PRJNA195897	5864	202	1.013072	2.04640544	Deinococcus	1298	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g5831	i0	100	336.133663366337	202	0	100	0	1	202	2451	2250	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	67899	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
26630815	26630815	PRJNA195897_P_NODE_12061_length_163_cov_0.912281_g12028_i0	PRJNA195897	12061	163	0.912281	1.48701803	Deinococcus aquaticus	328692	Bacteria	Bacteria	94	9.57e-21	NR	WP_273991361.1	328692	g12028	i0	91.8	0.901840490797546	49	4	90.2	0	148	2	1	49	WP_273991361.1 hypothetical protein [Deinococcus aquaticus]	diamond	147	94	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
31559499	31559499	PRJNA195897_P_NODE_12716_length_161_cov_3.866071_g12683_i0	PRJNA195897	12716	161	3.866071	6.22437431	Synergistaceae bacterium	2053624	Bacteria	Bacteria	48.5	6.19e-5	NR	MDR2137471.1	2053624	g12683	i0	46.3	1.00621118012422	54	22	87.6	2	3	143	24	77	MDR2137471.1 TerD family protein [Synergistaceae bacterium]	diamond	162	48.5	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium

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