metadata: contig_metadata: 5 rows where bioproject = "PRJNA1035005", tax_clade = "Methanomada group" and tax

5 rows where bioproject = "PRJNA1035005", tax_clade = "Methanomada group" and tax_phylum = "Methanobacteriota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
23121486	23121486	PRJNA1035005_P_NODE_9999_length_364_cov_2.041237_g9594_i0	PRJNA1035005	9999	364	2.041237	7.43010268	Methanobacteriaceae archaeon	2099680	Archaea	Archaea	204	3.8999999999999995e-62	NR	MBX7076500.1	2099680	g9594	i0	81.4	0.972527472527473	118	22	97.3	0	357	4	12	129	MBX7076500.1 elongation factor Tu [Methanobacteriaceae archaeon]	diamond	354	204	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
24394770	24394770	PRJNA1035005_P_NODE_19940_length_300_cov_3.176211_g19534_i0	PRJNA1035005	19940	300	3.176211	9.528633	Methanosphaera sp. ISO3-F5	1452353	Archaea	Archaea	388	1.87e-103	NTclustered	gi\|2695672494\|gb\|CP118753.2\|	1452353	g19534	i0	90	1.89	300	30	100	0	1	300	1727654	1727953	Methanosphaera sp. ISO3-F5 chromosome, complete genome	blastn	567	388	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp. ISO3-F5
28140884	28140884	PRJNA1035005_P_NODE_23465_length_291_cov_1.431193_g23059_i0	PRJNA1035005	23465	291	1.431193	4.16477163	Methanobrevibacter sp.	66852	Archaea	Archaea	43.9	0.00762	NR	MBO7695419.1	66852	g23059	i0	44.2	1.11340206185567	52	25	52.6	2	14	166	3	51	MBO7695419.1 hypothetical protein [Methanobrevibacter sp.]	diamond	324	43.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
28298430	28298430	PRJNA1035005_P_NODE_82946_length_243_cov_0.917647_g82540_i0	PRJNA1035005	82946	243	0.917647	2.22988221	Methanobrevibacter sp.	66852	Archaea	Archaea	92.8	2.84e-22	NR	MBQ6630168.1	66852	g82540	i0	61.3	0.925925925925926	75	27	90.1	1	9	227	40	114	MBQ6630168.1 hypothetical protein [Methanobrevibacter sp.]	diamond	225	92.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32596116	32596116	PRJNA1035005_P_NODE_65500_length_249_cov_0.886364_g65094_i0	PRJNA1035005	65500	249	0.886364	2.20704636	Methanosphaera sp.	2666342	Archaea	Archaea	59.7	4.17e-8	NR	MEE3325102.1	2666342	g65094	i0	40	1.72289156626506	70	42	84.3	0	214	5	408	477	MEE3325102.1 hypothetical protein [Methanosphaera sp.]	diamond	429	59.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp.

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