metadata: contig_metadata: 6 rows where bioproject = "PRJNA1122875", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

6 rows where bioproject = "PRJNA1122875", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

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_order	tax_species
15580359	15580359	PRJNA1122875_P_NODE_20813_length_365_cov_1.318493_g20589_i0	PRJNA1122875	20813	365	1.318493	4.81249945	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	148	3.6199999999999985e-43	NR	MBX9722668.1	2364082	g20589	i0	72.3	0.772602739726027	94	26	77.3	0	2	283	44	137	MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	282	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
25255048	25255048	PRJNA1122875_P_NODE_25700_length_327_cov_1.149606_g25476_i0	PRJNA1122875	25700	327	1.149606	3.75921162	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	204	5.19e-65	NR	MBX9724270.1	2364082	g25476	i0	91.7	1.98165137614679	108	9	99.1	0	3	326	53	160	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	648	204	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
30638750	30638750	PRJNA1122875_P_NODE_6153_length_643_cov_0.935088_g5938_i0	PRJNA1122875	6153	643	0.935088	6.01261584	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	112	3.6e-25	NR	RTL43242.1	2052166	g5938	i0	46.1	1.25038880248834	128	58	59.7	3	187	570	268	384	RTL43242.1 MAG: galactose mutarotase [Candidatus Melainabacteria bacterium]	diamond	804	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
31797542	31797542	PRJNA1122875_P_NODE_35357_length_279_cov_0.902913_g35133_i0	PRJNA1122875	35357	279	0.902913	2.51912727	Bacillati	1783272	Bacteria	Bacteria	57.4	3.41e-7	NR	DAA96045.1	1916320	g35133	i0	53.7	2.79569892473118	54	25	58.1	0	101	262	99	152	DAA96045.1 MAG TPA: glycosyltransferase [Candidatus Gastranaerophilales bacterium HUM_9]	diamond	780	57.8	0.993079584775087	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium HUM_9
32430627	32430627	PRJNA1122875_P_NODE_41779_length_255_cov_1.692308_g41555_i0	PRJNA1122875	41779	255	1.692308	4.3153854	root	1	Root_unresolved	Root_unresolved	48.5	2.81e-4	NR	MBC7997637.1	2052166	g41555	i0	31.1	2.69411764705882	74	50	85.9	1	24	242	89	162	MBC7997637.1 tetratricopeptide repeat protein [Candidatus Melainabacteria bacterium]	diamond	687	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
32441681	32441681	PRJNA1122875_P_NODE_8359_length_566_cov_2.367140_g8141_i0	PRJNA1122875	8359	566	2.36714	13.3980124	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	47.4	0.0135	NR	MBC7998436.1	2052166	g8141	i0	24.1	1.07067137809187	116	75	55.7	2	503	189	93	206	MBC7998436.1 SgcJ/EcaC family oxidoreductase [Candidatus Melainabacteria bacterium]	diamond	606	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria 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);;