metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJEB3181" and tax

24 rows where analysis = "blastn", bioproject = "PRJEB3181" and tax_phylum = "Actinomycetota"

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
56172	56172	PRJEB3181_S_NODE_541_length_594_cov_35.762075_g307_i0	PRJEB3181	541	594	35.762075	212.4267255	Microbacterium schleiferi	69362	Bacteria	Bacteria	867	0	NTclustered	gi\|1933612020\|gb\|CP064760.1\|	69362	g307	i0	95.888	159.397306397306	535	22	90	0	25	559	1098892	1099426	Microbacterium schleiferi strain A32-1 chromosome, complete genome	blastn	94682	867	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium schleiferi
988834	988834	PRJEB3181_P_NODE_9801_length_271_cov_3.858333_g9537_i0	PRJEB3181	9801	271	3.858333	10.45608243	Microbacterium	33882	Bacteria	Bacteria	377	3.61e-100	NTclustered	gi\|1933612020\|gb\|CP064760.1\|	69362	g9537	i0	93.023	151.217712177122	258	18	95	0	14	271	1099421	1099164	Microbacterium schleiferi strain A32-1 chromosome, complete genome	blastn	40980	377	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium schleiferi
4816730	4816730	PRJEB3181_S_NODE_15284_length_166_cov_2.343511_g14991_i0	PRJEB3181	15284	166	2.343511	3.89022826	Microbacterium	33882	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1547066608\|gb\|CP031338.1\|	82380	g14991	i0	100	4	166	0	100	0	1	166	824332	824167	Microbacterium oxydans strain VIU2A chromosome, complete genome	blastn	664	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium oxydans
6091973	6091973	PRJEB3181_S_NODE_16125_length_162_cov_0.944882_g15832_i0	PRJEB3181	16125	162	0.944882	1.53070884	Actinomycetes	1760	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1547066608\|gb\|CP031338.1\|	82380	g15832	i0	100	4	162	0	100	0	1	162	824513	824352	Microbacterium oxydans strain VIU2A chromosome, complete genome	blastn	648	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium oxydans
7366397	7366397	PRJEB3181_P_NODE_10286_length_264_cov_30.412017_g10022_i0	PRJEB3181	10286	264	30.412017	80.28772488	Streptomycetaceae	2062	Bacteria	Bacteria	329	9.95e-86	NTclustered	gi\|1442643274\|gb\|CP031320.1\|	83291	g10022	i0	92.92	480.901515151515	226	16	86	0	1	226	7990910	7990685	Streptomyces armeniacus strain ATCC 15676 chromosome	blastn	126958	329	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces armeniacus
7366436	7366436	PRJEB3181_S_NODE_15506_length_165_cov_1.230769_g15213_i0	PRJEB3181	15506	165	1.230769	2.03076885	Microbacterium	33882	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1547066608\|gb\|CP031338.1\|	82380	g15213	i0	100	17.5757575757576	165	0	100	0	1	165	817539	817703	Microbacterium oxydans strain VIU2A chromosome, complete genome	blastn	2900	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium oxydans
8642048	8642048	PRJEB3181_S_NODE_15427_length_165_cov_3.061538_g15134_i0	PRJEB3181	15427	165	3.061538	5.0515377	Microbacterium	33882	Bacteria	Bacteria	222	9.939999999999999e-54	NTclustered	gi\|2636116595\|gb\|CP139779.1\|	515415	g15134	i0	100	138.775757575758	120	0	73	0	1	120	2287548	2287429	Microbacterium invictum strain X-18 chromosome, complete genome	blastn	22898	222	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium invictum
8983172	8983172	PRJEB3181_S_NODE_17108_length_157_cov_1.655738_g16815_i0	PRJEB3181	17108	157	1.655738	2.59950866	Streptomyces sp. NBC_01176	2903760	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2654850809\|gb\|CP108600.1\|	2903760	g16815	i0	100	0.178343949044586	28	0	18	0	46	73	2038646	2038673	Streptomyces sp. NBC_01176 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01176
9917034	9917034	PRJEB3181_S_NODE_15448_length_165_cov_2.430769_g15155_i0	PRJEB3181	15448	165	2.430769	4.01076885	Micrococcales	85006	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1933612020\|gb\|CP064760.1\|	69362	g15155	i0	100	166.363636363636	165	0	100	0	1	165	1100904	1100740	Microbacterium schleiferi strain A32-1 chromosome, complete genome	blastn	27450	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium schleiferi
11192185	11192185	PRJEB3181_P_NODE_7349_length_309_cov_18.672662_g7088_i0	PRJEB3181	7349	309	18.672662	57.69852558	Micrococcus	1269	Bacteria	Bacteria	464	3.13e-126	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g7088	i0	97.426	271.126213592233	272	7	89	0	38	309	345728	345457	Micrococcus luteus strain V017 chromosome, complete genome	blastn	83778	464	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
11534328	11534328	PRJEB3181_S_NODE_4990_length_269_cov_291.333333_g4697_i0	PRJEB3181	4990	269	291.333333	783.68666577	uncultured Actinomycetales bacterium	239730	Bacteria	Bacteria	67.6	8.8e-7	NTclustered	gi\|310754897\|gb\|HQ212787.1\|	239730	g4697	i0	81.609	13.9516728624535	87	11	31	5	142	225	984	900	Uncultured Actinomycetales bacterium clone 2_D10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	3753	67.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales			uncultured Actinomycetales bacterium
11534381	11534381	PRJEB3181_S_NODE_8790_length_213_cov_1.550562_g8497_i0	PRJEB3181	8790	213	1.550562	3.30269706	Microbacterium paraoxydans	199592	Bacteria	Bacteria	337	4.62e-88	NTclustered	gi\|2059376513\|gb\|CP064874.1\|	199592	g8497	i0	100	3.56807511737089	182	0	85	0	1	182	112089	111908	Microbacterium paraoxydans strain 70447 plasmid unnamed1, complete sequence	blastn	760	337	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium paraoxydans
15016680	15016680	PRJEB3181_P_NODE_5692_length_343_cov_7.993590_g5438_i0	PRJEB3181	5692	343	7.99359	27.4180137	Cutibacterium	1912216	Bacteria	Bacteria	468	2.72e-127	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g5438	i0	100	253.241982507289	253	0	97	0	14	266	55728	55476	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	86862	468	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15016744	15016744	PRJEB3181_S_NODE_9012_length_210_cov_39566.828571_g8719_i0	PRJEB3181	9012	210	39566.828571	83090.3399991	Actinomycetes	1760	Bacteria	Bacteria	200	6.22e-47	NTclustered	gi\|1886976265\|gb\|CP059903.1\|	2760089	g8719	i0	95.935	209.37619047619	123	5	59	0	1	123	1983265	1983387	Nocardioides dongkuii strain S-713 chromosome, complete genome	blastn	43969	200	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides dongkuii
15358042	15358042	PRJEB3181_P_NODE_12993_length_235_cov_1.975490_g12729_i0	PRJEB3181	12993	235	1.97549	4.6424015	Nocardioides anomalus	2712223	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1817480961\|gb\|CP049257.1\|	2712223	g12729	i0	100	0.119148936170213	28	0	12	0	203	230	1337691	1337664	Nocardioides anomalus strain HKS04 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides anomalus
17566684	17566684	PRJEB3181_S_NODE_16134_length_162_cov_0.944882_g15841_i0	PRJEB3181	16134	162	0.944882	1.53070884	Streptomyces	1883	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2578917038\|gb\|CP134213.1\|	67308	g15841	i0	96.97	14.4691358024691	33	1	20	0	23	55	1984096	1984128	Streptomyces janthinus strain JCM 4387 chromosome, complete genome	blastn	2344	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces janthinus
17907537	17907537	PRJEB3181_P_NODE_16075_length_209_cov_1.668539_g15811_i0	PRJEB3181	16075	209	1.668539	3.48724651	Rhodococcus sp. AH-ZY2	3047468	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2570993224\|gb\|CP126458.1\|	3047468	g15811	i0	100	0.138755980861244	29	0	14	0	31	59	268067	268095	Rhodococcus sp. AH-ZY2 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. AH-ZY2
18840562	18840562	PRJEB3181_S_NODE_4795_length_274_cov_2.610879_g4502_i0	PRJEB3181	4795	274	2.610879	7.15380846	Cutibacterium	1912216	Bacteria	Bacteria	490	4.499999999999999e-134	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4502	i0	98.905	263.069343065693	274	3	100	0	1	274	55521	55794	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	72081	490	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
20115302	20115302	PRJEB3181_P_NODE_13516_length_230_cov_1.748744_g13252_i0	PRJEB3181	13516	230	1.748744	4.0221112	Streptomyces	1883	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2652094521\|gb\|CP109104.1\|	2975939	g13252	i0	100	0.665217391304348	30	0	13	0	135	164	4863304	4863333	Streptomyces sp. NBC_01775 chromosome, complete genome	blastn	153	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01775
21391022	21391022	PRJEB3181_S_NODE_9477_length_206_cov_2.888889_g9184_i0	PRJEB3181	9477	206	2.888889	5.95111134	Cutibacterium	1912216	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|1898669123\|emb\|LR588480.1\|	1747	g9184	i0	100	235.771844660194	206	0	100	0	1	206	387	182	Cutibacterium acnes partial 16S rRNA gene, isolate PD1MD	blastn	48569	381	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21732878	21732878	PRJEB3181_S_NODE_538_length_595_cov_6.626786_g305_i0	PRJEB3181	538	595	6.626786	39.4293767	Microbacterium sp. JZ31	1906274	Bacteria	Bacteria	418	5.039999999999999e-112	NTclustered	gi\|1972867151\|gb\|CP017661.1\|	1906274	g305	i0	96.457	75.472268907563	254	8	43	1	1	253	2156968	2156715	Microbacterium sp. JZ31, complete genome	blastn	44906	418	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. JZ31
22665711	22665711	PRJEB3181_S_NODE_15478_length_165_cov_1.684615_g15185_i0	PRJEB3181	15478	165	1.684615	2.77961475	Microbacterium	33882	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1547066608\|gb\|CP031338.1\|	82380	g15185	i0	100	4	165	0	100	0	1	165	817398	817234	Microbacterium oxydans strain VIU2A chromosome, complete genome	blastn	660	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium oxydans
22665725	22665725	PRJEB3181_S_NODE_2318_length_353_cov_28.235849_g2025_i0	PRJEB3181	2318	353	28.235849	99.67254697	PVC group	1783257	Bacteria	Bacteria	652	0	NTclustered	gi\|2060203558\|gb\|MZ473238.1\|	51671	g2025	i0	100	100.008498583569	353	0	100	0	1	353	810	458	Microbacterium sp. strain PW36_R2A_8 16S ribosomal RNA gene, partial sequence	blastn	35303	652	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp.
22665743	22665743	PRJEB3181_S_NODE_7158_length_233_cov_4.272727_g6865_i0	PRJEB3181	7158	233	4.272727	9.95545391	Microbacterium	33882	Bacteria	Bacteria	401	1.7999999999999993e-107	NTclustered	gi\|1084379694\|gb\|CP017674.1\|	1906742	g6865	i0	97.854	172.703862660944	233	4	99	1	2	233	483856	483624	Microbacterium sp. BH-3-3-3 chromosome, complete genome	blastn	40240	403	0.995037220843672	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. BH-3-3-3

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