metadata: contig_metadata: 9 rows where bioproject = "PRJNA983838", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJNA983838", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Altimarinota"

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_clade	tax_phylum	tax_species
2240572	2240572	PRJNA983838_P_NODE_48122_length_445_cov_2.026882_g45756_i0	PRJNA983838	48122	445	2.026882	9.0196249	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	292	2.3299999999999993e-74	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g45756	i0	80.189	6.60224719101124	424	56	92	24	36	445	1250381	1250790	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	2938	292	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium 28_42_T64
25192164	25192164	PRJNA983838_P_NODE_89900_length_278_cov_1.521951_g87533_i0	PRJNA983838	89900	278	1.521951	4.23102378	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	121	1.19e-30	NR	MDP5038888.1	2044595	g87533	i0	77.6	2.43884892086331	76	17	82	0	278	51	88	163	MDP5038888.1 AAA family ATPase [Candidatus Altimarinota bacterium]	diamond	678	121	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
26614612	26614612	PRJNA983838_P_NODE_118121_length_242_cov_1.846154_g115754_i0	PRJNA983838	118121	242	1.846154	4.46769268	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	91.7	2.24e-19	NR	MBW7954223.1	2044595	g115754	i0	72	0.929752066115702	75	19	90.5	2	22	240	209	283	MBW7954223.1 translation initiation factor IF-2 [Candidatus Altimarinota bacterium]	diamond	225	91.7	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
27595174	27595174	PRJNA983838_P_NODE_118984_length_242_cov_0.923077_g116617_i0	PRJNA983838	118984	242	0.923077	2.23384634	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	81.6	5.21e-17	NR	MDP5038976.1	2044595	g116617	i0	63.9	1.56198347107438	61	22	75.6	0	49	231	48	108	MDP5038976.1 HD domain-containing protein [Candidatus Altimarinota bacterium]	diamond	378	81.6	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
28100089	28100089	PRJNA983838_P_NODE_87065_length_283_cov_7.223810_g84698_i0	PRJNA983838	87065	283	7.22381	20.4433823	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	43.9	0.0213	NR	NUJ98053.1	2044595	g84698	i0	41.3	0.795053003533569	75	35	74.2	2	69	278	237	307	NUJ98053.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	225	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
28573743	28573743	PRJNA983838_P_NODE_114267_length_245_cov_1.616279_g111900_i0	PRJNA983838	114267	245	1.616279	3.95988355	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	98.6	8.74e-22	NR	MBW7954443.1	2044595	g111900	i0	70.3	0.906122448979592	74	21	89.4	1	2	220	1223	1296	MBW7954443.1 PKD domain-containing protein [Candidatus Altimarinota bacterium]	diamond	222	98.6	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
28637213	28637213	PRJNA983838_P_NODE_66127_length_345_cov_1.562500_g63760_i0	PRJNA983838	66127	345	1.5625	5.390625	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	110	2.1999999999999997e-25	NR	MDD2745034.1	2044595	g63760	i0	54.2	1.04347826086957	120	49	100	3	1	345	885	1003	MDD2745034.1 S-layer homology domain-containing protein [Candidatus Altimarinota bacterium]	diamond	360	110	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
30626483	30626483	PRJNA983838_P_NODE_115253_length_244_cov_2.467836_g112886_i0	PRJNA983838	115253	244	2.467836	6.02151984	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	65.5	6.91e-11	NR	MCK9272699.1	2044595	g112886	i0	58	1.99180327868852	81	31	99.6	1	1	243	103	180	MCK9272699.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	486	65.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
32176204	32176204	PRJNA983838_P_NODE_20518_length_915_cov_3.926366_g18492_i0	PRJNA983838	20518	915	3.926366	35.9262489	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	154	3.02e-40	NR	MDD4151141.1	2044595	g18492	i0	35.5	1.01639344262295	310	135	97.7	7	912	19	3	259	MDD4151141.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	930	154	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota 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);;