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

8 rows where bioproject = "PRJNA771359" 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
2023073	2023073	PRJNA771359_S_NODE_522_length_435_cov_6.077889_g439_i0	PRJNA771359	522	435	6.077889	26.43881715	Nitrospira sp.	70125	Bacteria	Bacteria	699	0	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g439	i0	95.833	521.597701149425	432	18	99	0	1	432	2683879	2683448	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	226895	699	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
3298247	3298247	PRJNA771359_S_NODE_3343_length_183_cov_3.815068_g3260_i0	PRJNA771359	3343	183	3.815068	6.98157444	Nitrospira sp.	70125	Bacteria	Bacteria	117	5.45e-22	NTclustered	gi\|2511631678\|gb\|CP126123.1\|	70125	g3260	i0	78.919	68.6612021857923	185	30	99	8	2	183	1528848	1529026	MAG: Nitrospira sp. isolate bin_003 chromosome, complete genome	blastn	12565	117	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
5850592	5850592	PRJNA771359_S_NODE_3385_length_182_cov_5.427586_g3302_i0	PRJNA771359	3385	182	5.427586	9.87820652	Nitrospira sp.	70125	Bacteria	Bacteria	309	8.32e-80	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g3302	i0	97.253	159.978021978022	182	5	100	0	1	182	201368	201549	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	29116	309	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
7584807	7584807	PRJNA771359_S_NODE_3146_length_189_cov_3.598684_g3063_i0	PRJNA771359	3146	189	3.598684	6.80151276	Nitrospira	1234	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g3063	i0	100	319.772486772487	189	0	100	0	1	189	1278185	1278373	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	60437	350	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
9675495	9675495	PRJNA771359_S_NODE_4008_length_168_cov_3.221374_g3925_i0	PRJNA771359	4008	168	3.221374	5.41190832	Nitrospira tepida	2973512	Bacteria	Bacteria	211	2.2e-50	NTclustered	gi\|2526808154\|emb\|OX365700.1\|	2973512	g3925	i0	89.286	471.779761904762	168	18	100	0	1	168	1826314	1826481	Nitrospira sp. DNF genome assembly, chromosome: NsDNF	blastn	79259	211	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira tepida
10951180	10951180	PRJNA771359_S_NODE_769_length_362_cov_7.101538_g686_i0	PRJNA771359	769	362	7.101538	25.70756756	Nitrospira moscoviensis	42253	Bacteria	Bacteria	462	1.34e-125	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g686	i0	89.863	117.917127071823	365	30	100	7	1	362	1277631	1277271	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	42686	462	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
24973692	24973692	PRJNA771359_S_NODE_5220_length_150_cov_2.548673_g5137_i0	PRJNA771359	5220	150	2.548673	3.8230095	Nitrospira sp.	70125	Bacteria	Bacteria	272	8.609999999999998e-69	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g5137	i0	99.333	212.993333333333	150	1	100	0	1	150	199978	200127	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	31949	272	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
25433424	25433424	PRJNA771359_S_NODE_3940_length_169_cov_6.446970_g3857_i0	PRJNA771359	3940	169	6.44697	10.8953793	Nitrospira	1234	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g3857	i0	100	116.343195266272	169	0	100	0	1	169	1278203	1278035	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	19662	313	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis

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