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

21 rows where analysis = "blastn", bioproject = "PRJNA1009807" 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
1001378	1001378	PRJNA1009807_S_NODE_1121_length_287_cov_62.084677_g1093_i0	PRJNA1009807	1121	287	62.084677	178.18302299	Micrococcales	85006	Bacteria	Bacteria	477	3.6899999999999996e-130	NTclustered	gi\|2452059386\|gb\|CP118972.1\|	1670	g1093	i0	96.842	357.578397212544	285	9	99	0	1	285	238227	238511	Arthrobacter citreus strain DSM 15046 chromosome, complete genome	blastn	102625	477	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter citreus
3551960	3551960	PRJNA1009807_S_NODE_2423_length_202_cov_2.785276_g2395_i0	PRJNA1009807	2423	202	2.785276	5.62625752	Mycolicibacterium	1866885	Bacteria	Bacteria	348	2e-91	NTclustered	gi\|1444374111\|gb\|CP031414.1\|	1795	g2395	i0	98	168.138613861386	200	4	99	0	3	202	1736172	1736371	Mycolicibacterium neoaurum strain HGMS2 chromosome, complete genome	blastn	33964	350	0.994285714285714	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium neoaurum
3551985	3551985	PRJNA1009807_S_NODE_4563_length_156_cov_3.589744_g4535_i0	PRJNA1009807	4563	156	3.589744	5.60000064	Nakamurella	53460	Bacteria	Bacteria	255	9.12e-64	NTclustered	gi\|470484994\|ref\|NR_076679.1\|	53461	g4535	i0	96.732	223.467948717949	153	5	98	0	1	153	391	543	Nakamurella multipartita strain Y-104 23S ribosomal RNA gene, complete sequence	blastn	34861	255	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Nakamurellales	Nakamurellaceae	Nakamurella	Nakamurella multipartita
4829385	4829385	PRJNA1009807_S_NODE_1524_length_246_cov_3.714976_g1496_i0	PRJNA1009807	1524	246	3.714976	9.13884096	Cutibacterium	1912216	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1496	i0	100	250.934959349593	246	0	100	0	1	246	55707	55462	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	61730	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4829410	4829410	PRJNA1009807_S_NODE_3944_length_166_cov_1.582677_g3916_i0	PRJNA1009807	3944	166	1.582677	2.62724382	Nakamurella	53460	Bacteria	Bacteria	291	2.7099999999999998e-74	NTclustered	gi\|470484994\|ref\|NR_076679.1\|	53461	g3916	i0	98.193	346.915662650602	166	3	100	0	1	166	1278	1443	Nakamurella multipartita strain Y-104 23S ribosomal RNA gene, complete sequence	blastn	57588	291	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Nakamurellales	Nakamurellaceae	Nakamurella	Nakamurella multipartita
6533018	6533018	PRJNA1009807_S_NODE_946_length_308_cov_3.256506_g918_i0	PRJNA1009807	946	308	3.256506	10.03003848	Streptomyces sp. NBC_00631	2975793	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2656789620\|gb\|CP107734.1\|	2975793	g918	i0	100	0.363636363636364	28	0	9	0	250	277	9934252	9934279	Streptomyces sp. NBC_00631 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00631
9929402	9929402	PRJNA1009807_S_NODE_2968_length_186_cov_2.006803_g2940_i0	PRJNA1009807	2968	186	2.006803	3.73265358	Mycobacterium	1763	Bacteria	Bacteria	311	2.38e-80	NTclustered	gi\|1806447213\|dbj\|AP022613.1\|	44010	g2940	i0	96.774	234.440860215054	186	6	100	0	1	186	4170750	4170935	Mycobacterium conspicuum JCM 14738 DNA, nearly complete genome	blastn	43606	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium conspicuum
11204686	11204686	PRJNA1009807_S_NODE_229_length_539_cov_55.334000_g205_i0	PRJNA1009807	229	539	55.334	298.25026	Micrococcales	85006	Bacteria	Bacteria	765	0	NTclustered	gi\|1850196339\|gb\|CP054038.1\|	162426	g205	i0	92.421	171.387755102041	541	34	100	7	1	539	2333898	2333363	Microbacterium hominis strain PA2F3 chromosome, complete genome	blastn	92378	771	0.992217898832685	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium hominis
11204721	11204721	PRJNA1009807_S_NODE_809_length_329_cov_120.365517_g781_i0	PRJNA1009807	809	329	120.365517	396.00255093	Microbacterium	33882	Bacteria	Bacteria	603	6.819999999999999e-168	NTclustered	gi\|2530242188\|gb\|CP103793.1\|	2033	g781	i0	99.696	186.009118541033	329	1	100	0	1	329	1378279	1378607	Microbacterium testaceum strain D12 chromosome, complete genome	blastn	61197	608	0.991776315789474	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
12480222	12480222	PRJNA1009807_S_NODE_330_length_478_cov_28.703872_g302_i0	PRJNA1009807	330	478	28.703872	137.20450816	Microbacterium	33882	Bacteria	Bacteria	730	0	NTclustered	gi\|1314922424\|gb\|CP025299.1\|	162426	g302	i0	95.633	176.416317991632	458	15	95	4	1	454	1540080	1539624	Microbacterium hominis strain SJTG1 chromosome, complete genome	blastn	84327	736	0.991847826086957	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium hominis
15029174	15029174	PRJNA1009807_S_NODE_3872_length_167_cov_2.085938_g3844_i0	PRJNA1009807	3872	167	2.085938	3.48351646	Propionibacteriales	85009	Bacteria	Bacteria	252	1.29e-62	NTclustered	gi\|1886979810\|gb\|CP059901.1\|	2708082	g3844	i0	94.048	196.988023952096	168	7	100	3	1	167	1944254	1944419	Mumia sp. ZJ1417 chromosome, complete genome	blastn	32897	254	0.992125984251969	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Mumia	Mumia sp. ZJ1417
15457411	15457411	PRJNA1009807_S_NODE_353_length_463_cov_222.768868_g325_i0	PRJNA1009807	353	463	222.768868	1031.41985884	Microbacterium chocolatum	162393	Bacteria	Bacteria	721	0	NTclustered	gi\|1032532433\|gb\|CP015810.1\|	84292	g325	i0	95.768	121.831533477322	449	16	97	3	1	448	1843985	1843539	Microbacterium chocolatum strain SIT 101, complete genome	blastn	56408	721	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium chocolatum
16303895	16303895	PRJNA1009807_S_NODE_1753_length_232_cov_3.440415_g1725_i0	PRJNA1009807	1753	232	3.440415	7.9817628	Cutibacterium	1912216	Bacteria	Bacteria	424	3.82e-114	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1725	i0	99.569	303.064655172414	232	1	100	0	1	232	55929	56160	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	70311	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16303903	16303903	PRJNA1009807_S_NODE_2213_length_210_cov_3.350877_g2185_i0	PRJNA1009807	2213	210	3.350877	7.0368417	Micrococcus	1269	Bacteria	Bacteria	388	1.24e-103	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g2185	i0	100	251.2	210	0	100	0	1	210	2260491	2260700	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	52752	388	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
17579269	17579269	PRJNA1009807_S_NODE_3834_length_168_cov_1.147287_g3806_i0	PRJNA1009807	3834	168	1.147287	1.92744216	Nakamurella	53460	Bacteria	Bacteria	222	1.02e-53	NTclustered	gi\|470484994\|ref\|NR_076679.1\|	53461	g3806	i0	91.018	233.85119047619	167	11	98	4	1	165	204	368	Nakamurella multipartita strain Y-104 23S ribosomal RNA gene, complete sequence	blastn	39287	222	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Nakamurellales	Nakamurellaceae	Nakamurella	Nakamurella multipartita
18853113	18853113	PRJNA1009807_S_NODE_4695_length_155_cov_1.396552_g4667_i0	PRJNA1009807	4695	155	1.396552	2.1646556	Rhodococcus	1827	Bacteria	Bacteria	287	3.21e-73	NTclustered	gi\|2258906618\|dbj\|AP018733.1\|	1833	g4667	i0	100	413.083870967742	155	0	100	0	1	155	3384969	3385123	Rhodococcus erythropolis JCM 2895 DNA, complete genome	blastn	64028	287	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus erythropolis
19280333	19280333	PRJNA1009807_S_NODE_136_length_636_cov_70.140704_g117_i0	PRJNA1009807	136	636	70.140704	446.09487744	Microbacterium proteolyticum	1572644	Bacteria	Bacteria	1149	0	NTclustered	gi\|2482566189\|gb\|CP121274.1\|	1572644	g117	i0	99.369	185.116352201258	634	4	99	0	3	636	2451369	2450736	Microbacterium proteolyticum strain ustc chromosome, complete genome	blastn	117734	1149	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium proteolyticum
21831564	21831564	PRJNA1009807_S_NODE_1378_length_257_cov_14.655963_g1350_i0	PRJNA1009807	1378	257	14.655963	37.66582491	Microbacterium proteolyticum	1572644	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|2482566189\|gb\|CP121274.1\|	1572644	g1350	i0	100	98.579766536965	257	0	100	0	1	257	3235772	3235516	Microbacterium proteolyticum strain ustc chromosome, complete genome	blastn	25335	475	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium proteolyticum
23107133	23107133	PRJNA1009807_S_NODE_819_length_327_cov_17.347222_g791_i0	PRJNA1009807	819	327	17.347222	56.72541594	Cutibacterium acnes	1747	Bacteria	Bacteria	416	9.469999999999999e-112	NTclustered	gi\|966544767\|gb\|CP012355.1\|	1747	g791	i0	89.634	249.018348623853	328	32	100	2	1	327	625449	625775	Cutibacterium acnes strain PA_15_1_R1 chromosome, complete genome	blastn	81429	416	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25227608	25227608	PRJNA1009807_S_NODE_100_length_731_cov_6.546243_g84_i0	PRJNA1009807	100	731	6.546243	47.85303633	Cutibacterium	1912216	Bacteria	Bacteria	1349	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g84	i0	100	286.81121751026	730	0	99	0	1	730	56508	57237	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	209659	1349	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25227628	25227628	PRJNA1009807_S_NODE_2740_length_192_cov_1.522876_g2712_i0	PRJNA1009807	2740	192	1.522876	2.92392192	Bacteria	2	Bacteria	Bacteria	313	6.87e-81	NTclustered	gi\|2874253809\|emb\|OY969793.1\|	310071	g2712	i0	96.316	95.9166666666667	190	7	99	0	3	192	1441153	1440964	MAG: uncultured Acidimicrobiales bacterium isolate MFD09671.bin.c.2 genome assembly, chromosome: 1	blastn	18416	313	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			uncultured Acidimicrobiales bacterium

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