metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1069776" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1069776" and tax_phylum = "Bacteroidota"

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
185008	185008	PRJNA1069776_S_NODE_53641_length_151_cov_4.712963_g53327_i0	PRJNA1069776	53641	151	4.712963	7.11657413	Paludibacter propionicigenes	185300	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|312441806\|gb\|CP002345.1\|	694427	g53327	i0	100	0.185430463576159	28	0	19	0	69	96	731637	731610	Paludibacter propionicigenes WB4, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae	Paludibacter	Paludibacter propionicigenes
1459310	1459310	PRJNA1069776_S_NODE_25302_length_212_cov_3.692308_g24988_i0	PRJNA1069776	25302	212	3.692308	7.82769296	Porphyromonadaceae bacterium	2049046	Bacteria	Bacteria	337	4.599999999999998e-88	NTclustered	gi\|2189488613\|gb\|CP091732.1\|	2049046	g24988	i0	95.305	1.00471698113208	213	9	100	1	1	212	2805795	2805583	MAG: Porphyromonadaceae bacterium isolate nC29_bin.32.fa chromosome	blastn	213	337	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae		Porphyromonadaceae bacterium
1459636	1459636	PRJNA1069776_S_NODE_5342_length_367_cov_10.327160_g5028_i0	PRJNA1069776	5342	367	10.32716	37.9006772	Segatella copri	165179	Bacteria	Bacteria	667	0	NTclustered	gi\|2726128879\|gb\|CP152352.1\|	165179	g5028	i0	99.455	2.83651226158038	367	2	100	0	1	367	3084427	3084793	Segatella copri strain HDD05 chromosome, complete genome	blastn	1041	667	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
3565308	3565308	PRJNA1069776_S_NODE_43903_length_166_cov_1.951220_g43589_i0	PRJNA1069776	43903	166	1.95122	3.2390252	Prevotella	838	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2028882546\|gb\|CP072373.1\|	28129	g43589	i0	99.398	7	166	1	100	0	1	166	2616509	2616344	Prevotella denticola strain F0119 chromosome, complete genome	blastn	1162	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella denticola
5287884	5287884	PRJNA1069776_S_NODE_7625_length_334_cov_1.814433_g7311_i0	PRJNA1069776	7625	334	1.814433	6.06020622	Flavobacterium aestivum	3003257	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2477602438\|gb\|CP113977.2\|	3003257	g7311	i0	96.774	0.092814371257485	31	1	9	0	182	212	136883	136913	Flavobacterium aestivum isolate IMCC34774 chromosome, complete genome	blastn	31	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium aestivum
8667827	8667827	PRJNA1069776_S_NODE_27527_length_205_cov_1.185185_g27213_i0	PRJNA1069776	27527	205	1.185185	2.42962925	Segatella	2974251	Bacteria	Bacteria	368	1.57e-97	NTclustered	gi\|2726125546\|gb\|CP152484.1\|	165179	g27213	i0	99.505	15.9268292682927	202	1	99	0	4	205	372930	373131	Segatella copri strain HDD04 chromosome, complete genome	blastn	3265	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
9112672	9112672	PRJNA1069776_S_NODE_7508_length_335_cov_5.178082_g7194_i0	PRJNA1069776	7508	335	5.178082	17.3465747	uncultured Porphyromonadaceae bacterium	348578	Bacteria	Bacteria	93.5	1.86e-14	NTclustered	gi\|2729058688\|emb\|OZ006988.1\|	348578	g7194	i0	90.278	0.985074626865672	72	5	21	2	58	129	2480975	2481044	MAG: uncultured Porphyromonadaceae bacterium isolate 6732_HOM_VAC_contig_38_metaflye_large MAG genome assembly, chromosome: 1	blastn	330	93.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae		uncultured Porphyromonadaceae bacterium
9112673	9112673	PRJNA1069776_S_NODE_7768_length_332_cov_2.422145_g7454_i0	PRJNA1069776	7768	332	2.422145	8.0415214	Prevotella sp. E15-22	2937774	Bacteria	Bacteria	514	3.32e-141	NTclustered	gi\|2232746504\|gb\|CP096247.1\|	2937774	g7454	i0	94.611	1.00602409638554	334	15	100	3	1	332	3180442	3180774	Prevotella sp. E15-22 chromosome, complete genome	blastn	334	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. E15-22
10387758	10387758	PRJNA1069776_S_NODE_11289_length_294_cov_13.960159_g10975_i0	PRJNA1069776	11289	294	13.960159	41.04286746	Bernardetia litoralis	999	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|390526782\|gb\|CP003345.1\|	880071	g10975	i0	89.13	0.156462585034014	46	4	15	1	22	66	3543860	3543905	Bernardetia litoralis DSM 6794 chromosome, complete genome	blastn	46	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Bernardetiaceae	Bernardetia	Bernardetia litoralis
11217995	11217995	PRJNA1069776_S_NODE_13369_length_277_cov_3.123932_g13055_i0	PRJNA1069776	13369	277	3.123932	8.65329164	Aquirufa	2676247	Bacteria	Bacteria	276	1.39e-69	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g13055	i0	84.752	78.8880866425993	282	36	100	6	1	277	214101	214380	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	21852	276	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
14213601	14213601	PRJNA1069776_S_NODE_42812_length_168_cov_1.536000_g42498_i0	PRJNA1069776	42812	168	1.536	2.58048	Echinicola sp. 20G	2781961	Bacteria	Bacteria	134	4.9000000000000005e-27	NTclustered	gi\|1929905271\|dbj\|AP024154.1\|	2781961	g42498	i0	83.688	0.839285714285714	141	23	84	0	2	142	743800	743940	Echinicola sp. 20G DNA, nearly complete genome	blastn	141	134	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Echinicola	Echinicola sp. 20G
15487616	15487616	PRJNA1069776_S_NODE_44873_length_164_cov_3.173554_g44559_i0	PRJNA1069776	44873	164	3.173554	5.20462856	Pedobacter sp. PAMC26386	2762321	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1896684178\|gb\|CP060294.1\|	2762321	g44559	i0	96.875	0.195121951219512	32	1	20	0	62	93	1461333	1461364	Pedobacter sp. PAMC26386 chromosome, complete genome	blastn	32	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. PAMC26386
19310141	19310141	PRJNA1069776_S_NODE_12196_length_286_cov_9.255144_g11882_i0	PRJNA1069776	12196	286	9.255144	26.46971184	Dysgonomonadaceae bacterium zrk40	2811465	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|1992198317\|gb\|CP070276.1\|	2811465	g11882	i0	100	124.472027972028	286	0	100	0	1	286	3008877	3009162	Dysgonomonadaceae bacterium zrk40 chromosome, complete genome	blastn	35599	529	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae		Dysgonomonadaceae bacterium zrk40
24410546	24410546	PRJNA1069776_S_NODE_21280_length_229_cov_3.021505_g20966_i0	PRJNA1069776	21280	229	3.021505	6.91924645	Bacteroides sp. D2	556259	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2299295056\|gb\|CP102261.1\|	556259	g20966	i0	100	0.122270742358079	28	0	12	0	112	139	2908193	2908220	Bacteroides sp. D2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp. D2
24410834	24410834	PRJNA1069776_S_NODE_43740_length_166_cov_2.951220_g43426_i0	PRJNA1069776	43740	166	2.95122	4.8990252	Parabacteroides absconsus	2951805	Bacteria	Bacteria	219	1.3e-52	NTclustered	gi\|2695680047\|gb\|CP146284.1\|	2951805	g43426	i0	91.25	468.78313253012	160	14	96	0	1	160	2518841	2519000	Parabacteroides absconsus strain AD58 chromosome, complete genome	blastn	77818	219	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides absconsus

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