metadata: contig_metadata: 12 rows where bioproject = "PRJNA493828" and tax

12 rows where bioproject = "PRJNA493828" 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
2382239	2382239	PRJNA493828_P_NODE_45262_length_217_cov_4.236111_g44843_i0	PRJNA493828	45262	217	4.236111	9.19236087	Nitrospira	1234	Bacteria	Bacteria	350	6.07e-92	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g44843	i0	98.01	148.764976958525	201	4	93	0	17	217	1279050	1278850	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	32282	350	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
2382268	2382268	PRJNA493828_P_NODE_4742_length_504_cov_2.529002_g4352_i0	PRJNA493828	4742	504	2.529002	12.74617008	Nitrospira	1234	Bacteria	Bacteria	819	0	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g4352	i0	96.032	239.323412698413	504	19	100	1	1	504	1278613	1278111	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	120619	826	0.991525423728814	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
4301612	4301612	PRJNA493828_P_NODE_30364_length_255_cov_2.010989_g29945_i0	PRJNA493828	30364	255	2.010989	5.12802195	Nitrospira moscoviensis	42253	Bacteria	Bacteria	466	6.98e-127	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g29945	i0	99.608	2	255	1	100	0	1	255	113687	113941	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	510	466	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
5578244	5578244	PRJNA493828_P_NODE_26325_length_266_cov_2.922280_g25906_i0	PRJNA493828	26325	266	2.92228	7.7732648	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	438	1.6e-118	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g25906	i0	97.647	285.071428571429	255	6	96	0	1	255	2707774	2707520	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	75829	438	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
10678520	10678520	PRJNA493828_P_NODE_44949_length_219_cov_5.712329_g44530_i0	PRJNA493828	44949	219	5.712329	12.51000051	Nitrospira moscoviensis	42253	Bacteria	Bacteria	355	1.32e-93	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g44530	i0	95.89	258.803652968037	219	9	100	0	1	219	1277864	1278082	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	56678	355	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
11953499	11953499	PRJNA493828_P_NODE_33770_length_248_cov_13.965714_g33351_i0	PRJNA493828	33770	248	13.965714	34.63497072	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	435	1.91e-117	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g33351	i0	98.776	146.552419354839	245	2	99	1	4	248	2705030	2704787	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	36345	435	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
13228540	13228540	PRJNA493828_P_NODE_29851_length_256_cov_3.142077_g29432_i0	PRJNA493828	29851	256	3.142077	8.04371712	Nitrospira sp.	70125	Bacteria	Bacteria	473	4.189999999999999e-129	NTclustered	gi\|2290915413\|gb\|CP060502.1\|	70125	g29432	i0	100	2	256	0	100	0	1	256	195858	195603	MAG: Nitrospira sp. isolate NSFW plasmid pNSFW1, complete sequence	blastn	512	473	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30076731	30076731	PRJNA493828_P_NODE_46212_length_209_cov_7.875000_g45793_i0	PRJNA493828	46212	209	7.875	16.45875	Nitrospirota bacterium	2026887	Bacteria	Bacteria	74.3	1.64e-13	NR	MEK6803703.1	2026887	g45793	i0	49.3	0.990430622009569	69	35	99	0	3	209	54	122	MEK6803703.1 restriction endonuclease subunit S [Nitrospirota bacterium]	diamond	207	74.3	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
30298530	30298530	PRJNA493828_P_NODE_23072_length_277_cov_1.348039_g22653_i0	PRJNA493828	23072	277	1.348039	3.73406803	Nitrospirota bacterium	2026887	Bacteria	Bacteria	87.8	6.74e-20	NR	MEK7305963.1	2026887	g22653	i0	83.7	1.54873646209386	49	8	53.1	0	1	147	83	131	MEK7305963.1 HPF/RaiA family ribosome-associated protein [Nitrospirota bacterium]	diamond	429	87.8	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
30898502	30898502	PRJNA493828_P_NODE_39374_length_241_cov_2.190476_g38955_i0	PRJNA493828	39374	241	2.190476	5.27904716	Nitrospira sp.	70125	Bacteria	Bacteria	140	9.64e-37	NR	MBH0192353.1	70125	g38955	i0	93.8	0.995850622406639	80	5	99.6	0	241	2	256	335	MBH0192353.1 GAF domain-containing protein [Nitrospira sp.]	diamond	240	140	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31182414	31182414	PRJNA493828_P_NODE_38715_length_242_cov_1.414201_g38296_i0	PRJNA493828	38715	242	1.414201	3.42236642	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	99.8	6.049999999999999e-24	NR	HYM89160.1	2026770	g38296	i0	61.7	1.00413223140496	81	30	99.2	1	3	242	38	118	HYM89160.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Nitrospiraceae bacterium]	diamond	243	99.8	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
31783509	31783509	PRJNA493828_P_NODE_26377_length_266_cov_2.295337_g25958_i0	PRJNA493828	26377	266	2.295337	6.10559642	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	120	2.29e-30	NR	HXT67641.1	2026770	g25958	i0	69.7	0.857142857142857	76	22	84.6	1	2	226	284	359	HXT67641.1 hypothetical protein [Nitrospiraceae bacterium]	diamond	228	120	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae 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);;