metadata: contig_metadata: 5 rows where bioproject = "PRJNA274362" and tax

5 rows where bioproject = "PRJNA274362" 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
9298395	9298395	PRJNA274362_S_NODE_13148_length_245_cov_1.653061_g13028_i0	PRJNA274362	13148	245	1.653061	4.04999945	Nitrospira defluvii	330214	Bacteria	Bacteria	409	1.1399999999999998e-109	NTclustered	gi\|470491451\|ref\|NR_077039.1\|	330214	g13028	i0	96.735	100.70612244898	245	8	100	0	1	245	1291	1535	Candidatus Nitrospira defluvii 23S ribosomal RNA, complete sequence	blastn	24673	409	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
9299035	9299035	PRJNA274362_S_NODE_9048_length_287_cov_1.067227_g8928_i0	PRJNA274362	9048	287	1.067227	3.06294149	Nitrospira defluvii	330214	Bacteria	Bacteria	514	2.82e-141	NTclustered	gi\|470491451\|ref\|NR_077039.1\|	330214	g8928	i0	98.955	138.547038327526	287	3	100	0	1	287	1802	1516	Candidatus Nitrospira defluvii 23S ribosomal RNA, complete sequence	blastn	39763	514	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
14399454	14399454	PRJNA274362_S_NODE_18172_length_214_cov_1.587879_g18052_i0	PRJNA274362	18172	214	1.587879	3.39806106	Nitrospira defluvii	330214	Bacteria	Bacteria	390	3.519999999999999e-104	NTclustered	gi\|470491451\|ref\|NR_077039.1\|	330214	g18052	i0	99.533	365.841121495327	214	1	100	0	1	214	337	550	Candidatus Nitrospira defluvii 23S ribosomal RNA, complete sequence	blastn	78290	390	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
18222373	18222373	PRJNA274362_S_NODE_2915_length_481_cov_2.215278_g2796_i0	PRJNA274362	2915	481	2.215278	10.65548718	Nitrospira defluvii	330214	Bacteria	Bacteria	845	0	NTclustered	gi\|470491451\|ref\|NR_077039.1\|	330214	g2796	i0	98.337	149.775467775468	481	8	100	0	1	481	1031	551	Candidatus Nitrospira defluvii 23S ribosomal RNA, complete sequence	blastn	72042	845	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
23322924	23322924	PRJNA274362_S_NODE_6299_length_338_cov_1.515571_g6179_i0	PRJNA274362	6299	338	1.515571	5.12262998	Nitrospira defluvii	330214	Bacteria	Bacteria	531	3.36e-146	NTclustered	gi\|470491451\|ref\|NR_077039.1\|	330214	g6179	i0	95.252	213.988165680473	337	13	99	3	1	336	366	32	Candidatus Nitrospira defluvii 23S ribosomal RNA, complete sequence	blastn	72328	531	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii

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