metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA453111" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA453111" 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	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
2992025	2992025	PRJNA453111_P_NODE_10683_length_249_cov_0.875000_g10591_i0	PRJNA453111	10683	249	0.875	2.17875	Terribium terrae	2725666	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1752754875\|gb\|CP044218.1\|	2725666	g10591	i0	100	64.6706827309237	249	0	100	1	249	3572184	3571936	Mesorhizobium terrae strain NIBRBAC000500504 chromosome, complete genome	blastn	16103	460	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Terribium	Terribium terrae
4268436	4268436	PRJNA453111_P_NODE_13024_length_241_cov_0.916667_g12932_i0	PRJNA453111	13024	241	0.916667	2.20916747	Bradyrhizobium sp. PSBB068	2715960	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1979381481\|gb\|CP069300.1\|	2715960	g12932	i0	100	42.7966804979253	241	0	100	1	241	4027655	4027415	Bradyrhizobium sp. PSBB068 chromosome, complete genome	blastn	10314	446	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. PSBB068
4921033	4921033	PRJNA453111_P_NODE_9424_length_260_cov_1.133690_g9332_i0	PRJNA453111	9424	260	1.13369	2.947594	root	1	Root_unresolved	Root_unresolved	481	2.55e-131	NTclustered	gi\|1214359213\|gb\|MF424753.1\|	1613	g9332	i0	100	194	260	0	100	1	260	878	1137	Limosilactobacillus fermentum strain CAU6386 16S ribosomal RNA gene, partial sequence	blastn	50440	481	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus fermentum
5545095	5545095	PRJNA453111_P_NODE_10285_length_250_cov_0.870056_g10193_i0	PRJNA453111	10285	250	0.870056	2.17514	Bradyrhizobium sp. PSBB068	2715960	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1979381481\|gb\|CP069300.1\|	2715960	g10193	i0	100	97.756	250	0	100	1	250	5136916	5136667	Bradyrhizobium sp. PSBB068 chromosome, complete genome	blastn	24439	462	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. PSBB068
6195904	6195904	PRJNA453111_P_NODE_665_length_1003_cov_2.348387_g605_i0	PRJNA453111	665	1003	2.348387	23.55432161	Cetobacterium	180162	Bacteria	Bacteria	1803	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g605	i0	99.103	526.341974077767	1003	9	100	1	1003	278688	279690	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	527921	1803	1	Bacteria		Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8094537	8094537	PRJNA453111_P_NODE_11727_length_246_cov_0.890173_g11635_i0	PRJNA453111	11727	246	0.890173	2.18982558	Streptomyces sp. NBC_00564	2903663	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2667518664\|gb\|CP107786.1\|	2903663	g11635	i0	100	0.121951219512195	30	0	12	30	59	1030285	1030256	Streptomyces sp. NBC_00564 strain NBC 00564 chromosome, complete genome	blastn	30	56.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00564
9369277	9369277	PRJNA453111_P_NODE_12448_length_243_cov_0.905882_g12356_i0	PRJNA453111	12448	243	0.905882	2.20129326	Ralstonia insidiosa	190721	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1036241154\|gb\|CP016023.1\|	190721	g12356	i0	100	83.8600823045268	243	0	100	1	243	339164	338922	Ralstonia insidiosa strain ATCC 49129 chromosome 2, complete sequence	blastn	20378	449	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia insidiosa
10645251	10645251	PRJNA453111_P_NODE_12669_length_242_cov_1.822485_g12577_i0	PRJNA453111	12669	242	1.822485	4.4104137	Pendulispora albinea	2741071	Bacteria	Bacteria	348	2.48e-91	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g12577	i0	92.562	162.900826446281	242	18	100	1	242	3588997	3589238	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	39422	348	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
11920196	11920196	PRJNA453111_P_NODE_2350_length_535_cov_16.965368_g2258_i0	PRJNA453111	2350	535	16.965368	90.7647188	Chryseobacterium gallinarum	1324352	Bacteria	Bacteria	134	1.82e-26	NTclustered	gi\|1830200908\|gb\|CP050996.1\|	1324352	g2258	i0	100	0.65981308411215	72	0	13	1	72	1140	1069	Chryseobacterium gallinarum strain FDAARGOS_636 plasmid unnamed2	blastn	353	134	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gallinarum
11920257	11920257	PRJNA453111_P_NODE_9050_length_267_cov_1.190722_g8958_i0	PRJNA453111	9050	267	1.190722	3.17922774	Kosakonia arachidis	551989	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1769903668\|gb\|CP045299.1\|	551989	g8958	i0	96.97	0.123595505617978	33	1	12	203	235	25488	25456	Kosakonia arachidis strain KACC 18508 plasmid unnamed1, complete sequence	blastn	33	56.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Kosakonia	Kosakonia arachidis
13194969	13194969	PRJNA453111_P_NODE_10151_length_251_cov_0.865169_g10059_i0	PRJNA453111	10151	251	0.865169	2.17157419	Methyloversatilis sp. RAC08	1842540	Bacteria	Bacteria	414	2.52e-111	NTclustered	gi\|1059487190\|gb\|CP016448.1\|	1842540	g10059	i0	96.414	224.486055776892	251	9	100	1	251	844965	844715	Methyloversatilis sp. RAC08 chromosome, complete genome	blastn	56346	414	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Sterolibacteriaceae	Methyloversatilis	Methyloversatilis sp. RAC08
15120687	15120687	PRJNA453111_P_NODE_7952_length_287_cov_1.065421_g7860_i0	PRJNA453111	7952	287	1.065421	3.05775827	Comamonas	283	Bacteria	Bacteria	486	6.139999999999999e-133	NTclustered	gi\|507148303\|ref\|NR_103106.1\|	285	g7860	i0	97.213	420.620209059233	287	8	100	1	287	1145	1431	Comamonas testosteroni strain CNB-1 23S ribosomal RNA gene, complete sequence	blastn	120718	486	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Comamonas	Comamonas testosteroni
16395394	16395394	PRJNA453111_P_NODE_12133_length_244_cov_0.900585_g12041_i0	PRJNA453111	12133	244	0.900585	2.1974274	Pseudonocardiaceae	2070	Bacteria	Bacteria	407	4.08e-109	NTclustered	gi\|2667020334\|dbj\|AP029207.1\|	1933	g12041	i0	97.872	259.827868852459	235	5	96	1	235	3410	3176	Streptoalloteichus tenebrarius JCM 4838 DNA, complete genome	blastn	63398	407	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Streptoalloteichus	Streptoalloteichus tenebrarius
17018717	17018717	PRJNA453111_P_NODE_13334_length_205_cov_11.060606_g13242_i0	PRJNA453111	13334	205	11.060606	22.6742423	Chryseobacterium gallinarum	1324352	Bacteria	Bacteria	167	6.129999999999999e-37	NTclustered	gi\|1830200908\|gb\|CP050996.1\|	1324352	g13242	i0	98.925	3.28780487804878	93	1	68	27	119	1069	1161	Chryseobacterium gallinarum strain FDAARGOS_636 plasmid unnamed2	blastn	674	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gallinarum
17670479	17670479	PRJNA453111_P_NODE_4714_length_372_cov_1.314381_g4622_i0	PRJNA453111	4714	372	1.314381	4.88949732	Lachnospiraceae	186803	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2813041527\|emb\|OZ186729.1\|	33038	g4622	i0	100	0.526881720430108	28	0	8	24	51	2489714	2489687	Mediterraneibacter gnavus isolate LUMC_Rgna_QRD035 genome assembly, chromosome: 1	blastn	196	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
18293023	18293023	PRJNA453111_P_NODE_11675_length_246_cov_0.890173_g11583_i0	PRJNA453111	11675	246	0.890173	2.18982558	Mixta calida	665913	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1907656030\|gb\|CP061511.1\|	665913	g11583	i0	100	0.227642276422764	28	0	11	14	41	3529897	3529870	Mixta calida strain 5098PV chromosome, complete genome	blastn	56	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Mixta	Mixta calida
23393638	23393638	PRJNA453111_P_NODE_3379_length_442_cov_1.691057_g3287_i0	PRJNA453111	3379	442	1.691057	7.47447194	Clostridium perfringens	1502	Bacteria	Bacteria	52.8	0.043	NTclustered	gi\|2100434541\|gb\|CP075946.1\|	1502	g3287	i0	100	0.0633484162895928	28	0	6	54	81	34618	34645	Clostridium perfringens strain 955/85 plasmid pCP955-85	blastn	28	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
23393647	23393647	PRJNA453111_P_NODE_4719_length_372_cov_1.190635_g4627_i0	PRJNA453111	4719	372	1.190635	4.4291622	Mesorhizobium loti	381	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1050758791\|dbj\|AP017605.1\|	381	g4627	i0	96.875	0.161290322580645	32	1	9	154	185	2839721	2839752	Mesorhizobium loti DNA, nearly complete genome, strain: TONO	blastn	60	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Mesorhizobium	Mesorhizobium loti
24044772	24044772	PRJNA453111_P_NODE_9199_length_264_cov_1.905759_g9107_i0	PRJNA453111	9199	264	1.905759	5.03120376	Burkholderia	32008	Bacteria	Bacteria	82.4	3.08e-11	NTclustered	gi\|2304481520\|gb\|CP104215.1\|	28095	g9107	i0	94.34	35.9090909090909	53	3	20	17	69	1071718	1071666	Burkholderia gladioli strain ZN-S4 chromosome 2, complete sequence	blastn	9480	82.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia gladioli
24667564	24667564	PRJNA453111_P_NODE_11280_length_247_cov_0.885057_g11188_i0	PRJNA453111	11280	247	0.885057	2.18609079	Helicobacter pylori	210	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2222110184\|gb\|CP094161.1\|	210	g11188	i0	100	0.234817813765182	29	0	12	173	201	1355250	1355222	Helicobacter pylori strain Hpfe0015 chromosome, complete genome	blastn	58	54.7	1	Bacteria		Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
24667579	24667579	PRJNA453111_P_NODE_12500_length_243_cov_0.905882_g12408_i0	PRJNA453111	12500	243	0.905882	2.20129326	Aquipseudomonas campi	2731681	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1876483579\|gb\|CP053697.2\|	2731681	g12408	i0	96.875	0.131687242798354	32	1	13	38	69	2709033	2709002	Aquipseudomonas campi strain S1-A32-2 chromosome, complete genome	blastn	32	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Aquipseudomonas	Aquipseudomonas campi

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