metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJDB12578" and tax

24 rows where analysis = "blastn", bioproject = "PRJDB12578" and tax_phylum = "Pisuviricota"

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
772	772	PRJDB12578_S_NODE_1121_length_7932_cov_9.270582_g487_i0	PRJDB12578	1121	7932	9.270582	735.34256424	Dicistroviridae sp.	1955144	Viruses	Viruses	2710	0	NTclustered	gi\|2756423579\|gb\|PP745580.1\|	1955144	g487	i0	92.336	0.447302067574382	1905	146	24	0	3757	5661	1905	1	MAG: Dicistroviridae sp. isolate 131_11827 genomic sequence	blastn	3548	2710	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
1277240	1277240	PRJDB12578_S_NODE_170442_length_185_cov_1.301471_g147384_i0	PRJDB12578	170442	185	1.301471	2.40772135	Solenopsis invicta virus 8	2547311	Viruses	Viruses	226	8.789999999999998e-55	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g147384	i0	89.011	0.983783783783784	182	20	98	0	4	185	6138	6319	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	182	226	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
3826645	3826645	PRJDB12578_S_NODE_106144_length_273_cov_2.415179_g83086_i0	PRJDB12578	106144	273	2.415179	6.59343867	Solenopsis invicta virus 8	2547311	Viruses	Viruses	416	7.709999999999998e-112	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g83086	i0	94.139	1	273	16	100	0	1	273	1479	1207	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	273	416	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
5102753	5102753	PRJDB12578_S_NODE_102305_length_284_cov_2.110638_g79247_i0	PRJDB12578	102305	284	2.110638	5.99421192	Solenopsis invicta virus 8	2547311	Viruses	Viruses	481	2.82e-131	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g79247	i0	98.182	0.96830985915493	275	5	97	0	1	275	4611	4885	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	275	481	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
6381481	6381481	PRJDB12578_S_NODE_174726_length_182_cov_1.150376_g151668_i0	PRJDB12578	174726	182	1.150376	2.09368432	Solenopsis invicta virus 8	2547311	Viruses	Viruses	220	4.01e-53	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g151668	i0	89.205	0.967032967032967	176	19	97	0	7	182	8524	8349	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	176	220	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
6382695	6382695	PRJDB12578_S_NODE_210326_length_163_cov_1.333333_g187268_i0	PRJDB12578	210326	163	1.333333	2.17333279	Solenopsis invicta virus 8	2547311	Viruses	Viruses	161	2.16e-35	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g187268	i0	92.793	0.680981595092024	111	8	68	0	1	111	125	15	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	111	161	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
6384311	6384311	PRJDB12578_S_NODE_466_length_10070_cov_105.452350_g188_i0	PRJDB12578	466	10070	105.45235	10619.051645	Aparavirus vallesi	3048319	Viruses	Viruses	15370	0	NTclustered	gi\|2701496700\|gb\|PP104795.1\|	294369	g188	i0	94.574	8.58351539225422	9952	523	99	13	16	9958	1	9944	MAG: Solenopsis invicta virus 1 isolate GD-2022ANT6 genomic sequence	blastn	86436	15370	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Aparavirus	Aparavirus vallesi
7656402	7656402	PRJDB12578_S_NODE_201567_length_166_cov_0.888889_g178509_i0	PRJDB12578	201567	166	0.888889	1.47555574	Zebrafish picornavirus 1	2304617	Viruses	Viruses	296	5.82e-76	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g178509	i0	98.795	3	166	2	100	0	1	166	7857	7692	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	498	296	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
8934847	8934847	PRJDB12578_S_NODE_85028_length_359_cov_1.145161_g61970_i0	PRJDB12578	85028	359	1.145161	4.11112799	Solenopsis invicta virus 8	2547311	Viruses	Viruses	366	1.0699999999999995e-96	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g61970	i0	85.196	0.997214484679666	358	51	99	2	1	357	6158	5802	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	358	366	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
8934949	8934949	PRJDB12578_S_NODE_87248_length_346_cov_1.639731_g64190_i0	PRJDB12578	87248	346	1.639731	5.67346926	Solenopsis invicta virus 8	2547311	Viruses	Viruses	540	5.73e-149	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g64190	i0	94.798	1	346	18	100	0	1	346	1119	774	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	346	540	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
10203307	10203307	PRJDB12578_S_NODE_104009_length_279_cov_2.013043_g80951_i0	PRJDB12578	104009	279	2.013043	5.61638997	Solenopsis invicta virus 8	2547311	Viruses	Viruses	344	3.79e-90	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g80951	i0	89.13	0.989247311827957	276	30	99	0	4	279	10446	10721	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	276	344	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
10206083	10206083	PRJDB12578_S_NODE_175889_length_181_cov_1.174242_g152831_i0	PRJDB12578	175889	181	1.174242	2.12537802	Solenopsis invicta virus 8	2547311	Viruses	Viruses	219	1.4299999999999996e-52	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g152831	i0	88.398	1	181	21	100	0	1	181	1700	1880	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	181	219	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
12761369	12761369	PRJDB12578_S_NODE_83591_length_367_cov_3.716981_g60533_i0	PRJDB12578	83591	367	3.716981	13.64132027	Invictavirus solenopsis	3429972	Viruses	Viruses	65.8	4.48e-6	NTclustered	gi\|270268076\|gb\|GU017972.1\|	631345	g60533	i0	93.182	0.479564032697548	44	3	12	0	1	44	8313	8270	Solenopsis invicta virus 3 isolate SF, complete genome	blastn	176	65.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Solinviviridae	Invictavirus	Invictavirus solenopsis
14028519	14028519	PRJDB12578_S_NODE_105052_length_276_cov_2.497797_g81994_i0	PRJDB12578	105052	276	2.497797	6.89391972	Solenopsis invicta virus 8	2547311	Viruses	Viruses	451	2.14e-122	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g81994	i0	96.35	0.992753623188406	274	10	99	0	1	274	2002	2275	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	274	451	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
16579764	16579764	PRJDB12578_S_NODE_169734_length_185_cov_3.000000_g146676_i0	PRJDB12578	169734	185	3	5.55	Solenopsis invicta virus 8	2547311	Viruses	Viruses	276	8.61e-70	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g146676	i0	93.514	1	185	12	100	0	1	185	773	589	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	185	276	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
19129580	19129580	PRJDB12578_S_NODE_198216_length_167_cov_1.305085_g175158_i0	PRJDB12578	198216	167	1.305085	2.17949195	Solenopsis invicta virus 8	2547311	Viruses	Viruses	303	3.5e-78	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g175158	i0	99.401	1	167	1	100	0	1	167	438	604	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	167	303	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
19133729	19133729	PRJDB12578_S_NODE_92356_length_321_cov_1.136029_g69298_i0	PRJDB12578	92356	321	1.136029	3.64665309	Solenopsis invicta virus 8	2547311	Viruses	Viruses	385	2.61e-102	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g69298	i0	88.608	1.35514018691589	316	36	98	0	1	316	3000	3315	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	435	385	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
21678816	21678816	PRJDB12578_S_NODE_148858_length_204_cov_1.664516_g125800_i0	PRJDB12578	148858	204	1.664516	3.39561264	Solenopsis invicta virus 8	2547311	Viruses	Viruses	231	2.13e-56	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g125800	i0	87.192	0.995098039215686	203	26	99	0	1	203	2658	2860	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	203	231	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
22953745	22953745	PRJDB12578_S_NODE_138399_length_215_cov_212.138554_g115341_i0	PRJDB12578	138399	215	212.138554	456.0978911	Invictavirus solenopsis	3429972	Viruses	Viruses	350	5.999999999999999e-92	NTclustered	gi\|1269847416\|gb\|MF797911.1\|	631345	g115341	i0	96.244	1.98139534883721	213	8	99	0	2	214	8716	8504	Solenopsis invicta virus 3 isolate hybrid, complete genome	blastn	426	350	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Solinviviridae	Invictavirus	Invictavirus solenopsis
22956796	22956796	PRJDB12578_S_NODE_24999_length_1989_cov_1120.868557_g163_i1	PRJDB12578	24999	1989	1120.868557	22294.07559873	Invictavirus solenopsis	3429972	Viruses	Viruses	3452	0	NTclustered	gi\|1269847416\|gb\|MF797911.1\|	631345	g163	i1	98.615	3.96882855706385	1950	27	99	0	40	1989	8437	10386	Solenopsis invicta virus 3 isolate hybrid, complete genome	blastn	7894	3452	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Solinviviridae	Invictavirus	Invictavirus solenopsis
22957331	22957331	PRJDB12578_S_NODE_35039_length_1450_cov_7.239829_g19145_i0	PRJDB12578	35039	1450	7.239829	104.9775205	Dicistroviridae SC2638	1169617	Viruses	Viruses	313	6.18e-80	NTclustered	gi\|383289748\|gb\|JN857328.1\|	1169617	g19145	i0	91.266	0.304827586206897	229	20	16	0	748	976	1	229	Dicistroviridae SC2638 putative replicase polyprotein gene, partial cds	blastn	442	313	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae SC2638
22960447	22960447	PRJDB12578_S_NODE_99499_length_293_cov_1.934426_g76441_i0	PRJDB12578	99499	293	1.934426	5.66786818	Solenopsis invicta virus 8	2547311	Viruses	Viruses	484	2.2599999999999994e-132	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g76441	i0	96.587	1	293	9	100	1	1	293	11772	12063	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	293	484	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
24229028	24229028	PRJDB12578_S_NODE_176460_length_180_cov_1.977099_g153402_i0	PRJDB12578	176460	180	1.977099	3.5587782	Solenopsis invicta virus 8	2547311	Viruses	Viruses	311	2.28e-80	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g153402	i0	97.778	1	180	4	100	0	1	180	11385	11206	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	180	311	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
24231642	24231642	PRJDB12578_S_NODE_420_length_10376_cov_865.522417_g163_i0	PRJDB12578	420	10376	865.522417	89806.60598792	Invictavirus solenopsis	3429972	Viruses	Viruses	17987	0	NTclustered	gi\|1269847416\|gb\|MF797911.1\|	631345	g163	i0	97.957	4.92386276021588	10376	212	100	0	1	10376	10386	11	Solenopsis invicta virus 3 isolate hybrid, complete genome	blastn	51090	17987	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Solinviviridae	Invictavirus	Invictavirus solenopsis

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