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

10 rows where bioproject = "PRJEB80557" and tax_kingdom = "Orthornavirae"

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
3965177	3965177	PRJEB80557_S_NODE_15964_length_235_cov_1.580645_g15568_i0	PRJEB80557	15964	235	1.580645	3.71451575	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.021	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g15568	i0	100	0.119148936170213	28	0	12	0	1	28	16	43	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
5241615	5241615	PRJEB80557_S_NODE_16185_length_233_cov_3.385870_g15789_i0	PRJEB80557	16185	233	3.38587	7.8890771	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.021	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g15789	i0	100	0.120171673819742	28	0	12	0	1	28	15	42	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
10342014	10342014	PRJEB80557_S_NODE_11489_length_271_cov_2.261261_g11093_i0	PRJEB80557	11489	271	2.261261	6.12801731	Cytospora ribis mitovirus 2	1551549	Viruses	Viruses	114	2.21e-28	NR	AIS37556.1	1551549	g11093	i0	62.1	1.92619926199262	87	33	96.3	0	10	270	168	254	AIS37556.1 RNA-dependent RNA polymerase, partial [Cytospora ribis mitovirus 2]	diamond	522	114	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Cytospora ribis mitovirus 2
11617647	11617647	PRJEB80557_S_NODE_25730_length_190_cov_1.475177_g25334_i0	PRJEB80557	25730	190	1.475177	2.8028363	Tobamovirus tabaci	3432891	Viruses	Viruses	346	6.690000000000001e-91	NTclustered	gi\|1590853289\|gb\|MH595919.1\|	12242	g25334	i0	99.474	100	190	1	100	0	1	190	1056	867	Tobacco mosaic virus isolate Harbin-1, complete genome	blastn	19000	346	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tabaci
15441468	15441468	PRJEB80557_S_NODE_14253_length_247_cov_2.353535_g13857_i0	PRJEB80557	14253	247	2.353535	5.81323145	Cystoviridae sp.	2584979	Viruses	Viruses	416	6.869999999999999e-112	NTclustered	gi\|1799121893\|gb\|MN856105.1\|	2584979	g13857	i0	100	0.910931174089069	225	0	91	0	23	247	1444	1668	Cystoviridae sp. isolate 192, complete genome	blastn	225	416	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae		Cystoviridae sp.
21815833	21815833	PRJEB80557_S_NODE_25898_length_189_cov_2.300000_g25502_i0	PRJEB80557	25898	189	2.3	4.347	Carlavirus latensdianthi	3427766	Viruses	Viruses	52.8	0.016	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g25502	i0	100	0.148148148148148	28	0	15	0	162	189	42	15	Carnation latent virus isolate KL, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
21815952	21815952	PRJEB80557_S_NODE_5178_length_379_cov_2.651515_g4782_i0	PRJEB80557	5178	379	2.651515	10.04924185	Potexvirus pepini	3433856	Viruses	Viruses	649	0	NTclustered	gi\|2862449675\|dbj\|LC852412.1\|	112229	g4782	i0	99.44	91.179419525066	357	2	94	0	23	379	6053	6409	Pepino mosaic virus JKT1 DNA, complete genome	blastn	34557	649	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini
23090935	23090935	PRJEB80557_S_NODE_10459_length_283_cov_2.145299_g10063_i0	PRJEB80557	10459	283	2.145299	6.07119617	Carlavirus latensdianthi	3427766	Viruses	Viruses	52.8	0.026	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g10063	i0	100	0.0989399293286219	28	0	10	0	256	283	43	16	Carnation latent virus isolate KL, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
27128634	27128634	PRJEB80557_S_NODE_10142_length_287_cov_1.987395_g9746_i0	PRJEB80557	10142	287	1.987395	5.70382365	Xinjiang mito-like virus 7	2937216	Viruses	Viruses	87.4	1.26e-17	NR	UPW42224.1	2937216	g9746	i0	50.6	0.909407665505226	87	33	87.8	2	36	287	468	547	UPW42224.1 MAG: putative RNA dependent RNA polymerase [Xinjiang mito-like virus 70]	diamond	261	87.4	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Xinjiang mito-like virus 70
28234183	28234183	PRJEB80557_S_NODE_20386_length_210_cov_2.677019_g19990_i0	PRJEB80557	20386	210	2.677019	5.6217399	Soybean thrips tombus-like virus 1	2802943	Viruses	Viruses	77.8	8.02e-15	NR	QPZ88368.1	2796562	g19990	i0	53.6	2.95714285714286	69	32	98.6	0	2	208	236	304	QPZ88368.1 RNA-dependent RNA polymerase, partial [Soybean thrips tombus-like virus 10]	diamond	621	77.8	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Soybean thrips tombus-like virus 10

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