metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA312899" 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
4206600	4206600	PRJNA312899_P_NODE_35324_length_305_cov_3.171875_g34882_i0	PRJNA312899	35324	305	3.171875	9.67421875	Candidatus Nitrospira inopinata	1715989	Bacteria	Bacteria	562	1.06e-155	NTclustered	gi\|952974062\|emb\|LN885086.1\|	1715989	g34882	i0	100	3.74098360655738	304	0	99	0	2	305	2915117	2914814	Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1	blastn	1141	562	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira inopinata
5482658	5482658	PRJNA312899_P_NODE_22445_length_396_cov_7.997118_g22003_i0	PRJNA312899	22445	396	7.997118	31.66858728	Nitrospira sp.	70125	Bacteria	Bacteria	409	1.95e-109	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g22003	i0	86.089	0.962121212121212	381	51	96	2	7	386	2557004	2557383	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	381	409	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
6757681	6757681	PRJNA312899_P_NODE_68466_length_197_cov_1.378378_g68024_i0	PRJNA312899	68466	197	1.378378	2.71540466	Nitrospira sp.	70125	Bacteria	Bacteria	226	9.499999999999999e-55	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g68024	i0	87.31	28.2081218274112	197	25	100	0	1	197	1101346	1101150	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	5557	226	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
8032974	8032974	PRJNA312899_P_NODE_51187_length_242_cov_6.331606_g50745_i0	PRJNA312899	51187	242	6.331606	15.32248652	Nitrospira moscoviensis	42253	Bacteria	Bacteria	108	4.59e-19	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g50745	i0	76.652	128.5	227	33	89	17	1	215	1277436	1277654	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	31097	108	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
9307760	9307760	PRJNA312899_P_NODE_52788_length_238_cov_1.079365_g52346_i0	PRJNA312899	52788	238	1.079365	2.5688887	Nitrospira sp.	70125	Bacteria	Bacteria	435	1.8200000000000003e-117	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g52346	i0	99.58	1	238	1	100	0	1	238	3340195	3340432	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	238	435	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
10583026	10583026	PRJNA312899_P_NODE_18629_length_437_cov_15.041237_g18188_i0	PRJNA312899	18629	437	15.041237	65.73020569	Nitrospira moscoviensis	42253	Bacteria	Bacteria	289	2.96e-73	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g18188	i0	82.424	3.53775743707094	330	58	76	0	20	349	3958538	3958867	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	1546	289	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
15682311	15682311	PRJNA312899_P_NODE_44893_length_263_cov_4.906542_g44451_i0	PRJNA312899	44893	263	4.906542	12.90420546	Candidatus Nitrospira inopinata	1715989	Bacteria	Bacteria	309	1.29e-79	NTclustered	gi\|952974062\|emb\|LN885086.1\|	1715989	g44451	i0	88.327	2.98479087452471	257	30	98	0	1	257	2908728	2908984	Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1	blastn	785	309	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira inopinata
16367419	16367419	PRJNA312899_P_NODE_68413_length_197_cov_1.993243_g67971_i0	PRJNA312899	68413	197	1.993243	3.92668871	Nitrospira	1234	Bacteria	Bacteria	364	1.929999999999999e-96	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g67971	i0	100	354.720812182741	197	0	100	0	1	197	1278292	1278096	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	69880	364	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
17642683	17642683	PRJNA312899_P_NODE_82514_length_174_cov_1.632000_g82072_i0	PRJNA312899	82514	174	1.632	2.83968	Nitrospira	1234	Bacteria	Bacteria	254	3.74e-63	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g82072	i0	93.103	31.0287356321839	174	11	100	1	1	174	798864	799036	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	5399	254	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
18231509	18231509	PRJNA312899_P_NODE_57495_length_224_cov_4.388571_g57053_i0	PRJNA312899	57495	224	4.388571	9.83039904	Nitrospira sp.	70125	Bacteria	Bacteria	215	2.4e-51	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g57053	i0	84.234	0.991071428571429	222	33	99	2	4	224	2326901	2326681	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	222	215	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
18915708	18915708	PRJNA312899_P_NODE_10355_length_587_cov_138.169145_g9944_i0	PRJNA312899	10355	587	138.169145	811.05288115	Nitrospira	1234	Bacteria	Bacteria	449	1.7599999999999998e-121	NTclustered	gi\|2194432121\|gb\|CP092081.1\|	70125	g9944	i0	81.09	2.98466780238501	587	90	100	13	1	587	1642220	1642785	MAG: Nitrospira sp. isolate UBC2 chromosome	blastn	1752	453	0.991169977924945	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24606109	24606109	PRJNA312899_P_NODE_70660_length_192_cov_1.426573_g70218_i0	PRJNA312899	70660	192	1.426573	2.73902016	Nitrospira sp.	70125	Bacteria	Bacteria	316	5.31e-82	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g70218	i0	96.373	40.1197916666667	193	6	100	1	1	192	201375	201567	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	7703	316	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);;