metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1263632" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1263632" and tax_kingdom = "Bacillati"

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
3604489	3604489	PRJNA1263632_P_NODE_8563_length_233_cov_2.956250_g8545_i0	PRJNA1263632	8563	233	2.95625	6.8880625	Streptomyces	1883	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2070205667\|gb\|CP079114.1\|	2855836	g8545	i0	100	0.240343347639485	28	0	12	0	84	111	3126113	3126086	Streptomyces sp. WY228 chromosome	blastn	56	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. WY228
4882020	4882020	PRJNA1263632_P_NODE_2404_length_391_cov_2.959119_g2386_i0	PRJNA1263632	2404	391	2.959119	11.57015529	Listeria	1637	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2611946659\|gb\|CP137276.1\|	1639	g2386	i0	96.875	8.82097186700767	32	0	8	1	81	112	2548517	2548487	Listeria monocytogenes strain FV3 chromosome, complete genome	blastn	3449	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
11257317	11257317	PRJNA1263632_P_NODE_3189_length_343_cov_3.262963_g3171_i0	PRJNA1263632	3189	343	3.262963	11.19196309	root	1	Root_unresolved	Root_unresolved	628	1.1799999999999997e-175	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g3171	i0	99.708	98.8250728862974	343	1	100	0	1	343	2463318	2463660	Staphylococcus aureus strain WH9628 chromosome	blastn	33897	628	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
16941078	16941078	PRJNA1263632_P_NODE_8334_length_241_cov_0.916667_g8316_i0	PRJNA1263632	8334	241	0.916667	2.20916747	Mycoplasmopsis adleri	51362	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2860284679\|gb\|CP174162.1\|	51362	g8316	i0	81.69	0.294605809128631	71	7	28	5	142	208	1102201	1102133	Mycoplasmopsis adleri strain G145 chromosome, complete genome	blastn	71	54.7	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis adleri
18905476	18905476	PRJNA1263632_P_NODE_8355_length_241_cov_0.916667_g8337_i0	PRJNA1263632	8355	241	0.916667	2.20916747	Cutibacterium	1912216	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g8337	i0	100	56.551867219917	241	0	100	0	1	241	1299535	1299295	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13629	446	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22040458	22040458	PRJNA1263632_P_NODE_6998_length_248_cov_0.880000_g6980_i0	PRJNA1263632	6998	248	0.88	2.1824	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g6980	i0	100	0.112903225806452	28	0	11	0	182	209	3228849	3228822	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
24006006	24006006	PRJNA1263632_P_NODE_6799_length_249_cov_0.875000_g6781_i0	PRJNA1263632	6799	249	0.875	2.17875	Staphylococcus	1279	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g6781	i0	99.598	97.8473895582329	249	1	100	0	1	249	60603	60355	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	24364	455	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis

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