metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Elusimicrobiota"

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
1878599	1878599	PRJNA630162_P_NODE_56382_length_235_cov_1.096774_g54859_i0	PRJNA630162	56382	235	1.096774	2.5774189	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	390	3.93e-104	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g54859	i0	98.214	56.6212765957447	224	3	95	1	5	227	522854	522631	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	13306	390	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
3152330	3152330	PRJNA630162_P_NODE_109563_length_180_cov_1.396947_g108040_i0	PRJNA630162	109563	180	1.396947	2.5145046	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	233	5.08e-57	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g108040	i0	95.89	13.3388888888889	146	2	97	4	36	179	3536944	3536801	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	2401	233	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
3152771	3152771	PRJNA630162_P_NODE_158123_length_162_cov_3.203540_g156600_i0	PRJNA630162	158123	162	3.20354	5.1897348	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	178	2.13e-40	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g156600	i0	91.045	321.308641975309	134	9	82	2	6	138	581980	582111	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	52052	178	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia bacterium
4979785	4979785	PRJNA630162_P_NODE_75284_length_207_cov_2.398734_g73761_i0	PRJNA630162	75284	207	2.398734	4.96537938	Elusimicrobium	423604	Bacteria	Bacteria	202	1.6999999999999996e-47	NTclustered	gi\|470483159\|ref\|NR_076577.1\|	423605	g73761	i0	89.375	70.1111111111111	160	17	77	0	43	202	2261	2102	Elusimicrobium minutum strain Pei191 23S ribosomal RNA gene, complete sequence	blastn	14513	202	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Elusimicrobium	Elusimicrobium minutum
8255940	8255940	PRJNA630162_P_NODE_8947_length_642_cov_2.657673_g7584_i0	PRJNA630162	8947	642	2.657673	17.06226066	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	555	3.989999999999999e-153	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g7584	i0	83.802	214.006230529595	605	76	92	19	14	603	581952	582549	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	137392	555	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia bacterium
8256042	8256042	PRJNA630162_P_NODE_98667_length_186_cov_2.394161_g97144_i0	PRJNA630162	98667	186	2.394161	4.45313946	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	300	5.1400000000000004e-77	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g97144	i0	96.175	28.2795698924731	183	7	98	0	4	186	3537651	3537469	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	5260	300	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
9530553	9530553	PRJNA630162_P_NODE_21688_length_395_cov_3.395954_g20170_i0	PRJNA630162	21688	395	3.395954	13.4140183	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	374	7.1e-99	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g20170	i0	83.92	166.313924050633	398	57	99	6	1	394	522833	523227	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	65694	374	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
12082124	12082124	PRJNA630162_P_NODE_82890_length_198_cov_2.624161_g81367_i0	PRJNA630162	82890	198	2.624161	5.19583878	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	283	5.589999999999999e-72	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g81367	i0	93.229	143.333333333333	192	13	97	0	1	192	129032	129223	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	28380	283	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae		Endomicrobiaceae bacterium
13357052	13357052	PRJNA630162_P_NODE_96751_length_187_cov_3.231884_g95228_i0	PRJNA630162	96751	187	3.231884	6.04362308	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	106	1.21e-18	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g95228	i0	79.874	73.2245989304813	159	21	81	7	35	186	3537794	3537640	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	13693	106	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
14630910	14630910	PRJNA630162_P_NODE_172192_length_152_cov_2.747573_g170669_i0	PRJNA630162	172192	152	2.747573	4.17631096	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	89.8	9.47e-14	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g170669	i0	96.364	61.6447368421053	55	0	36	1	93	147	523894	523946	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	9370	89.8	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
14631610	14631610	PRJNA630162_P_NODE_79532_length_202_cov_1.143791_g78009_i0	PRJNA630162	79532	202	1.143791	2.31045782	Candidatus Endomicrobium sp. MdMp-027	1837116	Bacteria	Bacteria	80.5	8.07e-11	NTclustered	gi\|1069559510\|dbj\|LC153126.1\|	1837116	g78009	i0	87.013	16.0594059405941	77	3	38	6	17	92	1421	1491	Candidatus Endomicrobium sp. MdMp-027 gene for 23S rRNA, partial sequence	blastn	3244	80.5	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobium	Candidatus Endomicrobium sp. MdMp-027
15179905	15179905	PRJNA630162_P_NODE_55772_length_236_cov_1.914439_g54249_i0	PRJNA630162	55772	236	1.914439	4.51807604	Elusimicrobium	423604	Bacteria	Bacteria	215	2.55e-51	NTclustered	gi\|470483159\|ref\|NR_076577.1\|	423605	g54249	i0	83.682	116.029661016949	239	28	99	9	1	233	273	40	Elusimicrobium minutum strain Pei191 23S ribosomal RNA gene, complete sequence	blastn	27383	215	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Elusimicrobium	Elusimicrobium minutum
18453406	18453406	PRJNA630162_P_NODE_10995_length_576_cov_2.891841_g9556_i0	PRJNA630162	10995	576	2.891841	16.65700416	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	568	4.5699999999999985e-157	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g9556	i0	85.714	113.303819444444	560	54	96	16	25	576	523836	523295	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	65263	568	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
18453565	18453565	PRJNA630162_P_NODE_127455_length_170_cov_4.132231_g125932_i0	PRJNA630162	127455	170	4.132231	7.0247927	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	141	2.95e-29	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g125932	i0	93.617	108.323529411765	94	6	55	0	31	124	523893	523986	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	18415	141	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
18454423	18454423	PRJNA630162_P_NODE_50975_length_247_cov_1.398990_g49452_i0	PRJNA630162	50975	247	1.39899	3.4555053	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	411	3.199999999999999e-110	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g49452	i0	97.89	345.894736842105	237	5	96	0	3	239	3536234	3536470	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	85436	411	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
22279669	22279669	PRJNA630162_P_NODE_67098_length_216_cov_1.664671_g65575_i0	PRJNA630162	67098	216	1.664671	3.59568936	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	294	2.87e-75	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g65575	i0	91.628	72.4814814814815	215	14	99	4	1	213	3537305	3537517	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	15656	294	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
24103201	24103201	PRJNA630162_P_NODE_170879_length_153_cov_3.432692_g169356_i0	PRJNA630162	170879	153	3.432692	5.25201876	Elusimicrobium	423604	Bacteria	Bacteria	156	9.29e-34	NTclustered	gi\|470483159\|ref\|NR_076577.1\|	423605	g169356	i0	86.806	31.5816993464052	144	14	93	5	9	151	1581	1442	Elusimicrobium minutum strain Pei191 23S ribosomal RNA gene, complete sequence	blastn	4832	156	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Elusimicrobium	Elusimicrobium minutum

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