metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA600413" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA600413" 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
573001	573001	PRJNA600413_P_NODE_119321_length_165_cov_0.879310_g118620_i0	PRJNA600413	119321	165	0.87931	1.4508615	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	115	1.73e-21	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g118620	i0	79.755	0.987878787878788	163	29	98	3	3	163	611248	611408	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	163	115	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
573071	573071	PRJNA600413_P_NODE_124641_length_164_cov_0.886957_g123940_i0	PRJNA600413	124641	164	0.886957	1.45460948	Nitrospira defluvii	330214	Bacteria	Bacteria	154	3.65e-33	NTclustered	gi\|300603458\|emb\|FP929003.1\|	330214	g123940	i0	87.786	2.51829268292683	131	16	80	0	7	137	2135679	2135809	Candidatus Nitrospira defluvii chromosome, complete genome	blastn	413	154	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
573353	573353	PRJNA600413_P_NODE_145081_length_161_cov_1.607143_g144380_i0	PRJNA600413	145081	161	1.607143	2.58750023	Nitrospira moscoviensis	42253	Bacteria	Bacteria	209	7.5e-50	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g144380	i0	90.123	1.86335403726708	162	14	100	2	1	161	2899927	2900087	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	300	209	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
4402795	4402795	PRJNA600413_P_NODE_82904_length_178_cov_1.395349_g82203_i0	PRJNA600413	82904	178	1.395349	2.48372122	Nitrospira sp.	70125	Bacteria	Bacteria	134	5.23e-27	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g82203	i0	86.179	0.691011235955056	123	17	69	0	15	137	812536	812414	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	123	134	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
5678723	5678723	PRJNA600413_P_NODE_75965_length_182_cov_1.827068_g75264_i0	PRJNA600413	75965	182	1.827068	3.32526376	Nitrospira sp.	70125	Bacteria	Bacteria	193	8.739999999999999e-45	NTclustered	gi\|2290911150\|gb\|CP060501.1\|	70125	g75264	i0	91.971	0.752747252747253	137	11	75	0	1	137	2314830	2314966	MAG: Nitrospira sp. isolate NSFW chromosome, complete genome	blastn	137	193	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
10777272	10777272	PRJNA600413_P_NODE_114249_length_166_cov_0.871795_g113548_i0	PRJNA600413	114249	166	0.871795	1.4471797	Nitrospira moscoviensis	42253	Bacteria	Bacteria	174	2.84e-39	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g113548	i0	88.356	0.879518072289157	146	15	87	2	9	153	1406794	1406650	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	146	174	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
12052246	12052246	PRJNA600413_P_NODE_124530_length_164_cov_0.886957_g123829_i0	PRJNA600413	124530	164	0.886957	1.45460948	Nitrospira sp.	70125	Bacteria	Bacteria	226	7.619999999999998e-55	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g123829	i0	93.96	1.81707317073171	149	9	91	0	16	164	1919106	1918958	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	298	226	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17150933	17150933	PRJNA600413_P_NODE_140094_length_162_cov_0.902655_g139393_i0	PRJNA600413	140094	162	0.902655	1.4623011	Nitrospira moscoviensis	42253	Bacteria	Bacteria	267	4.419999999999999e-67	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g139393	i0	96.296	14.5987654320988	162	6	100	0	1	162	155585	155746	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	2365	267	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
23525444	23525444	PRJNA600413_P_NODE_121459_length_165_cov_0.879310_g120758_i0	PRJNA600413	121459	165	0.87931	1.4508615	Candidatus Nitrospira inopinata	1715989	Bacteria	Bacteria	148	1.71e-31	NTclustered	gi\|952974062\|emb\|LN885086.1\|	1715989	g120758	i0	84.932	0.884848484848485	146	22	88	0	1	146	2479021	2479166	Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1	blastn	146	148	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira inopinata

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);;