metadata: contig_metadata: 7 rows where bioproject = "PRJNA929952", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA929952", tax_kingdom = "Pseudomonadati" and tax_phylum = "Nitrospirota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1254788	1254788	PRJNA929952_P_NODE_6021_length_504_cov_29.482105_g4910_i0	PRJNA929952	6021	504	29.482105	148.5898092	Nitrospira	1234	Bacteria	Bacteria	597	5.0499999999999983e-166	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g4910	i0	95.238	74.4464285714286	378	16	75	2	1	377	2686740	2687116	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	37521	597	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
10183466	10183466	PRJNA929952_P_NODE_10628_length_349_cov_23.296875_g9339_i0	PRJNA929952	10628	349	23.296875	81.30609375	Nitrospira	1234	Bacteria	Bacteria	263	1.4e-65	NTclustered	gi\|1167499077\|emb\|LT828648.1\|	1325564	g9339	i0	88.94	143.977077363897	217	19	62	5	135	349	2390072	2390285	Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I	blastn	50248	263	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira japonica
11112824	11112824	PRJNA929952_P_NODE_9509_length_380_cov_20.997151_g8234_i0	PRJNA929952	9509	380	20.997151	79.7891738	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	453	8.500000000000001e-123	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g8234	i0	96.043	125.663157894737	278	11	73	0	103	380	2707520	2707797	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	47752	453	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
13662797	13662797	PRJNA929952_P_NODE_23351_length_164_cov_5.200000_g22057_i0	PRJNA929952	23351	164	5.2	8.528	Nitrospira sp. KM1	1936990	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|1808878785\|dbj\|AP022671.1\|	1936990	g22057	i0	98.78	23.0182926829268	164	2	100	0	1	164	4207793	4207956	Nitrospira sp. KM1 DNA, complete genome	blastn	3775	292	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. KM1
16557323	16557323	PRJNA929952_P_NODE_21853_length_182_cov_22.594771_g20559_i0	PRJNA929952	21853	182	22.594771	41.12248322	Nitrospira	1234	Bacteria	Bacteria	213	6.71e-51	NTclustered	gi\|2863129529\|dbj\|AP038806.1\|	70125	g20559	i0	88.636	311.104395604396	176	18	97	2	7	182	3062830	3062657	MAG: Nitrospira sp. NFB02 DNA, complete genome	blastn	56621	213	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
21311234	21311234	PRJNA929952_P_NODE_16317_length_251_cov_22.986486_g15023_i0	PRJNA929952	16317	251	22.986486	57.69607986	Nitrospira sp.	70125	Bacteria	Bacteria	289	1.59e-73	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g15023	i0	96.067	234.637450199203	178	6	71	1	74	251	2684648	2684472	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	58894	289	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
21311264	21311264	PRJNA929952_P_NODE_4997_length_558_cov_31.737240_g3971_i0	PRJNA929952	4997	558	31.73724	177.0937992	Nitrospira sp.	70125	Bacteria	Bacteria	937	0	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g3971	i0	96.953	80.2562724014337	558	17	100	0	1	558	201925	201368	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	44783	937	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira 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);;