metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA976345" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA976345" 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
18799499	18799499	PRJNA976345_P_NODE_122455_length_178_cov_2.272727_g120847_i0	PRJNA976345	122455	178	2.272727	4.04545406	Deinococcus geothermalis	68909	Bacteria	Bacteria	90.9	1.72e-19	NR	WP_011529549.1	68909	g120847	i0	75	4.04494382022472	60	13	97.8	1	2	175	411	470	WP_011529549.1 molybdopterin oxidoreductase family protein [Deinococcus geothermalis]	diamond	720	90.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
23901337	23901337	PRJNA976345_P_NODE_72379_length_214_cov_1.284916_g70771_i0	PRJNA976345	72379	214	1.284916	2.74972024	Deinococcus ruber	1848197	Bacteria	Bacteria	114	6.629999999999999e-28	NR	WP_189093316.1	1848197	g70771	i0	74.6	1.99065420560748	71	18	99.5	0	213	1	222	292	WP_189093316.1 FAD-dependent monooxygenase [Deinococcus ruber]	diamond	426	114	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ruber
27183904	27183904	PRJNA976345_P_NODE_114582_length_181_cov_1.095890_g112974_i0	PRJNA976345	114582	181	1.09589	1.9835609	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	113	2.6e-27	NR	WP_386847023.1	536443	g112974	i0	100	0.994475138121547	60	0	99.4	0	1	180	873	932	WP_386847023.1 CshA/CshB family fibrillar adhesin-related protein [Deinococcus taklimakanensis]	diamond	180	113	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
27374038	27374038	PRJNA976345_P_NODE_51423_length_244_cov_3.980861_g49815_i0	PRJNA976345	51423	244	3.980861	9.71330084	uncultured Fretibacterium sp.	1678694	Bacteria	Bacteria	145	4.85e-43	NR	WP_299076663.1	1678694	g49815	i0	93.8	0.983606557377049	80	5	98.4	0	3	242	51	130	WP_299076663.1 DUF4418 family protein [uncultured Fretibacterium sp.]	diamond	240	145	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
27916545	27916545	PRJNA976345_P_NODE_131365_length_175_cov_1.135714_g129757_i0	PRJNA976345	131365	175	1.135714	1.9874995	Deinococcus	1298	Bacteria	Bacteria	85.9	7.58e-19	NR	WP_309572138.1	47478	g129757	i0	96.2	2.65714285714286	52	2	89.1	0	1	156	169	220	WP_309572138.1 LrgB family protein [Deinococcus sp.]	diamond	465	85.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
28605117	28605117	PRJNA976345_P_NODE_112907_length_182_cov_1.074830_g111299_i0	PRJNA976345	112907	182	1.07483	1.9561906	Deinococcus malanensis	1706855	Bacteria	Bacteria	59.7	1.71e-8	NR	WP_189011650.1	1706855	g111299	i0	70	1.31868131868132	40	12	65.9	0	63	182	355	394	WP_189011650.1 ATP-binding protein [Deinococcus malanensis]	diamond	240	59.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus malanensis
28700002	28700002	PRJNA976345_P_NODE_184747_length_154_cov_1.647059_g183139_i0	PRJNA976345	184747	154	1.647059	2.53647086	Synergistaceae bacterium	2053624	Bacteria	Bacteria	80.1	3.65e-16	NR	MBR0258493.1	2053624	g183139	i0	73.5	7.5974025974026	49	13	95.5	0	152	6	277	325	MBR0258493.1 iron-containing alcohol dehydrogenase [Synergistaceae bacterium]	diamond	1170	80.1	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29836476	29836476	PRJNA976345_P_NODE_82491_length_203_cov_2.952381_g80883_i0	PRJNA976345	82491	203	2.952381	5.99333343	uncultured Fretibacterium sp.	1678694	Bacteria	Bacteria	79	3.14e-15	NR	WP_299301996.1	1678694	g80883	i0	100	0.576354679802956	39	0	57.6	0	196	80	1	39	WP_299301996.1 ABC transporter permease [uncultured Fretibacterium sp.]	diamond	117	79	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
29931448	29931448	PRJNA976345_P_NODE_119311_length_178_cov_3.090909_g117703_i0	PRJNA976345	119311	178	3.090909	5.50181802	Calidithermus roseus	1644118	Bacteria	Bacteria	64.3	3.69e-10	NR	WP_182482889.1	1644118	g117703	i0	52.9	1.14606741573034	68	22	97.8	1	3	176	423	490	WP_182482889.1 DUF11 domain-containing protein [Calidithermus roseus]	diamond	204	64.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Calidithermus	Calidithermus roseus
32907892	32907892	PRJNA976345_P_NODE_163300_length_161_cov_1.753968_g161692_i0	PRJNA976345	163300	161	1.753968	2.82388848	Deinococcus	1298	Bacteria	Bacteria	104	2.46e-25	NR	WP_011525746.1	68909	g161692	i0	92.5	3.95031055900621	53	4	98.8	0	3	161	117	169	WP_011525746.1 IS4-like element ISDge11 family transposase [Deinococcus geothermalis]	diamond	636	104	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis

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