metadata: contig_metadata: 10 rows where bioproject = "PRJNA971676" and tax

10 rows where bioproject = "PRJNA971676" 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_genus	tax_species
944713	944713	PRJNA971676_P_NODE_2461_length_490_cov_0.750600_g2372_i0	PRJNA971676	2461	490	0.7506	3.67794	Cestrum yellow leaf curling virus	175814	Viruses	Viruses	256	4.5500000000000006e-79	NR	NP_861410.1	175814	g2372	i0	73	0.997959183673469	163	44	99.8	0	1	489	260	422	NP_861410.1 putative multifunctional pol protein [Cestrum yellow leaf curling virus]	diamond	489	256	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Soymovirus	Soymovirus crispocestri
4772946	4772946	PRJNA971676_P_NODE_17704_length_247_cov_0.885057_g17615_i0	PRJNA971676	17704	247	0.885057	2.18609079	Hepacivirus hominis	3052230	Viruses	Viruses	52.8	0.022	NTclustered	gi\|338830580\|gb\|HQ618277.1\|	3052230	g17615	i0	100	1.1336032388664	28	0	11	0	7	34	50	23	Hepatitis C virus isolate ET1365 polyprotein gene, partial cds	blastn	280	52.8	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Hepacivirus	Hepacivirus hominis
11148342	11148342	PRJNA971676_P_NODE_2769_length_467_cov_2.050761_g2680_i0	PRJNA971676	2769	467	2.050761	9.57705387	Locusta migratoria associated flavi-like virus	3142496	Viruses	Viruses	342	2.3999999999999998e-89	NTclustered	gi\|2755703735\|tpg\|BK067811.1\|	3142496	g2680	i0	99.471	0.404710920770878	189	0	40	1	267	454	189	1	TPA_asm: Locusta migratoria associated flavi-like virus isolate MYMM genomic sequence	blastn	189	342	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae		Locusta migratoria associated flavi-like virus
13698265	13698265	PRJNA971676_P_NODE_16531_length_248_cov_1.320000_g16442_i0	PRJNA971676	16531	248	1.32	3.2736	Plotvirus plot	2170099	Viruses	Viruses	62.1	3.73e-5	NTclustered	gi\|1720702708\|gb\|MN119378.1\|	2596982	g16442	i0	91.489	0.854838709677419	47	1	18	2	67	110	45867	45913	Mycobacterium phage Penelope2018, complete genome	blastn	212	62.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Plotvirus	Plotvirus plot
16247522	16247522	PRJNA971676_P_NODE_21593_length_243_cov_0.905882_g21504_i0	PRJNA971676	21593	243	0.905882	2.20129326	uncultured marine virus	186617	Viruses	Viruses	335	1.9399999999999993e-87	NTclustered	gi\|2033874520\|dbj\|LC629455.1\|	186617	g21504	i0	92.05	0.983539094650206	239	18	98	1	6	243	238657	238895	MAG: Uncultured marine virus CM1_5m.V1 DNA, nearly complete genome	blastn	239	335	1	Viruses							uncultured marine virus
16568954	16568954	PRJNA971676_P_NODE_2553_length_482_cov_0.784841_g2464_i0	PRJNA971676	2553	482	0.784841	3.78293362	Cestrum yellow leaf curling virus	175814	Viruses	Viruses	111	5.49e-25	NR	NP_861410.1	175814	g2464	i0	43.2	0.964730290456432	155	76	90.2	4	435	1	29	181	NP_861410.1 putative multifunctional pol protein [Cestrum yellow leaf curling virus]	diamond	465	111	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Soymovirus	Soymovirus crispocestri
20392723	20392723	PRJNA971676_P_NODE_18516_length_246_cov_0.890173_g18427_i0	PRJNA971676	18516	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	449	6.74e-122	NTclustered	gi\|1879635015\|gb\|MN737436.1\|	10533	g18427	i0	99.593	99.9878048780488	246	1	100	0	1	246	841	596	Human adenovirus 1 strain QH-1665/2018, complete genome	blastn	24597	449	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
27658029	27658029	PRJNA971676_P_NODE_10304_length_284_cov_1.028436_g10215_i0	PRJNA971676	10304	284	1.028436	2.92075824	Cestrum yellow leaf curling virus	175814	Viruses	Viruses	74.7	3.45e-13	NR	NP_861410.1	175814	g10215	i0	46.1	0.802816901408451	76	41	80.3	0	230	3	3	78	NP_861410.1 putative multifunctional pol protein [Cestrum yellow leaf curling virus]	diamond	228	74.7	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Soymovirus	Soymovirus crispocestri
28131593	28131593	PRJNA971676_P_NODE_12045_length_267_cov_1.309278_g11956_i0	PRJNA971676	12045	267	1.309278	3.49577226	Foot-and-mouth disease virus O	12118	Viruses	Viruses	43.5	0.0203	NR	AEE99079.1	12118	g11956	i0	30.4	0.887640449438202	79	53	86.5	1	27	257	123	201	AEE99079.1 VP1, partial [Foot-and-mouth disease virus O]	diamond	237	43.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Aphthovirus	Aphthovirus vesiculae
28510366	28510366	PRJNA971676_P_NODE_6607_length_335_cov_0.965649_g6518_i0	PRJNA971676	6607	335	0.965649	3.23492415	Blueberry red ringspot virus	172220	Viruses	Viruses	105	2.13e-24	NR	AFE82816.1	172220	g6518	i0	51.6	1.62985074626866	91	44	81.5	0	334	62	188	278	AFE82816.1 movement protein [Blueberry red ringspot virus]	diamond	546	105	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Soymovirus	Soymovirus maculavaccinii

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