metadata: contig_metadata: 8 rows where bioproject = "PRJEB14175", tax_phylum = "Preplasmiviricota" and tax

8 rows where bioproject = "PRJEB14175", tax_phylum = "Preplasmiviricota" and tax_superkingdom = "Viruses"

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_species
25912988	25912988	PRJEB14175_P_NODE_180100_length_245_cov_0.858696_g177833_i0	PRJEB14175	180100	245	0.858696	2.1038052	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	298	2.57e-76	NTclustered	gi\|2710391106\|tpg\|BK066467.1\|	2609857	g177833	i0	98.235	1.02040816326531	170	3	100	0	76	245	2300	2469	MAG TPA_asm: Adintovirus homo13306 isolate Adinto13306 genomic sequence	blastn	250	298	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Larimichthys croaker adintovirus
26184073	26184073	PRJEB14175_P_NODE_155454_length_270_cov_3.660287_g153187_i0	PRJEB14175	155454	270	3.660287	9.8827749	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	387	5.97e-103	NTclustered	gi\|2710391106\|tpg\|BK066467.1\|	2609857	g153187	i0	92.857	0.985185185185185	266	19	99	0	5	270	1233	1498	MAG TPA_asm: Adintovirus homo13306 isolate Adinto13306 genomic sequence	blastn	266	387	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Larimichthys croaker adintovirus
32909284	32909284	PRJEB14175_P_NODE_226985_length_209_cov_1.432432_g224717_i0	PRJEB14175	226985	209	1.432432	2.99378288	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	42.4	0.0336	NR	DBA47698.1	2609857	g224717	i0	85	0.287081339712919	20	3	28.7	0	3	62	1199	1218	DBA47698.1 MAG TPA_asm: PolBb [Adintovirus homo13306]	diamond	60	42.4	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Larimichthys croaker adintovirus
33029691	33029691	PRJEB14175_P_NODE_62396_length_469_cov_4.276961_g60140_i0	PRJEB14175	62396	469	4.276961	20.05894709	Thermus phage phiKo	2301535	Viruses	Viruses	111	2.85e-27	NR	AYJ74689.1	2301535	g60140	i0	62.8	0.550106609808102	86	29	55	2	88	345	19	101	AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo]	diamond	258	111	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Thermus phage phiKo
33029862	33029862	PRJEB14175_P_NODE_81788_length_403_cov_3.801170_g79526_i0	PRJEB14175	81788	403	3.80117	15.3187151	Thermus phage phiKo	2301535	Viruses	Viruses	85.9	9.18e-18	NR	AYJ74689.1	2301535	g79526	i0	56.6	0.56575682382134	76	28	52.9	2	335	123	127	202	AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo]	diamond	228	85.9	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Thermus phage phiKo
33130545	33130545	PRJEB14175_P_NODE_14183_length_952_cov_4.991021_g12589_i0	PRJEB14175	14183	952	4.991021	47.51451992	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	132	1.1499999999999999e-32	NR	DBA47688.1	2609857	g12589	i0	50.4	0.406512605042017	129	64	40.7	0	394	780	152	280	DBA47688.1 MAG TPA_asm: Adintoc5 [Adintovirus homo13306]	diamond	387	132	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Larimichthys croaker adintovirus
33164441	33164441	PRJEB14175_P_NODE_131928_length_301_cov_2.312500_g129661_i0	PRJEB14175	131928	301	2.3125	6.960625	Thermus phage phiKo	2301535	Viruses	Viruses	74.7	2.4e-13	NR	AYJ74696.1	2301535	g129661	i0	50.6	0.767441860465116	77	37	76.7	1	231	1	156	231	AYJ74696.1 hypothetical protein phiKo_21 [Thermus phage phiKo]	diamond	231	74.7	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Thermus phage phiKo
33165336	33165336	PRJEB14175_P_NODE_225528_length_210_cov_1.288591_g223260_i0	PRJEB14175	225528	210	1.288591	2.7060411	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	101	1.9099999999999994e-24	NR	DBA47691.1	2609857	g223260	i0	75	0.914285714285714	64	16	91.4	0	17	208	53	116	DBA47691.1 MAG TPA_asm: Penton [Adintovirus homo13306]	diamond	192	101	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Larimichthys croaker adintovirus

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