metadata: contig_metadata: 8 rows where bioproject = "PRJNA242641" and tax

8 rows where bioproject = "PRJNA242641" and tax_kingdom = "Loebvirae"

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
367432	367432	PRJNA242641_S_NODE_261_length_457_cov_11.693925_g233_i0	PRJNA242641	261	457	11.693925	53.44123725	Porrectionivirus p12J	2956327	Viruses	Viruses	839	0	NTclustered	gi\|156519262\|gb\|AY374414.2\|	247080	g233	i0	99.781	9.61487964989059	457	1	100	0	1	457	5735	6191	Ralstonia phage p12J, complete genome	blastn	4394	839	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Porrectionivirus	Porrectionivirus p12J
6745105	6745105	PRJNA242641_S_NODE_386_length_372_cov_11.233236_g358_i0	PRJNA242641	386	372	11.233236	41.78763792	Porrectionivirus p12J	2956327	Viruses	Viruses	688	0	NTclustered	gi\|156519262\|gb\|AY374414.2\|	247080	g358	i0	100	6.54301075268817	372	0	100	0	1	372	5365	5736	Ralstonia phage p12J, complete genome	blastn	2434	688	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Porrectionivirus	Porrectionivirus p12J
8020839	8020839	PRJNA242641_S_NODE_27_length_1077_cov_7.684160_g23_i0	PRJNA242641	27	1077	7.68416	82.7584032	Porrectionivirus p12J	2956327	Viruses	Viruses	1764	0	NTclustered	gi\|156519262\|gb\|AY374414.2\|	247080	g23	i0	100	8.0510677808728	955	0	100	0	1	955	6164	7118	Ralstonia phage p12J, complete genome	blastn	8671	1764	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Porrectionivirus	Porrectionivirus p12J
15670222	15670222	PRJNA242641_S_NODE_173_length_549_cov_6.882692_g155_i0	PRJNA242641	173	549	6.882692	37.78597908	Porrectionivirus p12J	2956327	Viruses	Viruses	422	3.57e-113	NTclustered	gi\|156519262\|gb\|AY374414.2\|	247080	g155	i0	80.755	4.9016393442623	556	93	100	10	1	549	4081	4629	Ralstonia phage p12J, complete genome	blastn	2691	422	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Porrectionivirus	Porrectionivirus p12J
18219123	18219123	PRJNA242641_S_NODE_1415_length_195_cov_5.313253_g1387_i0	PRJNA242641	1415	195	5.313253	10.36084335	Porrectionivirus p12J	2956327	Viruses	Viruses	361	2.46e-95	NTclustered	gi\|156519262\|gb\|AY374414.2\|	247080	g1387	i0	100	2	195	0	100	0	1	195	5387	5193	Ralstonia phage p12J, complete genome	blastn	390	361	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Porrectionivirus	Porrectionivirus p12J
18219124	18219124	PRJNA242641_S_NODE_15_length_1228_cov_9.241868_g12_i0	PRJNA242641	15	1228	9.241868	113.49013904	Porrectionivirus p12J	2956327	Viruses	Viruses	1698	0	NTclustered	gi\|156519262\|gb\|AY374414.2\|	247080	g12	i0	96.94	4.30944625407166	1013	30	82	1	1	1013	566	1577	Ralstonia phage p12J, complete genome	blastn	5292	1698	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Porrectionivirus	Porrectionivirus p12J
19493384	19493384	PRJNA242641_S_NODE_1836_length_171_cov_6.880282_g1808_i0	PRJNA242641	1836	171	6.880282	11.76528222	Porrectionivirus p12J	2956327	Viruses	Viruses	316	4.6e-82	NTclustered	gi\|156519262\|gb\|AY374414.2\|	247080	g1808	i0	100	16.6081871345029	171	0	100	0	1	171	5189	5019	Ralstonia phage p12J, complete genome	blastn	2840	316	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Porrectionivirus	Porrectionivirus p12J
24593650	24593650	PRJNA242641_S_NODE_800_length_258_cov_4.515284_g772_i0	PRJNA242641	800	258	4.515284	11.64943272	Porrectionivirus p12J	2956327	Viruses	Viruses	475	1.1799999999999999e-129	NTclustered	gi\|156519262\|gb\|AY374414.2\|	247080	g772	i0	100	1.9922480620155	257	0	99	0	1	257	4605	4861	Ralstonia phage p12J, complete genome	blastn	514	475	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Porrectionivirus	Porrectionivirus p12J

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