metadata: contig_metadata: 9 rows where bioproject = "PRJNA753704" and tax

9 rows where bioproject = "PRJNA753704" and tax_phylum = "Gemmatimonadota"

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
1202076	1202076	PRJNA753704_P_NODE_741_length_1234_cov_8.730405_g524_i0	PRJNA753704	741	1234	8.730405	107.7331977	Gemmatimonas	173479	Bacteria	Bacteria	2052	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g524	i0	96.677	223.22528363047	1234	41	100	0	1	1234	1712	479	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	275460	2052	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
2007142	2007142	PRJNA753704_P_NODE_27922_length_243_cov_0.917647_g27561_i0	PRJNA753704	27922	243	0.917647	2.22988221	Gemmatimonas aurantiaca	173480	Bacteria	Bacteria	355	1.49e-93	NTclustered	gi\|226088597\|dbj\|AP009153.1\|	379066	g27561	i0	93.004	7.05349794238683	243	17	100	0	1	243	2062070	2062312	Gemmatimonas aurantiaca T-27 DNA, complete genome	blastn	1714	355	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
5834535	5834535	PRJNA753704_P_NODE_12905_length_331_cov_2.244186_g12544_i0	PRJNA753704	12905	331	2.244186	7.42825566	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	479	1.2099999999999996e-130	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g12544	i0	93.009	152.398791540786	329	21	99	2	1	328	2075175	2074848	Gemmatimonas phototrophica strain AP64, complete genome	blastn	50444	479	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
12210430	12210430	PRJNA753704_P_NODE_12590_length_335_cov_1.309160_g12229_i0	PRJNA753704	12590	335	1.30916	4.385686	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	150	5.99e-40	NR	RMH73596.1	2026742	g12229	i0	61.3	0.994029850746269	111	42	99.4	1	334	2	323	432	RMH73596.1 MAG: hypothetical protein D6675_02145, partial [Gemmatimonadota bacterium]	diamond	333	150	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
12681702	12681702	PRJNA753704_P_NODE_21290_length_264_cov_2.157068_g20929_i0	PRJNA753704	21290	264	2.157068	5.69465952	Gemmatimonas	173479	Bacteria	Bacteria	289	1.69e-73	NTclustered	gi\|226088597\|dbj\|AP009153.1\|	379066	g20929	i0	86.466	52.8939393939394	266	32	100	4	1	264	4385	4122	Gemmatimonas aurantiaca T-27 DNA, complete genome	blastn	13964	289	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
27157216	27157216	PRJNA753704_P_NODE_24662_length_250_cov_1.491525_g24301_i0	PRJNA753704	24662	250	1.491525	3.7288125	Pseudomonadati	3379134	Bacteria	Bacteria	53.1	6.62e-6	NR	MFN0099432.1	2026741	g24301	i0	73.5	1.524	34	9	40.8	0	104	3	9	42	MFN0099432.1 SDR family oxidoreductase [Gemmatimonadaceae bacterium]	diamond	381	53.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28925853	28925853	PRJNA753704_P_NODE_24608_length_250_cov_1.762712_g24247_i0	PRJNA753704	24608	250	1.762712	4.40678	Bacteria	2	Bacteria	Bacteria	50.1	7.45e-5	NR	MCA9751700.1	2026742	g24247	i0	50	1.596	60	26	67.2	1	168	1	9	68	MCA9751700.1 thioredoxin family protein [Gemmatimonadota bacterium]	diamond	399	50.4	0.994047619047619	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30505169	30505169	PRJNA753704_P_NODE_26333_length_246_cov_2.265896_g25972_i0	PRJNA753704	26333	246	2.265896	5.57410416	Pseudomonadati	3379134	Bacteria	Bacteria	62.8	3.3e-9	NR	UCF20388.1	2026742	g25972	i0	40.5	3.39024390243902	74	43	90.2	1	235	14	18	90	UCF20388.1 MAG: AMP-binding protein [Gemmatimonadota bacterium]	diamond	834	62.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32771021	32771021	PRJNA753704_P_NODE_19200_length_277_cov_1.294118_g18839_i0	PRJNA753704	19200	277	1.294118	3.58470686	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	99.4	6.91e-22	NR	MBK8246466.1	2026742	g18839	i0	84.8	2.15523465703971	66	10	71.5	0	6	203	386	451	MBK8246466.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	597	99.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;