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

10 rows where analysis = "blastn", bioproject = "PRJNA1199893" 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
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
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
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.
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
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
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
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
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

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