contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJEB6584" and tax_phylum = "Preplasmiviricota"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25220057 | 25220057 | PRJEB6584_P_NODE_400_length_245_cov_251.611111_g386_i0 | PRJEB6584 | 400 | 245 | 251.611111 | 616.44722195 | Viruses | 10239 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g386 | i0 | 100 | 1.08163265306122 | 29 | 0 | 12 | 0 | 1 | 29 | 22844 | 22816 | Chrysochromulina parva virophage Larry, complete genome | blastn | 265 | 54.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 25523870 | 25523870 | PRJEB6584i_S_NODE_865_length_293_cov_5.500000_g853_i0 | PRJEB6584 | 865 | 293 | 5.5 | 16.115 | Chrysochromulina parva virophage Curly | 2420054 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g853 | i0 | 100 | 1.75767918088737 | 30 | 0 | 10 | 0 | 1 | 30 | 72 | 101 | Chrysochromulina parva virophage Curly, complete genome | blastn | 515 | 56.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly | |||
| 25525567 | 25525567 | PRJEB6584p_S_NODE_3833_length_212_cov_2152.853107_g3802_i0 | PRJEB6584 | 3833 | 212 | 2152.853107 | 4564.04858684 | Chrysochromulina parva virophage Curly | 2420054 | Viruses | Viruses | 63.9 | 8.61e-6 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g3802 | i0 | 100 | 16.872641509434 | 34 | 0 | 16 | 0 | 179 | 212 | 101 | 68 | Chrysochromulina parva virophage Curly, complete genome | blastn | 3577 | 63.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly | |||
| 25616294 | 25616294 | PRJEB6584p_S_NODE_1977_length_238_cov_312.295567_g1946_i0 | PRJEB6584 | 1977 | 238 | 312.295567 | 743.26344946 | Viruses | 10239 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g1946 | i0 | 100 | 3.72689075630252 | 29 | 0 | 13 | 0 | 1 | 29 | 35 | 63 | Chrysochromulina parva virophage Larry, complete genome | blastn | 887 | 54.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 25659528 | 25659528 | PRJEB6584b_S_NODE_4602_length_184_cov_423.986577_g4584_i0 | PRJEB6584 | 4602 | 184 | 423.986577 | 780.13530168 | Chrysochromulina parva virophage Curly | 2420054 | Viruses | Viruses | 58.4 | 3.37e-4 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g4584 | i0 | 100 | 8.10326086956522 | 31 | 0 | 18 | 0 | 118 | 148 | 101 | 71 | Chrysochromulina parva virophage Curly, complete genome | blastn | 1491 | 58.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly | |||
| 25660381 | 25660381 | PRJEB6584o_S_NODE_14410_length_232_cov_294.126904_g14302_i0 | PRJEB6584 | 14410 | 232 | 294.126904 | 682.37441728 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 52.8 | 0.021 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g14302 | i0 | 100 | 0.120689655172414 | 28 | 0 | 12 | 0 | 22 | 49 | 39 | 66 | Chrysochromulina parva virophage Larry, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 25752182 | 25752182 | PRJEB6584l_S_NODE_12370_length_190_cov_7.522581_g12218_i0 | PRJEB6584 | 12370 | 190 | 7.522581 | 14.2929039 | Viruses | 10239 | Viruses | Viruses | 60.2 | 9.75e-5 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g12218 | i0 | 100 | 17.9842105263158 | 32 | 0 | 17 | 0 | 2 | 33 | 33 | 64 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3417 | 60.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 25797557 | 25797557 | PRJEB6584p_S_NODE_11315_length_188_cov_733.261438_g11284_i0 | PRJEB6584 | 11315 | 188 | 733.261438 | 1378.53150344 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 62.1 | 2.68e-5 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g11284 | i0 | 100 | 18.7234042553191 | 33 | 0 | 18 | 0 | 1 | 33 | 22848 | 22816 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3520 | 62.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 25887940 | 25887940 | PRJEB6584l_S_NODE_1523_length_381_cov_5.427746_g1378_i0 | PRJEB6584 | 1523 | 381 | 5.427746 | 20.67971226 | Viruses | 10239 | Viruses | Viruses | 65.8 | 4.67e-6 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g1378 | i0 | 97.368 | 9.97112860892388 | 38 | 1 | 10 | 0 | 344 | 381 | 103 | 66 | Chrysochromulina parva virophage Curly, complete genome | blastn | 3799 | 65.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly | |||
| 25888284 | 25888284 | PRJEB6584p_S_NODE_2819_length_222_cov_87.037433_g2788_i0 | PRJEB6584 | 2819 | 222 | 87.037433 | 193.22310126 | Viruses | 10239 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g2788 | i0 | 100 | 3.9954954954955 | 29 | 0 | 14 | 0 | 194 | 222 | 63 | 35 | Chrysochromulina parva virophage Larry, complete genome | blastn | 887 | 54.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 25933797 | 25933797 | PRJEB6584p_S_NODE_12060_length_187_cov_390.756579_g12029_i0 | PRJEB6584 | 12060 | 187 | 390.756579 | 730.71480273 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 62.1 | 2.66e-5 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g12029 | i0 | 100 | 17.8930481283422 | 33 | 0 | 18 | 0 | 155 | 187 | 65 | 33 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3346 | 62.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 26067997 | 26067997 | PRJEB6584f_S_NODE_725_length_272_cov_9.168776_g719_i0 | PRJEB6584 | 725 | 272 | 9.168776 | 24.93907072 | Chrysochromulina parva virophage Curly | 2420054 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g719 | i0 | 100 | 0.205882352941176 | 28 | 0 | 10 | 0 | 245 | 272 | 102 | 75 | Chrysochromulina parva virophage Curly, complete genome | blastn | 56 | 52.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly | |||
| 26068757 | 26068757 | PRJEB6584o_S_NODE_16749_length_217_cov_18.912088_g16641_i0 | PRJEB6584 | 16749 | 217 | 18.912088 | 41.03923096 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 52.8 | 0.019 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g16641 | i0 | 100 | 0.129032258064516 | 28 | 0 | 13 | 0 | 187 | 214 | 66 | 39 | Chrysochromulina parva virophage Larry, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 26160722 | 26160722 | PRJEB6584o_S_NODE_7317_length_313_cov_5.338129_g7209_i0 | PRJEB6584 | 7317 | 313 | 5.338129 | 16.70834377 | Viruses | 10239 | Viruses | Viruses | 62.1 | 4.86e-5 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g7209 | i0 | 95 | 11.8753993610224 | 40 | 0 | 12 | 2 | 275 | 313 | 22813 | 22851 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3717 | 62.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 26203932 | 26203932 | PRJEB6584a_S_NODE_4630_length_186_cov_5.582781_g4610_i0 | PRJEB6584 | 4630 | 186 | 5.582781 | 10.38397266 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g4610 | i0 | 96.875 | 0.172043010752688 | 32 | 1 | 17 | 0 | 155 | 186 | 22812 | 22843 | Chrysochromulina parva virophage Larry, complete genome | blastn | 32 | 54.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 26296057 | 26296057 | PRJEB6584f_S_NODE_222_length_385_cov_219.605714_g216_i0 | PRJEB6584 | 222 | 385 | 219.605714 | 845.4819989 | Viruses | 10239 | Viruses | Viruses | 62.1 | 6.11e-5 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g216 | i0 | 95 | 9.06753246753247 | 40 | 0 | 10 | 2 | 346 | 384 | 107 | 69 | Chrysochromulina parva virophage Curly, complete genome | blastn | 3491 | 62.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly | |||
| 26296194 | 26296194 | PRJEB6584l_S_NODE_3710_length_291_cov_54.500000_g3558_i0 | PRJEB6584 | 3710 | 291 | 54.5 | 158.595 | Viruses | 10239 | Viruses | Viruses | 60.2 | 1.61e-4 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g3558 | i0 | 97.143 | 12.1134020618557 | 35 | 1 | 13 | 0 | 1 | 35 | 69 | 103 | Chrysochromulina parva virophage Curly, complete genome | blastn | 3525 | 60.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly | |||
| 26296514 | 26296514 | PRJEB6584p_S_NODE_10662_length_189_cov_211.058442_g10631_i0 | PRJEB6584 | 10662 | 189 | 211.058442 | 398.90045538 | Viruses | 10239 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g10631 | i0 | 100 | 4.69312169312169 | 29 | 0 | 16 | 0 | 161 | 189 | 63 | 35 | Chrysochromulina parva virophage Larry, complete genome | blastn | 887 | 54.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 26340215 | 26340215 | PRJEB6584i_S_NODE_863_length_293_cov_11.406977_g851_i0 | PRJEB6584 | 863 | 293 | 11.406977 | 33.42244261 | Chrysochromulina parva virophage Curly | 2420054 | Viruses | Viruses | 63.9 | 1.26e-5 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g851 | i0 | 95 | 13.2389078498294 | 40 | 2 | 14 | 0 | 254 | 293 | 107 | 68 | Chrysochromulina parva virophage Curly, complete genome | blastn | 3879 | 63.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly | |||
| 26568568 | 26568568 | PRJEB6584p_S_NODE_8536_length_193_cov_3.841772_g8505_i0 | PRJEB6584 | 8536 | 193 | 3.841772 | 7.41461996 | Viruses | 10239 | Viruses | Viruses | 62.1 | 2.76e-5 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g8505 | i0 | 100 | 18.0569948186528 | 33 | 0 | 17 | 0 | 1 | 33 | 32 | 64 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3485 | 62.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry |
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);;