metadata: contig_metadata: 5 rows where bioproject = "PRJNA741997", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax

5 rows where bioproject = "PRJNA741997", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax_superkingdom = "Bacteria"

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
21124015	21124015	PRJNA741997_P_NODE_40177_length_342_cov_1.981413_g39057_i0	PRJNA741997	40177	342	1.981413	6.77643246	Nitrospinota bacterium	2026769	Bacteria	Bacteria	135	1.0699999999999998e-37	NR	HJP18609.1	2026769	g39057	i0	61.9	4.91228070175439	113	42	98.2	1	340	5	50	162	HJP18609.1 peroxiredoxin [Nitrospinota bacterium]	diamond	1680	135	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
27810870	27810870	PRJNA741997_P_NODE_73024_length_250_cov_1.740113_g71904_i0	PRJNA741997	73024	250	1.740113	4.3502825	Nitrospinota bacterium	2026769	Bacteria	Bacteria	45.8	0.00307	NR	MZG31522.1	2026769	g71904	i0	54.5	2.016	44	15	46.8	1	2	118	50	93	MZG31522.1 DnaJ domain-containing protein [Nitrospinota bacterium]	diamond	504	45.8	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29894714	29894714	PRJNA741997_P_NODE_56691_length_285_cov_1.452830_g55571_i0	PRJNA741997	56691	285	1.45283	4.1405655	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	42	0.0475	NR	MBM3227141.1	2528274	g55571	i0	75	0.252631578947368	24	6	25.3	0	6	77	38	61	MBM3227141.1 hypothetical protein [Candidatus Tectimicrobiota bacterium]	diamond	72	42	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
30969024	30969024	PRJNA741997_P_NODE_86614_length_243_cov_0.905882_g85494_i0	PRJNA741997	86614	243	0.905882	2.20129326	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	69.3	1.51e-12	NR	HEY7491539.1	2528274	g85494	i0	51.6	1.79012345679012	64	28	79	1	52	243	49	109	HEY7491539.1 hypothetical protein [Candidatus Tectimicrobiota bacterium]	diamond	435	69.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
32265770	32265770	PRJNA741997_P_NODE_28158_length_415_cov_0.900585_g27038_i0	PRJNA741997	28158	415	0.900585	3.73742775	Nitrospina sp.	2024844	Bacteria	Bacteria	94.4	1.59e-21	NR	MCA9483600.1	2024844	g27038	i0	34.6	0.96144578313253	133	85	96.1	1	17	415	2	132	MCA9483600.1 cyanase [Nitrospina sp.]	diamond	399	94.4	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospina	Nitrospina 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);;