metadata: contig_metadata: 8 rows where bioproject = "PRJNA1237347" and tax

8 rows where bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Latescibacterota"

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_species
7998427	7998427	PRJNA1237347_P_NODE_540867_length_243_cov_0.905882_g534294_i0	PRJNA1237347	540867	243	0.905882	2.20129326	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	217	7.34e-52	NTclustered	gi\|2891482399\|emb\|OZ220089.1\|	2053570	g534294	i0	82.857	111.711934156379	245	38	100	4	1	243	1952596	1952354	MAG: Candidatus Latescibacterota bacterium isolate 4e2a754f-172e-45f6-b93c-83e01e84db49 genome assembly, chromosome: 1	blastn	27146	217	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota bacterium
15647767	15647767	PRJNA1237347_P_NODE_529333_length_244_cov_0.900585_g522760_i0	PRJNA1237347	529333	244	0.900585	2.1974274	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	134	7.640000000000001e-27	NTclustered	gi\|2575820357\|emb\|OY730476.1\|	2053570	g522760	i0	84.507	1.16393442622951	142	15	55	3	110	244	59580	59439	MAG: Candidatus Latescibacteria bacterium isolate 667a1def-a863-4bf2-9b98-94036fb31650 genome assembly, chromosome: 1	blastn	284	134	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota bacterium
28778374	28778374	PRJNA1237347_P_NODE_384247_length_286_cov_1.826291_g377674_i0	PRJNA1237347	384247	286	1.826291	5.22319226	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	42.7	0.042	NR	MEW6755878.1	2053570	g377674	i0	42.1	0.597902097902098	57	33	59.8	0	284	114	116	172	MEW6755878.1 ABC transporter permease subunit [Candidatus Latescibacterota bacterium]	diamond	171	42.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota bacterium
29757113	29757113	PRJNA1237347_P_NODE_354151_length_301_cov_1.337719_g347578_i0	PRJNA1237347	354151	301	1.337719	4.02653419	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	60.5	3.43e-8	NR	MBN1293699.1	2053570	g347578	i0	41.9	0.926910299003322	93	41	92.7	2	12	290	46	125	MBN1293699.1 histone deacetylase [Candidatus Latescibacterota bacterium]	diamond	279	60.5	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota bacterium
31102464	31102464	PRJNA1237347_P_NODE_312755_length_325_cov_2.134921_g306182_i0	PRJNA1237347	312755	325	2.134921	6.93849325	Pseudomonadati	3379134	Bacteria	Bacteria	57.8	4.75e-7	NR	HCQ03247.1	2053570	g306182	i0	47.1	1.28307692307692	68	35	61.8	1	125	325	52	119	HCQ03247.1 hypothetical protein [Candidatus Latescibacterota bacterium]	diamond	417	57.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota bacterium
31938213	31938213	PRJNA1237347_P_NODE_89857_length_730_cov_1.870624_g83603_i0	PRJNA1237347	89857	730	1.870624	13.6555552	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	89	3.7e-16	NR	MFT7694725.1	2053570	g83603	i0	32.6	0.793150684931507	193	115	74.8	4	615	70	115	303	MFT7694725.1 hypothetical protein [Candidatus Latescibacterota bacterium]	diamond	579	89	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota bacterium
32539653	32539653	PRJNA1237347_P_NODE_503859_length_247_cov_0.885057_g497286_i0	PRJNA1237347	503859	247	0.885057	2.18609079	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	84	1.25e-16	NR	HCV23647.1	2053570	g497286	i0	50.7	8.1497975708502	73	36	88.7	0	220	2	62	134	HCV23647.1 hypothetical protein [Candidatus Latescibacterota bacterium]	diamond	2013	84	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota bacterium
32715248	32715248	PRJNA1237347_P_NODE_87500_length_742_cov_2.669656_g81281_i0	PRJNA1237347	87500	742	2.669656	19.80884752	FCB group	1783270	Bacteria	Bacteria	104	1.44e-21	NR	MBT4139822.1	2053570	g81281	i0	41.7	6.9177897574124	156	86	62.3	3	2	463	222	374	MBT4139822.1 hypothetical protein [Candidatus Latescibacterota bacterium]	diamond	5133	105	0.990476190476191	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota 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);;