metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_clade = "Nitrospinota/Tectimicrobiota group"

4 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_clade = "Nitrospinota/Tectimicrobiota group"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
8017971	8017971	PRJNA168635_P_NODE_33247_length_158_cov_5.357798_g32831_i0	PRJNA168635	33247	158	5.357798	8.46532084	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	143	7.53e-30	NTclustered	gi\|2531976037\|emb\|OY282375.1\|	312019	g32831	i0	90.654	1.36075949367089	107	10	68	0	50	156	4200027	4200133	MAG: uncultured Candidatus Entotheonella sp. genome assembly, chromosome: 1	blastn	215	143	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
15667461	15667461	PRJNA168635_P_NODE_33053_length_159_cov_3.336364_g32637_i0	PRJNA168635	33053	159	3.336364	5.30481876	Candidatus Nitronauta litoralis	2705533	Bacteria	Bacteria	143	7.589999999999999e-30	NTclustered	gi\|1938439011\|gb\|CP048685.1\|	2705533	g32637	i0	88.43	227.358490566038	121	10	74	3	40	157	3876379	3876498	MAG: Candidatus Nitronauta litoralis isolate EB chromosome, complete genome	blastn	36150	143	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitronauta	Candidatus Nitronauta litoralis
16942060	16942060	PRJNA168635_P_NODE_9994_length_262_cov_5.713615_g9579_i0	PRJNA168635	9994	262	5.713615	14.9696713	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	326	1.2799999999999999e-84	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g9579	i0	89.272	210.954198473282	261	26	99	2	3	262	2629747	2630006	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	55270	326	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
21455909	21455909	PRJNA168635_P_NODE_10577_length_253_cov_16.220588_g10162_i0	PRJNA168635	10577	253	16.220588	41.03808764	Pseudomonadati	3379134	Bacteria	Bacteria	231	2.75e-56	NTclustered	gi\|118340518\|gb\|EF106972.1\|	482920	g10162	i0	83.268	611.268774703557	257	37	100	6	1	253	37199	36945	Uncultured marine Nitrospinaceae bacterium clone EB080L20_F04, partial sequence	blastn	154651	231	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae		uncultured marine Nitrospinaceae 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);;