metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1089179" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1089179" and tax_phylum = "Bacillota"

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
1469403	1469403	PRJNA1089179_P_NODE_11922_length_272_cov_53.914573_g11904_i0	PRJNA1089179	11922	272	53.914573	146.64763856	Evansella sp. LMS18	2924033	Bacteria	Bacteria	294	3.76e-75	NTclustered	gi\|2273830600\|gb\|CP093301.1\|	2924033	g11904	i0	89.121	726.669117647059	239	22	87	4	19	255	912878	913114	Evansella sp. LMS18 chromosome, complete genome	blastn	197654	294	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Evansella	Evansella sp. LMS18
1469425	1469425	PRJNA1089179_P_NODE_17442_length_240_cov_2.155689_g17424_i0	PRJNA1089179	17442	240	2.155689	5.1736536	Exiguobacterium acetylicum	41170	Bacteria	Bacteria	427	3.07e-115	NTclustered	gi\|1735050952\|gb\|CP030931.1\|	41170	g17424	i0	98.75	11.1708333333333	240	3	100	0	1	240	990180	989941	Exiguobacterium acetylicum strain AMCC 101217 chromosome, complete genome	blastn	2681	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium acetylicum
9122426	9122426	PRJNA1089179_P_NODE_17088_length_241_cov_30.333333_g17070_i0	PRJNA1089179	17088	241	30.333333	73.10333253	Streptococcus oralis	1303	Bacteria	Bacteria	335	1.9199999999999993e-87	NTclustered	gi\|1878156058\|gb\|CP054135.1\|	1891914	g17070	i0	96.985	19.8091286307054	199	6	83	0	22	220	1910731	1910533	Streptococcus oralis subsp. oralis strain ATCC 10557 chromosome	blastn	4774	335	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
11673507	11673507	PRJNA1089179_P_NODE_9330_length_300_cov_2.343612_g9312_i0	PRJNA1089179	9330	300	2.343612	7.030836	Acetivibrio saccincola	1677857	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1315080541\|gb\|CP025197.1\|	1677857	g9312	i0	100	0.0966666666666667	29	0	10	0	231	259	884049	884077	Acetivibrio saccincola strain GGR1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Acetivibrio	Acetivibrio saccincola
13770912	13770912	PRJNA1089179_P_NODE_8311_length_314_cov_48.041494_g8293_i0	PRJNA1089179	8311	314	48.041494	150.85029116	Clostridium	1485	Bacteria	Bacteria	388	1.97e-103	NTclustered	gi\|301051484\|gb\|FJ546745.1\|	1550	g8293	i0	92.058	736.245222929936	277	21	88	1	25	300	337	613	Clostridium subterminale strain DSM 758 23S ribosomal RNA gene, partial sequence	blastn	231181	388	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium subterminale
16771784	16771784	PRJNA1089179_P_NODE_12434_length_268_cov_1.579487_g12416_i0	PRJNA1089179	12434	268	1.579487	4.23302516	Roseburia rectibacter	2763062	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2206258461\|gb\|CP092473.1\|	2763062	g12416	i0	96.97	0.123134328358209	33	1	12	0	210	242	2892630	2892662	Roseburia rectibacter strain NSJ-69 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia rectibacter
18046529	18046529	PRJNA1089179_P_NODE_17975_length_227_cov_13.461039_g17957_i0	PRJNA1089179	17975	227	13.461039	30.55655853	Clostridium thermarum	1716543	Bacteria	Bacteria	209	1.13e-49	NTclustered	gi\|1685740129\|gb\|CP040924.1\|	1716543	g17957	i0	91.083	27.0660792951542	157	11	68	3	53	207	13128	12973	Clostridium thermarum strain SYSU GA15002 chromosome, complete genome	blastn	6144	209	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium thermarum
23146989	23146989	PRJNA1089179_P_NODE_17699_length_234_cov_2.229814_g17681_i0	PRJNA1089179	17699	234	2.229814	5.21776476	Streptococcus sanguinis	1305	Bacteria	Bacteria	329	8.65e-86	NTclustered	gi\|1864132248\|gb\|CP040556.1\|	1305	g17681	i0	92.241	7.88461538461539	232	18	99	0	3	234	463782	464013	Streptococcus sanguinis strain CGMH010 chromosome, complete genome	blastn	1845	329	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
24420646	24420646	PRJNA1089179_P_NODE_10280_length_289_cov_1.425926_g10262_i0	PRJNA1089179	10280	289	1.425926	4.12092614	Weissella cibaria	137591	Bacteria	Bacteria	507	4.75e-139	NTclustered	gi\|2435979498\|gb\|CP116385.1\|	137591	g10262	i0	98.27	19	289	5	100	0	1	289	433060	432772	Weissella cibaria strain BAL3C-5 C120T chromosome, complete genome	blastn	5491	507	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria

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