metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA1199893" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA1199893" and tax_superkingdom = "Bacteria"

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
1044692	1044692	PRJNA1199893_P_NODE_14701_length_249_cov_1.227273_g14626_i0	PRJNA1199893	14701	249	1.227273	3.05590977	Glutamicibacter	1742989	Bacteria	Bacteria	422	1.49e-113	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g14626	i0	97.189	441.971887550201	249	7	100	0	1	249	100792	100544	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	110051	422	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
1601290	1601290	PRJNA1199893_P_NODE_11782_length_279_cov_1.199029_g11707_i0	PRJNA1199893	11782	279	1.199029	3.34529091	Raineyella sp. LH-20	3081204	Bacteria	Bacteria	388	1.7199999999999998e-103	NTclustered	gi\|2606726494\|gb\|CP137003.1\|	3081204	g11707	i0	91.786	250.666666666667	280	21	100	2	1	279	99714	99992	Raineyella sp. LH-20 chromosome, complete genome	blastn	69936	388	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Raineyella	Raineyella sp. LH-20
1601437	1601437	PRJNA1199893_P_NODE_16642_length_243_cov_1.788235_g16567_i0	PRJNA1199893	16642	243	1.788235	4.34541105	uncultured Pseudomonadota bacterium	153809	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|110754529\|gb\|DQ829216.1\|	153809	g16567	i0	99.177	99.0411522633745	243	2	100	0	1	243	270	28	Uncultured proteobacterium clone DOK_NOFERT_clone243 16S ribosomal RNA gene, partial sequence	blastn	24067	438	1	Bacteria		Pseudomonadati	Pseudomonadota					uncultured Pseudomonadota bacterium
2877819	2877819	PRJNA1199893_P_NODE_8283_length_332_cov_0.737452_g8208_i0	PRJNA1199893	8283	332	0.737452	2.44834064	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	599	8.909999999999998e-167	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g8208	i0	99.394	355.972891566265	330	2	99	0	1	330	293068	293397	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	118183	599	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
7980274	7980274	PRJNA1199893_P_NODE_2947_length_559_cov_2.843621_g2874_i0	PRJNA1199893	2947	559	2.843621	15.89584139	Halopseudomonas phragmitis	1931241	Bacteria	Bacteria	815	0	NTclustered	gi\|1162906871\|gb\|CP020100.1\|	1931241	g2874	i0	93.19	381.270125223614	558	33	99	5	1	555	377086	376531	Halopseudomonas phragmitis strain S-6-2 chromosome, complete genome	blastn	213130	815	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Halopseudomonas	Halopseudomonas phragmitis
8697590	8697590	PRJNA1199893_P_NODE_16887_length_243_cov_0.905882_g16812_i0	PRJNA1199893	16887	243	0.905882	2.20129326	Vibrio	662	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|1858855023\|gb\|CP053808.1\|	666	g16812	i0	99.588	847.80658436214	243	1	100	0	1	243	2575352	2575110	Vibrio cholerae strain SP7G chromosome 1, complete sequence	blastn	206017	444	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio cholerae
8697591	8697591	PRJNA1199893_P_NODE_17147_length_242_cov_0.911243_g17072_i0	PRJNA1199893	17147	242	0.911243	2.20520806	Listeria	1637	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1958359519\|gb\|CP068150.1\|	1639	g17072	i0	96.875	2.3801652892562	32	0	13	1	94	124	2829987	2830018	Listeria monocytogenes strain FDAARGOS_1080 chromosome, complete genome	blastn	576	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
9972742	9972742	PRJNA1199893_P_NODE_14188_length_251_cov_0.865169_g14113_i0	PRJNA1199893	14188	251	0.865169	2.17157419	Geobacter	28231	Bacteria	Bacteria	364	2.57e-96	NTclustered	gi\|2499315885\|dbj\|AP028061.1\|	1260928	g14113	i0	92.829	41.4661354581673	251	18	100	0	1	251	2006290	2006040	Geobacter sulfurreducens subsp. ethanolicus OSK2A DNA, complete genome	blastn	10408	364	1	Bacteria		Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
9972748	9972748	PRJNA1199893_P_NODE_16728_length_243_cov_0.905882_g16653_i0	PRJNA1199893	16728	243	0.905882	2.20129326	Lacticaseibacillus	2759736	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1917898043\|gb\|CP049324.1\|	1597	g16653	i0	100	100	243	0	100	0	1	243	1350986	1350744	Lacticaseibacillus paracasei strain NSMJ15 chromosome	blastn	24300	449	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei
10530497	10530497	PRJNA1199893_P_NODE_14089_length_251_cov_1.387640_g14014_i0	PRJNA1199893	14089	251	1.38764	3.4829764	Vibrio metoecus	1481663	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2556688018\|gb\|CP129421.1\|	1481663	g14014	i0	99.203	4	251	2	100	0	1	251	1674412	1674162	Vibrio metoecus strain ZF102 chromosome 1, complete sequence	blastn	1004	453	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio metoecus
10530522	10530522	PRJNA1199893_P_NODE_14829_length_249_cov_0.875000_g14754_i0	PRJNA1199893	14829	249	0.875	2.17875	Streptococcus sp. 116-D4	2598453	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1778008955\|dbj\|AP021887.1\|	2598453	g14754	i0	100	328	249	0	100	0	1	249	19375	19127	Streptococcus sp. 116-D4 DNA, complete genome	blastn	81672	460	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. 116-D4
10530676	10530676	PRJNA1199893_P_NODE_449_length_1265_cov_3.327181_g416_i0	PRJNA1199893	449	1265	3.327181	42.08883965	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1777	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g416	i0	92.047	147.522529644269	1270	92	100	9	1	1265	2893	1628	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	186616	1777	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10530801	10530801	PRJNA1199893_P_NODE_9849_length_304_cov_1.320346_g9774_i0	PRJNA1199893	9849	304	1.320346	4.01385184	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g9774	i0	100	0.0921052631578947	28	0	9	0	135	162	703756	703783	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
11247929	11247929	PRJNA1199893_P_NODE_11869_length_278_cov_1.292683_g11794_i0	PRJNA1199893	11869	278	1.292683	3.59365874	Aeromonas	642	Bacteria	Bacteria	508	1.26e-139	NTclustered	gi\|2812549515\|emb\|OY731314.1\|	650	g11794	i0	99.64	100.320143884892	278	1	100	0	1	278	725302	725025	Aeromonas jandaei isolate KMC7K genome assembly, chromosome: 1	blastn	27889	508	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas jandaei
11247963	11247963	PRJNA1199893_P_NODE_5549_length_408_cov_1.167164_g5475_i0	PRJNA1199893	5549	408	1.167164	4.76202912	Actinomycetes	1760	Bacteria	Bacteria	649	0	NTclustered	gi\|254972631\|gb\|GQ329251.1\|	114050	g5475	i0	95.355	121.291666666667	409	18	100	1	1	408	136	544	Uncultured Arthrobacter sp. clone P4s-190 16S ribosomal RNA gene, partial sequence	blastn	49487	652	0.995398773006135	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	uncultured Arthrobacter sp.
12523374	12523374	PRJNA1199893_P_NODE_6030_length_391_cov_2.314465_g5956_i0	PRJNA1199893	6030	391	2.314465	9.04955815	Pseudomonas	286	Bacteria	Bacteria	712	0	NTclustered	gi\|2323004093\|gb\|CP109603.1\|	303	g5956	i0	99.742	615.726342710997	388	1	100	0	1	388	4241	4628	Pseudomonas putida strain SEH01 chromosome, complete genome	blastn	240749	712	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas putida
13080356	13080356	PRJNA1199893_P_NODE_16431_length_244_cov_0.900585_g16356_i0	PRJNA1199893	16431	244	0.900585	2.1974274	Corynebacterium minutissimum	38301	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1403572617\|emb\|LS483460.1\|	38301	g16356	i0	100	7.21311475409836	244	0	100	0	1	244	171178	171421	Corynebacterium minutissimum strain NCTC10288 genome assembly, chromosome: 1	blastn	1760	451	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium minutissimum
13798035	13798035	PRJNA1199893_P_NODE_7391_length_353_cov_1.650000_g7316_i0	PRJNA1199893	7391	353	1.65	5.8245	Vibrio	662	Bacteria	Bacteria	647	0	NTclustered	gi\|2556688018\|gb\|CP129421.1\|	1481663	g7316	i0	99.717	100.512747875354	353	1	100	0	1	353	2811450	2811098	Vibrio metoecus strain ZF102 chromosome 1, complete sequence	blastn	35481	647	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio metoecus
14355837	14355837	PRJNA1199893_P_NODE_5112_length_425_cov_2.303977_g5039_i0	PRJNA1199893	5112	425	2.303977	9.79190225	Corynebacterium kefirresidentii	1979527	Bacteria	Bacteria	756	0	NTclustered	gi\|2869819920\|gb\|CP175795.1\|	1979527	g5039	i0	98.824	361.771764705882	425	4	99	1	2	425	788415	787991	Corynebacterium kefirresidentii strain YSMAA1_1_C6 chromosome, complete genome	blastn	153753	756	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
15629527	15629527	PRJNA1199893_P_NODE_14333_length_250_cov_2.632768_g14258_i0	PRJNA1199893	14333	250	2.632768	6.58192	Vibrio metoecus	1481663	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2556688018\|gb\|CP129421.1\|	1481663	g14258	i0	99.2	883.308	250	2	100	0	1	250	146203	145954	Vibrio metoecus strain ZF102 chromosome 1, complete sequence	blastn	220827	451	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio metoecus
16904009	16904009	PRJNA1199893_P_NODE_7074_length_361_cov_2.243056_g7000_i0	PRJNA1199893	7074	361	2.243056	8.09743216	Acinetobacter baumannii	470	Bacteria	Bacteria	390	6.38e-104	NTclustered	gi\|1638218938\|gb\|CP040047.1\|	470	g7000	i0	86.798	569.01108033241	356	20	100	15	27	361	3293293	3292944	Acinetobacter baumannii strain VB1190 chromosome, complete genome	blastn	205413	390	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
17622379	17622379	PRJNA1199893_P_NODE_13614_length_257_cov_1.010870_g13539_i0	PRJNA1199893	13614	257	1.01087	2.5979359	Lacticaseibacillus	2759736	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|1845309819\|gb\|CP053619.1\|	47715	g13539	i0	100	455.933852140078	257	0	100	0	1	257	546695	546439	Lacticaseibacillus rhamnosus strain LV108 chromosome, complete genome	blastn	117175	475	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus rhamnosus
17622386	17622386	PRJNA1199893_P_NODE_15654_length_246_cov_2.000000_g15579_i0	PRJNA1199893	15654	246	2	4.92	Psychrobacter	497	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|307335075\|gb\|HM236417.1\|	180588	g15579	i0	100	370.792682926829	246	0	100	0	1	246	1457	1702	Psychrobacter faecalis strain DSM 14664 23S ribosomal RNA gene, partial sequence	blastn	91215	455	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Psychrobacter	Psychrobacter faecalis
17622395	17622395	PRJNA1199893_P_NODE_4014_length_478_cov_1.217284_g3941_i0	PRJNA1199893	4014	478	1.217284	5.81861752	Bacteria	2	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|2209700036\|dbj\|AP025668.1\|	1912	g3941	i0	96.875	1.66317991631799	32	1	7	0	368	399	2208162	2208193	Streptomyces hygroscopicus HOK021 DNA, complete genome	blastn	795	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces hygroscopicus
18178418	18178418	PRJNA1199893_P_NODE_17575_length_241_cov_0.916667_g17500_i0	PRJNA1199893	17575	241	0.916667	2.20916747	Anaerococcus sp. Marseille-Q7828	3036300	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|2472116327\|emb\|OX458331.1\|	3036300	g17500	i0	97.925	587.634854771784	241	5	100	0	1	241	257160	256920	Anaerococcus sp. Marseille-Q7828 genome assembly, chromosome: contig00001	blastn	141620	418	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. Marseille-Q7828
18896140	18896140	PRJNA1199893_P_NODE_10275_length_298_cov_1.017778_g10200_i0	PRJNA1199893	10275	298	1.017778	3.03297844	root	1	Root_unresolved	Root_unresolved	551	2.239999999999999e-152	NTclustered	gi\|2450141964\|gb\|OQ546328.1\|	239	g10200	i0	100	102.956375838926	298	0	100	0	1	298	356	653	Flavobacterium sp. strain CA_68B 16S ribosomal RNA gene, partial sequence	blastn	30681	551	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
20170893	20170893	PRJNA1199893_P_NODE_13716_length_255_cov_2.274725_g13641_i0	PRJNA1199893	13716	255	2.274725	5.80054875	Moraxellaceae	468	Bacteria	Bacteria	466	6.98e-127	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g13641	i0	99.608	346.796078431373	255	1	100	0	1	255	1497693	1497439	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	88433	466	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
20170933	20170933	PRJNA1199893_P_NODE_9796_length_305_cov_1.137931_g9721_i0	PRJNA1199893	9796	305	1.137931	3.47068955	Arthrobacter	1663	Bacteria	Bacteria	492	1.41e-134	NTclustered	gi\|2719889153\|gb\|CP151657.1\|	1670	g9721	i0	95.738	447.072131147541	305	13	100	0	1	305	751595	751291	Arthrobacter citreus strain EINP1 chromosome, complete genome	blastn	136357	492	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter citreus
21446560	21446560	PRJNA1199893_P_NODE_17677_length_237_cov_2.250000_g17602_i0	PRJNA1199893	17677	237	2.25	5.3325	Acinetobacter	469	Bacteria	Bacteria	438	1.4e-118	NTclustered	gi\|1751391443\|gb\|CP019143.2\|	28090	g17602	i0	100	688.008438818565	237	0	100	0	1	237	28415	28179	Acinetobacter lwoffii strain ZS207 chromosome, complete genome	blastn	163058	438	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter lwoffii
22721554	22721554	PRJNA1199893_P_NODE_8778_length_322_cov_2.168675_g8703_i0	PRJNA1199893	8778	322	2.168675	6.9831335	Corynebacterium	1716	Bacteria	Bacteria	278	4.58e-70	NTclustered	gi\|2869819920\|gb\|CP175795.1\|	1979527	g8703	i0	100	25.2204968944099	150	0	93	0	1	150	421392	421243	Corynebacterium kefirresidentii strain YSMAA1_1_C6 chromosome, complete genome	blastn	8121	278	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
25270839	25270839	PRJNA1199893_P_NODE_12240_length_273_cov_1.925000_g12165_i0	PRJNA1199893	12240	273	1.925	5.25525	Glutamicibacter	1742989	Bacteria	Bacteria	499	7.45e-137	NTclustered	gi\|2688610184\|gb\|CP033081.2\|	37929	g12165	i0	99.635	279.970695970696	274	0	100	1	1	273	92044	92317	Glutamicibacter nicotianae strain OTC-16 chromosome, complete genome	blastn	76432	499	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
25270843	25270843	PRJNA1199893_P_NODE_13760_length_255_cov_1.252747_g13685_i0	PRJNA1199893	13760	255	1.252747	3.19450485	Acinetobacter	469	Bacteria	Bacteria	472	1.5e-128	NTclustered	gi\|1993985272\|gb\|CP070518.1\|	471	g13685	i0	100	604.094117647059	255	0	100	0	1	255	1258022	1257768	Acinetobacter calcoaceticus strain FDAARGOS_1218 chromosome, complete genome	blastn	154044	472	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter calcoaceticus

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